AWS Redshift

Connect Compass to AWS Redshift to analyze data through natural language queries in Slack.

Setup Instructions

• Contact your AWS administrator for cluster endpoint
• Request a database user account with appropriate permissions
• Ensure your network can reach the Redshift cluster
• Test connection using standard PostgreSQL tools

Required Redshift Permissions

• CONNECT privilege on database – Establish connections
• Valid username and password – Authentication credentials
• USAGE on schema – Access schema objects
• SELECT on information_schema.schemata – List available schemas
• SELECT on pg_tables – List tables in schemas
• SELECT on information_schema.tables – Access table metadata
• SELECT privilege on tables – Query table data for analysis
• SELECT on pg_class and pg_namespace – Access table descriptions

Network Information

Connection Method: PostgreSQL protocol over port 5439

Port: 5439

IP Addresses: 52.25.53.27, 44.242.128.111, 52.35.195.86

May require VPN access or IP allowlisting depending on cluster configuration

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 Redshift
3. Enter your connection details:
   • Host (cluster endpoint)
   • Port (usually 5439)
   • Database name
   • Username
   • Password
   • Schema (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