Data Sources
Warehouses
Google BigQuery

Google BigQuery

Connect Compass to your Google BigQuery data warehouse to analyze data through natural language queries in Slack.

Setup Instructions

  • Sign in to Google Cloud Console
  • Create a service account with BigQuery permissions
  • Download the service account JSON key
  • Copy and paste the JSON content in the connection form

Required BigQuery IAM Roles

  • BigQuery Job User
  • BigQuery Metadata Viewer
  • BigQuery Data Viewer

Network Information

Connection Method: HTTPS over port 443

IP Addresses: 52.25.53.27, 44.242.128.111, 52.35.195.86

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 → Google BigQuery
  3. Enter your connection details:
    • Project ID
    • Service account JSON key (full JSON content)
    • Dataset name (optional)
  4. Click Test Connection to verify
  5. Click Save to complete setup

Need Help?

SnowflakeAWS Athena