🔌Add an AWS Athena connector

How to connect to an AWS Athena account in Toucan

Connector features

You can use the Toucan AWS Athena connector to connect to your AWS Athena account with a AWS Access key and AWS secret access key and access tables with a SQL query or by using our no-code form .

With this connection, you can fetch data from your AWS Athena account to fill your charts and dashboards.

Changelog

December 23 - this connector is NativeSQL compatible November 2024 - This connector supports hybrid pipelines

July 25 - This data connector is supported for connection and NativeSQL by our new Data Execution system

Configuring an AWS Athena connection

Follow the steps described in Add a connector, choose AWS Athena and fill out the form with the following info:

Field	Format / Type	Description	Example
Name (mandatory)	String	Use it to identify your connection	MyAthenaConnection
S3 Output Bucket (mandatory)	String	the S3 bucket and prefix where results from your queries will be saved	s3://mybucket/athena-queries
AWS Access Key Id (mandatory)	String	the ID of the the AWS access key that will be used to connect to Athena.	AKIAIOSFODNN7EXAMPLE
AWS Secret Access Key (mandatory)	String	the AWS secret access key that will be used to connect to Athena. (will be stored as a secret)	wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY
Region Name (mandatory)	String	the name of the AWS region you need to query.	eu-west-3
Retry Policy (optional)	Boolean	Boolean allows to configure a retry policy if the connection is flaky. max attempts: maximum number of retries before giving up max_delay: in seconds, above the connection is dropped wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)	Integer	Slow queries' cache expiration time in seconds

Click on the TEST CONNECTION button then SAVE the connection

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Depending on your rights, you will have the “Can list databases” checked or not, but note that this doesn’t prevent you to be able to use the connector itself.

Create a dataset from an AWS Athena connection

This data connector is supported in simple and code/SQL mode for our current Data Execution system and new Data Execution systems

To create a dataset from AWS Athena, click on the "create from icon", you will then be able to:

• Select the Database

• Select a table

• Add a Query (optional): you can query using the SQL syntax accepted by Athena

For more info, see the dedicated section Create a new dataset from a dataset

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".