Amazon Athena is a serverless interactive query service that enables users to analyze data in Amazon S3 using standard SQL.

Amazon Athena allows users to easily analyze data stored in Amazon S3 using standard SQL queries. It is a serverless service, meaning that users do not need to manage any infrastructure or servers. Instead, they simply point Athena at their data stored in S3 and run SQL queries to extract insights. Athena is designed to handle large datasets and can scale automatically to accommodate growing data volumes. It also integrates with other AWS services, such as Amazon QuickSight, to provide users with powerful data visualization capabilities. Overall, Amazon Athena is a powerful tool for data analysts and data scientists looking to extract insights from large datasets stored in Amazon S3.

Settings

Athena Database

The name of the database in Amazon Athena to connect to.

AWS Region

The AWS region where the Amazon Athena API is located.

AWS S3 Access Key ID

The access key ID for the AWS S3 bucket used for storing data.

AWS S3 Secret Access Key

The secret access key for the AWS S3 bucket used for storing data.

AWS S3 Session Token

The session token for the AWS S3 bucket used for storing data.

AWS profile name

The name of the AWS profile to use for authentication.

Bucket

The name of the AWS S3 bucket used for storing data.

S3 Key Prefix

The prefix to use for S3 keys when storing data.

S3 Staging Directory

The S3 directory to use for temporary files when querying data.

Delimiter

The delimiter used in the data being queried.

Quote Character

The character used to quote fields in the data being queried.

Add Record Metadata

Whether or not to add metadata to the records returned by the query.

Encryption Type

The type of encryption used for data stored in the S3 bucket.

Encryption Key

The encryption key used for data stored in the S3 bucket.

Compression

The compression format used for data stored in the S3 bucket.

Naming Convention

The naming convention used for temporary files created during query execution.

Temp Directory

The local directory to use for temporary files during query execution.

Object Format

The format of the objects stored in the S3 bucket.

Flattten Records

Whether or not to flatten nested records in the data being queried.