Amazon Athena

Set up an Amazon Athena data connection

When inside a workbook, click View > Databases, then click the + icon and follow the on-screen instructions. For more information on how to configure Amazon Athena and how to generate access keys, click here. Make sure the IAM user associated with the credentials has write access to the specified output bucket/folder. The output folder is used to write results of your query to and is ideally separated from the main data in the bucket.

Note: the output bucket should be an s3 url, meaning it should start with s3://

For detailed instructions, see Connect your data to DataLab.

Query the database

You can now query Amazon Athena with a SQL cell. Select it in the Select source dropdown in the top left corner of a SQL cell, or select the sample Amazon Athena connection.

Example of a SQL cell using the MyAthena connection. The query result is available as df1.