-
Notifications
You must be signed in to change notification settings - Fork 297
Available Connectors
- 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.
- DynamoDB - This connector enables Amazon Athena to communicate with DynamoDB, making your tables accessible via SQL.
- 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.
- ElasticSearch - This connector enabled Amazon Athena to communicate with your elasticsearch instance(s), making your elasticsearch data accessible via SQL.
- HBase - This connector enables Amazon Athena to communicate with your HBase instance(s), making your HBase data accessible via SQL.
- 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.
- Redis - This connector enables Amazon Athena to communicate with your Redis instance(s), making your Redis data accessible via SQL.
- Cloudwatch Logs - This connector enables Amazon Athena to communicate with Cloudwatch, making your log data accessible via SQL.
- Cloudwatch Metrics - This connector enables Amazon Athena to communicate with Cloudwatch Metrics, making your metrics data accessible via SQL.
- TPCDS - This connector enables Amazon Athena to communicate with a source of randomly generated TPC-DS data for use in benchmarking and functional testing.
Something missing? Have an idea for a source we should add? Raise an issue and let us know.
Amazon Neptune and Vertica are currently in-progress and being actively developed in pull requests linked here.
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.
- AthenaElasticsearchConnector
- AthenaDocumentDBConnector
- AthenaDynamoDBConnector
- AthenaAwsCmdbConnector
- AthenaCloudwatchConnector
- AthenaJdbcConnector
- AthenaRedisConnector
- AthenaHBaseConnector
- AthenaTPCDSConnector
- AthenaCloudwatchMetricsConnector
- 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.
- Network connectivity to S3.
- Network connectivity to Athena (for checking query status / preventing overscan).
- Network connectivity to AWS Secrets Manager (if you are using it to store secrets for your connector).
- Network connectivity to AWS Glue DataCatalog (if your connector uses Glue for supplemental or primary metadata).