Skip to main content
Amazon Athena logo

Amazon Athena

Overview

Amazon Athena serves as an interactive query service, facilitating fast analysis of data directly within Amazon S3. Connect Superblocks to your Athena instance to access your S3 data and harness the power of SQL to execute ad-hoc queries with speed.

Setting up Amazon Athena

1. Add integration

Select Amazon Athena from the integrations page.

2. Configure settings

Fill out the form with the following settings:

SettingRequiredDescription
NameTRUEName that will be displayed to users when selecting this integration in Superblocks
Database NameTRUEName of the database in Amazon Athena to interact with
RegionTRUEAWS region where the database is hosted, e.g. us-east-1
Access Key IDTRUEAccess key ID for your AWS account
Secret KeyTRUESecret access key for your AWS account
Workgroup NameFALSEName of the Workgroup used for permissions
S3 Output LocationFALSEThe query result location to use in Athena
IAM Role ARNFALSEARN of the role for Superblocks to assume for accessing Athena resources

3. Test and save

Click Test Connection to check that Superblocks can connect to the data source.

info

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent).

After connecting successfully, click Create to save the integration.

4. Set profiles

Optionally, configure different profiles for separate development environments.

success

Amazon Athena connected Now you can use Amazon Athena in any Application, Workflow, or Scheduled Job.

Creating Amazon Athena steps

Connect to your Athena integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks Athena integration with read only, read/write, or write only IAM Users. You can then configure a Superblocks Athena step to read from a database, as well as modify/delete data.

info

Superblocks also supports connecting to AWS services with Boto3 in Python steps if you require additional functionality.

Troubleshooting

Check out our guide on common errors across database integrations. If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at help@superblocks.com.