Amazon Athena
Amazon Athena is a serverless query service that makes it easy to analyze data stored in Amazon S3. As a development environment in Paradime, Athena enables dbt™️ development from Paradime's Code IDE.
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: Paradime IP addresses.
Setup Instructions
Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "Amazon Athena"
In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section.
After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.
Provide a dbt™ Profile Name (This should match with the profile name set in your
dbt_project.yml
).In the Target field, enter "dev". This is the default target your dbt project will use for development work.
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 number to specify how many parallel operations your dbt project can run.
Example Profile Configuration
Profile Fields Reference
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. This is 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. This is configured in the UI "Threads" field
4
1
❌
num_retries
Number of times to retry a failed query before failing
3
5
❌
Last updated