Amazon Athena - Paradime

Amazon Athena is a serverless query service that makes it easy to analyze data stored in Amazon S3. Connect it to Paradime to develop dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent run dbt™ models and queries during background sessions.

IP restrictionsMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.See also: Paradime IP addresses.

Available in: Code IDE, Bolt, and Agent environments.

Add a connection

Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
In the left sidebar, click Environments.
Click Add New next to the section for the environment you are configuring:
- Code IDE for the Code IDE connection
- Bolt for the Bolt connection
- Agent for the Agent connection
Select Amazon Athena.
In the Profile Configuration field, add at least the required parameters. For additional options, see Profile fields reference.
Provide a dbt™ Profile Name. This should match the profile name set in your dbt_project.yml.
In the Target field, enter dev for Code IDE, prod for Bolt, or dinoai for the Agent environment.
The Schema field is pre-configured, but you can change it to specify the schema where dbt™ will build objects.
The Threads value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

After adding the configuration, ensure it’s properly formatted using a YAML formatter like YAML Formatter.

Profile configuration

s3_staging_dir: s3://analytics-staging/athena/query-results/   # Store query results
s3_data_dir: s3://analytics-data/raw/                          # Raw data location
s3_data_naming: table_unique                                   # Unique table naming
region_name: us-west-2                                         # AWS region
database: analytics_prod                                       # Production database
num_retries: 3                                                 # Query retry attempts

Important notes

All S3 paths should end with a forward slash (/).
AWS credentials can be configured through environment variables, AWS credentials file, or IAM roles.

Profile fields reference

Field	Description	Example	Default	Required
s3_staging_dir	S3 bucket location where Athena will store query results	`s3://my-bucket/athena/staging/`	None	✅
s3_data_dir	S3 bucket location where Athena will store table data	`s3://my-bucket/athena/data/`	None	✅
s3_data_naming	Naming convention used when writing to S3	`table_unique`	None	❌
region_name	AWS region where your Athena instance is located	`us-east-1`	None	✅
database	Name of the Athena database to connect to	`analytics_db`	None	✅
schema	Default schema where dbt™ will build objects. Configured in the UI Schema field	`reporting`	None	✅
aws_profile_name	Profile name from your AWS shared credentials file	`default`	None	❌
threads	Number of concurrent operations. Configured in the UI Threads field	`4`	`1`	❌
num_retries	Number of times to retry a failed query before failing	`3`	`5`	❌

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Add a connection

​Profile configuration

​Profile fields reference

​Related

Optional connection attributes

Add a connection

Profile configuration

Profile fields reference

Related