Using Athena data source connectors
This section lists prebuilt Athena data source connectors that you can use to query a variety of data sources external to Amazon S3. To use a connector in your Athena queries, configure it and deploy it to your account.
Notes
Before you start, note the following points:
-
To use the Amazon Athena Federated Query feature, set your workgroup to Athena engine version 2. For steps, see Changing Athena engine versions.
-
Some prebuilt connectors require that you create a VPC and a security group before you can use the connector. For information about creating VPCs, see Creating a VPC for a data source connector.
-
To use the Athena Federated Query feature with AWS Secrets Manager, you must configure an Amazon VPC private endpoint for Secrets Manager. For more information, see Create a Secrets Manager VPC private endpoint in the AWS Secrets Manager User Guide.
For more information about data source connectors, see the following topics:
-
For information about deploying an Athena data source connector, see Deploying a connector and connecting to a data source.
-
For information about writing queries that use Athena data source connectors, see Writing federated queries.
-
For in-depth information about the Athena data source connectors, see Available connectors
on GitHub.
Data Source Connectors
- Amazon Athena Azure Data Lake Storage (ADLS) Gen2 connector
- Amazon Athena Azure Synapse connector
- Amazon Athena Google BigQuery connector
- Amazon Athena Cloudera Hive connector
- Amazon Athena Cloudera Impala connector
- Amazon Athena CloudWatch connector
- Amazon Athena CloudWatch metrics connector
- Amazon Athena AWS CMDB connector
- Amazon Athena DocumentDB connector
- Amazon Athena DynamoDB connector
- Amazon Athena HBase connector
- Amazon Athena Hortonworks connector
- Amazon Athena MySQL connector
- Amazon Athena Neptune connector
- Amazon Athena OpenSearch connector
- Amazon Athena Oracle connector
- Amazon Athena PostgreSQL connector
- Amazon Athena Redis connector
- Amazon Athena Redshift connector
- Amazon Athena SAP HANA connector
- Amazon Athena Snowflake connector
- Amazon Athena Microsoft SQL Server connector
- Amazon Athena Teradata connector
- Amazon Athena Timestream connector
- Amazon Athena TPC benchmark DS (TPC-DS) connector
- Amazon Athena Vertica connector