🔌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

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

Last updated

Was this helpful?