Available Connectors

Available Connectors

1. AWS CMDB - This connector enables Amazon Athena to communicate with various AWS Services (EC2, RDS, EMR, S3, etc...), making your AWS Resource inventory accessible via SQL.
2. Amazon Timestream - This connector enables Amazon Athena to communicate with Timestream, making your tables accessible via Athena.
3. Amazon Neptune - This connector enables Amazon Athena to communicate with your Amazon Neptune instance(s), making your graph data accessible via SQL.
4. DynamoDB - This connector enables Amazon Athena to communicate with DynamoDB, making your tables accessible via SQL.
5. DocumentDB - This connector enables Amazon Athena to communicate with your DocumentDB instance(s), making your DocumentDB data accessible via SQL. The also works with any MongoDB compatible endpoint.
6. ElasticSearch - This connector enabled Amazon Athena to communicate with your elasticsearch instance(s), making your elasticsearch data accessible via SQL.
7. HBase - This connector enables Amazon Athena to communicate with your HBase instance(s), making your HBase data accessible via SQL.
8. JDBC - This connector enables Amazon Athena to access your JDBC compliant database. At launch this connector supports MySQL, Postgres, and Redshift. For the latest list, check the connector's README.md.
9. Vertica - This connector enables Amazon Athena to run queries over data housed in Vertica instance(s).
10. Redis - This connector enables Amazon Athena to communicate with your Redis instance(s), making your Redis data accessible via SQL.
11. Cloudwatch Logs - This connector enables Amazon Athena to communicate with Cloudwatch, making your log data accessible via SQL.
12. Cloudwatch Metrics - This connector enables Amazon Athena to communicate with Cloudwatch Metrics, making your metrics data accessible via SQL.
13. TPCDS - This connector enables Amazon Athena to communicate with a source of randomly generated TPC-DS data for use in benchmarking and functional testing.
14. Cloudera Hive This connector enables Amazon Athena to communicate with your Cloudera Hive instance(s), making your Cloudera Hive data accessible via SQL.
15. Cloudera Impala This connector enables Amazon Athena to communicate with your Cloudera Impala instance(s), making your Cloudera Impala data accessible via SQL.
16. DataLake Gen 2 (Azure) This connector enables Amazon Athena to communicate with your DataLake Gen 2 (Azure) instance(s), making your DataLake Gen 2 (Azure) data accessible via SQL.
17. Google BigQuery This connector enables Amazon Athena to communicate with your Google BigQuery instance(s), making your Google BigQuery data accessible via SQL.
18. Hortonworks Hive This connector enables Amazon Athena to communicate with your Hortonworks Hive instance(s), making your Hortonworks Hive data accessible via SQL.
19. Oracle This connector enables Amazon Athena to communicate with your Oracle instance(s), making your Oracle data accessible via SQL.
20. SAP HANA This connector enables Amazon Athena to communicate with your SAP HANA instance(s), making your SAP HANA data accessible via SQL.
21. Snowflake This connector enables Amazon Athena to communicate with your Snowflake instance(s), making your Snowflake data accessible via SQL.
22. SqlServer This connector enables Amazon Athena to communicate with your SqlServer instance(s), making your SqlServer data accessible via SQL.
23. Synapse This connector enables Amazon Athena to communicate with your Synapse instance(s), making your Synapse data accessible via SQL.
24. Teradata This connector enables Amazon Athena to communicate with your Teradata instance(s), making your Teradata data accessible via SQL.

Something missing? Have an idea for a source we should add? Raise an issue and let us know.

Deploying 'Official' Athena Connectors

The Amazon Athena team maintains and updates a set of connectors that can 1-Click deployed via Serverless Application Repository. Search for applications published with an Author of Amazon Athena Federation. This author name is reserved exclusively for Amazon Athena. When you see it, you can rest assured that the application was written, tested, and validated by the Amazon Athena team before being made available.

Below are links to Athena's Official Connectors in Severless Application Repository.

• AthenaNeptuneConnector
• AthenaElasticsearchConnector
• AthenaTimestreamConnector
• AthenaDocumentDBConnector
• AthenaDynamoDBConnector
• AthenaAwsCmdbConnector
• AthenaCloudwatchConnector
• AthenaJdbcConnector
• AthenaRedisConnector
• AthenaHBaseConnector
• AthenaTPCDSConnector
• AthenaCloudwatchMetricsConnector
• AthenaOracleConnector
• AthenaGoogleBigQueryConnector
• AthenaSqlServerConnector
• AthenaSynapseConnector
• AthenaDataLakeGen2Connector
• AthenaSnowflakeConnector
• AthenaSaphanaConnector
• AthenaClouderaHiveConnector
• AthenaClouderaImpalaConnector
• AthenaHortonworksHiveConnector
• AthenaTeradataConnector
• AthenaUserDefinedFunctions

You can of course choose to build and deploy your own copy of these connectors from source by getting a copy of the code in this repository and then using our Connector Publish Tool to create your own Serverless Application Repository package.

Many connectors in this repository require access to the following AWS services in order to function correctly, please read the documentation for the connector you are deploying and then ensure you've configured your VPC accordingly.

1. Network connectivity to S3.
2. Network connectivity to Athena (for checking query status / preventing overscan).
3. Network connectivity to AWS Secrets Manager (if you are using it to store secrets for your connector).
4. Network connectivity to AWS Glue DataCatalog (if your connector uses Glue for supplemental or primary metadata).