Introduction to Amazon Athena Connector

Amazon Athena is a query service that you can use to analyze data in Amazon Simple Storage Service (Amazon S3) by using the standard SQL. Amazon Athena helps you analyze unstructured, semi-structured, and structured data stored in Amazon S3. Amazon Athena stores the schema in a data catalog or AWS Glue data catalog and uses it when you run queries. Amazon Athena uses Apache Hive to create tables and databases.

You can use Amazon Athena Connector to connect to Amazon Athena to read flat files and Parquet files from Amazon S3.

You can read data from views and external tables in the Athena data catalog and AWS Glue data catalog. Use Amazon Athena Connector to read and query Amazon S3 files that are mapped to the Amazon S3 location in an external table.

You can run queries in Amazon Athena on encrypted data in Amazon S3. You must run the Amazon Athena queries in the region where Amazon S3 is hosted. You can also encrypt the Amazon Athena query result stored on Amazon S3.