Use Athena SQL
You can use Athena SQL to query your data in-place in Amazon S3 using the Amazon Glue Data Catalog, an external Hive metastore, or federated queries using a variety of prebuilt connectors to other data sources.
You can also:
-
Connect to business intelligence tools and other applications using Athena's JDBC and ODBC drivers.
-
Query Amazon service logs.
-
Query Apache Iceberg tables, including time travel queries, and Apache Hudi datasets.
-
Query geospatial data.
-
Query using machine learning inference from Amazon SageMaker AI.
-
Query using your own user-defined functions.
-
Speed up query processing of highly-partitioned tables and automate partition management by using partition projection.
Topics
- Understanding tables, databases, and data catalogs in Athena
- Get started
- Connect to data sources
- Connect to Amazon Athena with ODBC and JDBC drivers
- Create databases and tables
- Create a table from query results (CTAS)
- Use SerDes
- Run SQL queries in Amazon Athena
- Use Athena ACID transactions
- Amazon Athena security
- Workload management
- Athena engine versioning
- SQL reference for Athena
- Troubleshoot issues in Athena
- Code samples