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 | ✓ | Name that will be displayed to users when selecting this integration in Superblocks |
| Database Name | ✓ | Name of the database in Amazon Athena to interact with |
| Region | ✓ | AWS region where the database is hosted, e.g. us-east-1 |
| Access Key ID | ✓ | Access key ID for your AWS account |
| Secret Key | ✓ | Secret access key for your AWS account |
| Workgroup Name | ✗ | Name of the Workgroup used for permissions |
| S3 Output Location | ✗ | The query result location to use in Athena |
| IAM Role ARN | ✗ | 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 Hybrid or Cloud-Prem deployments).
4. Set data tags
Optionally, configure different data tags for separate development environments.Amazon Athena connected!
You can now use Clark to build with Amazon Athena.
You can now use Clark to build with Amazon Athena.
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.