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:
| Setting | Required | Description |
|---|---|---|
| Name | TRUE | Name that will be displayed to users when selecting this integration in Superblocks |
| Database Name | TRUE | Name of the database in Amazon Athena to interact with |
| Region | TRUE | AWS region where the database is hosted, e.g. us-east-1 |
| Access Key ID | TRUE | Access key ID for your AWS account |
| Secret Key | TRUE | Secret access key for your AWS account |
| Workgroup Name | FALSE | Name of the Workgroup used for permissions |
| S3 Output Location | FALSE | The query result location to use in Athena |
| IAM Role ARN | FALSE | ARN 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.
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.
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.
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.