The Athena connector allows data to be cataloged, queried, transformed and more in Athena. This can be used to quickly and easily join data between different systems like Athena and Hive, or between different Athena instances.
The Athena connector is available for these Promethium editions:
Connecting to Athena is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Athena and enter the information for your Athena.
Athena Connection Configuration
Athena connection details can be case-sensitive. Ensure that data is entered with the correct case for your Athena.
Data Source Name
Give the Athena Connection a unique name for easy identification.
Optional. A meaningful description for this connection.
AWS Access Key
Unique Key for AWS Athena
AWS Secret Key
Unique Secret for AWS Athena
S3 Output Location
Indicate the location where the query output files are downloaded. Athena will cache all query results in this location.
Enter the region endpoint of your Athena instance. To find the region code from a region name.
Enter the schema containing the data you want to retrieve.
Data Source Topic
Optional. Categorize the Athena connection. For example, Marketing.
What Happens Next - Finish Athena Connection
Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Athena, then make the data easily searchable and usable.
Click Data Explorer from the menu and begin exploring the data in your Athena.
Athena Data Catalog Promethium
Is my data moved or copied?
No. Your data stays where is is and isn't moved to Promethium.
What options are available for publishing datasets?
Datasets can be published as a view, table or as a dbt model.
Is this a Production-level connector?
Yes. The Athena connector is designed for all-sized Datasets.