Posted On: Apr 21, 2022
Today we are announcing the general availability of 10 new data source connectors for Amazon Athena. With Athena, you can query data stored in relational, non-relational, object, and custom data sources without the need for ETL scripts to pre-process or copy data. This release expands the number of data sources you can query with Athena and helps analysts, data engineers, data scientists, and developers unlock business value from data stored in databases running on-premises or in the cloud.
You can now use Athena to query and surface insights from: SAP HANA (Express Edition), Teradata, Cloudera, Hortonworks, Snowflake, Microsoft SQL Server, Oracle, Azure Data Lake Storage (ADLS) Gen2, Azure Synapse, and Google BigQuery. For a complete list of supported data sources, see Using Athena Data Source Connectors.
With Athena, you can use your SQL knowledge to support a wide range of analytics use cases: you can run interactive queries on data stored in multiple systems of record, create unified datasets to enable self-service business intelligence, prepare input features for use in machine learning model training, build analytics solutions on top of on-premises data, and more.
Today’s release greatly expands the number of data sources you can query and is available in all commercial and GovCloud AWS Regions where Athena is supported. To coincide with this release, we enhanced the Athena console to make it easier to browse available sources and connect to your data in fewer steps. You can now search, sort, and filter the available connectors on the console and follow the guided steps to connect to your data. To learn more about today’s release, see Query 10 New Data Sources with Amazon Athena and Using Amazon Athena Federated Query.
There are no additional charges to use Athena’s data source connectors but standard rates for data scanned, Lambda usage, and other services apply. For more information on Athena pricing, visit the pricing page.