Book a demo
Amazon Athena
A
Amazon Athena

target-athena (meltanolabs variant)

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.

Meltano Cloud Connector

Amazon Athena connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Get in touchBook a demo
Why Meltano?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.
Resources
View source code