AWS Athena

Connect Compass to AWS Athena to analyze data through natural language queries in Slack. Athena supports both Trino SQL and Spark SQL query engines.

Setup Instructions

• Create an IAM user in AWS Console
• Attach appropriate Athena and Glue policies
• Generate access keys for the IAM user
• Create an S3 bucket for query results

Required AWS IAM Permissions

• athena:StartQueryExecution – Run SQL queries
• athena:GetQueryExecution – Monitor query status
• athena:GetQueryResults – Retrieve query results
• s3:ListBucket – Browse data locations
• s3:PutObject – Write query results to S3
• s3:GetObject – Read query results from S3
• glue:GetDatabases – List available databases
• glue:GetDatabase – Read database metadata
• glue:GetTables – List tables in databases
• glue:GetTable – Read table schema and metadata

Network Information

Connection Method: HTTPS over port 443

Connects to AWS API endpoints – no specific firewall rules needed

Connecting to Compass

1. Go to dagstercompass.com/login (opens in a new tab) or type !admin in your Compass Slack channel
2. Click Add Connection → AWS Athena
3. Enter your connection details:
   • AWS Access Key ID
   • AWS Secret Access Key
   • AWS Region
   • S3 Output Location (for query results)
   • Database name (optional)
4. Click Test Connection to verify
5. Click Save to complete setup

Need Help?

• Connection issues: compass-support@dagsterlabs.com
• All data sources: Data Sources overview