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