Use 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 AI.
-
Query using your own user-defined functions.
-
Speed up query processing of highly-partitioned tables and automate partition management by using partition projection.