Using Athena SQL

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.

You can also:

• Connect to business intelligence tools and other applications using Athena's JDBC and ODBC drivers.

• Query AWS 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.

• 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
• Getting started
• Connecting to data sources
• Connecting to Amazon Athena with ODBC and JDBC drivers
• Creating databases and tables
• Creating a table from query results (CTAS)
• SerDe reference
• Running SQL queries using Amazon Athena
• Using Athena ACID transactions
• Amazon Athena security
• Workload management
• Athena engine versioning
• SQL reference for Athena
• Troubleshooting in Athena
• Code samples