Search results
People also ask
Can I Run SQL queries using Amazon Athena?
How do I run a SQL query in Athena?
How do I use Athena SQL in Amazon S3?
How does a query work in Athena?
You can run SQL queries using Amazon Athena on data sources that are registered with the AWS Glue Data Catalog and data sources such as Hive metastores and Amazon DocumentDB instances that you connect to using the Athena Federated Query feature.
- Querying Across Regions
Data access permissions – To successfully query Amazon S3...
- Viewing Query Stats
After you run a query, you can get statistics on the input...
- Viewing Query Plans
You can use the Athena query editor to see graphical...
- Querying JSON
Query JSON data in Athena. AWS Documentation Amazon Athena...
- Using Saved Queries
Use the Athena console to save, edit, run, rename, and...
- Handling Schema Updates
Athena is a schema-on-read query engine. This means that...
- Querying Arrays
Amazon Athena lets you create arrays, concatenate them,...
- Querying AWS Service Logs
Amazon Athena is an interactive query service that makes it...
- Querying Across Regions
For information about using SQL that is specific to Athena, see Considerations and limitations for SQL queries in Amazon Athena and Run SQL queries in Amazon Athena. For an example of creating a database, creating a table, and running a SELECT query on the table in Athena, see Get started .
You can use Athena SQL to query your data in-place in Amazon S3 using the AWS Glue Data Catalog, an external Hive metastore, or federated queries using a variety of prebuilt connectors to other data sources.
Oct 15, 2020 · To run a query you use StartQueryExecution and pass the SQL you want to run, as well as an S3 location where Athena can write the results – since queries are run asynchronously Athena needs somewhere to store the results so that you can ask for them later.
Jul 2, 2023 · Athena itself - This is the execution engine that Athena uses to query your data. Originally, Athena was powered by Presto, a distributed query engine that was open sourced by Facebook. Today, Athena uses a derivative of that engine known as Trino and can also run queries using the open source Apache Spark engine. A lot changes in 7 years. 😁
Nov 30, 2016 · You can run your queries from the AWS Management Console or from a SQL clients such as SQL Workbench, and you can use Amazon QuickSight to visualize your data. You can also download and use the Athena JDBC driver and run queries from your favorite Business Intelligence tool.
Nov 30, 2016 · Athena uses Presto, a distributed SQL engine to run queries. It also uses Apache Hive to create, drop, and alter tables and partitions. You can write Hive-compliant DDL statements and ANSI SQL statements in the Athena query editor.