Available data source connectors

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:

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.