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 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 connectors that do not support predicate pushdown, queries that include a predicate take significantly 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 Athena and federated table name qualifiers.
Additional information
-
For information about deploying an Athena data source connector, see Deploying a data source connector.
-
For information about queries that use Athena data source connectors, see Running federated queries.
-
For in-depth information about the Athena data source connectors, see Available connectors
on GitHub.
Athena data source connectors
Note
The AthenaJdbcConnector