Available 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.
Considerations and limitations
-
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 Create a VPC for a data source connector or AWS Glue connection.
-
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 connectors that do not support predicate pushdown, queries that include a predicate take longer to execute. For small datasets, very little data is scanned, and queries take an average of about 2 minutes. However, for large datasets, many queries can time out.
-
Some federated data sources use terminology to refer data objects that is different from Athena. For more information, see Understand federated table name qualifiers.
-
We update our connectors periodically based on upgrades from the database or data source provider. We do not support data sources that are at end-of-life for support.
-
For connectors that do not support pagination when you list tables, the web service can time out if your database has many tables and metadata. The following connectors provide pagination support for listing tables:
-
DocumentDB
-
DynamoDB
-
MySQL
-
OpenSearch
-
Oracle
-
PostgreSQL
-
Redshift
-
SQL Server
-
Additional information
-
For information about deploying an Athena data source connector, see Use Amazon Athena Federated Query.
-
For information about queries that use Athena data source connectors, see Run federated queries.
Athena data source connectors
- Azure Data Lake Storage
- Azure Synapse
- Cloudera Hive
- Cloudera Impala
- CloudWatch
- CloudWatch metrics
- CMDB
- Db2
- Db2 iSeries
- DocumentDB
- DynamoDB
- Google BigQuery
- Google Cloud Storage
- HBase
- Hortonworks
- Kafka
- MSK
- MySQL
- Neptune
- OpenSearch
- Oracle
- PostgreSQL
- Redis OSS
- Redshift
- SAP HANA
- Snowflake
- SQL Server
- Teradata
- Timestream
- TPC-DS
- Vertica
Note
The AthenaJdbcConnector