Athena Connector - Catalog, Transform, Query, Visualize

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 the Promethium Enterprise edition. The Athena connector is currently not available for the Free or Professional editions.


If you don't have a Promethium account, get your free account now

Jump to the how to video.


Connect Athena

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 Database.

Image of Athena connection in Promethium
Athena Connection

Athena connection details can be case-sensitive. Ensure that data is entered with the correct case for your Athena.

Field

Description

Data Source Name

Give the Athena connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Data Source Topic

Optional. Categorize the Athena connection. For example, Marketing.

AWS Access Key

Unique Key for AWS Athena database

AWS Secret Key

Unique Secret for AWS Athena database

S3 Output Location

Indicate the location where the query output files are downloaded. Athena will cache all query results in this location.

AWS Region

Enter the region endpoint of your Athena instance. To find the region code from a region name.

Catalog Name

Enter the password associated with your Athena account.

Database Name

Enter the database containing the data you want to retrieve.


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 Data Cloud.

Screenshot of Athena data in Promethium
Athena Data Catalog Promethium

FAQs

Is my data moved or copied out of Athena?

No. Your data stays in Athena and isn't moved to Promethium.


What options are available for publishing datasets?

Datasets can be published as a view or as a dbt model.


Is this a Production-level connector?

Yes. The Athena connector is designed for all-sized Datasets.


Watch how to video


31 views