Database Connection Details
Connect databases like Snowflake, BigQuery, and Postgres to build dashboards
Overview
Learn how to connect various databases to build interactive dashboards.
Supported Databases
Relational Databases
- PostgreSQL
- MySQL
Cloud Data Warehouses
- Snowflake
- BigQuery
- Redshift
- AWS Athena
Data Lakehouses
- Databricks
Configuring Database Connections
Each database has a dedicated setup process. Once you enter the configuration values, the AI will automatically begin setting up the data connection and analyzing your data.
Required Configuration
PostgreSQL:
- POSTGRES_URL: Connection URL (connection string)
MySQL:
- MySQL Connection URL: Connection URL (connection string)
Snowflake:
- SNOWFLAKE_USER: Username
- SNOWFLAKE_ACCOUNT: Account identifier
- SNOWFLAKE_KEY_B64: Base64-encoded private key
- SNOWFLAKE_WAREHOUSE: Warehouse name
- SNOWFLAKE_ROLE: Role name
BigQuery:
- GOOGLE_SERVICE_ACCOUNT_JSON: Service account JSON file
- BIGQUERY_PROJECT_ID: Project ID
Redshift:
- AWS Access Key ID: Access key ID
- AWS Secret Access Key: Secret access key
- AWS Region: AWS region
- Database Name: Database name
- Cluster Identifier: Cluster identifier (for Provisioned Cluster)
- Workgroup Name: Workgroup name (for Serverless)
- Secrets Manager ARN: Secrets Manager ARN (for managing credentials)
- Database User: Database username
AWS Athena:
- AWS Access Key ID: Access key ID
- AWS Secret Access Key: Secret access key
- AWS Region: AWS region
- Athena Workgroup: Workgroup name (query execution environment settings)
- S3 Output Location: S3 path for query result output
Databricks:
- Databricks Workspace Host: Workspace hostname
- Databricks Access Token: Access token
- SQL Warehouse HTTP Path: SQL Warehouse HTTP path
Once the connection setup is complete, you can start building dashboards through conversations with the AI!