Connect Database

Overview

Learn how to connect various databases and build powerful dashboards.

Supported Databases

• Snowflake
• BigQuery
• PostgreSQL
• Other databases

Setting Up Database Connection

For Snowflake, BigQuery, and PostgreSQL, dedicated setup processes are available. Select the setup task from the "Tasks" in the AI chat on the editor screen.

Once you enter the configuration values, AI will automatically start setting up the data connection and analyzing the data.

Required Configuration Values

• Snowflake:
  • SNOWFLAKE_USER: Username
  • SNOWFLAKE_ACCOUNT: Account identifier
  • SNOWFLAKE_KEY_B64: Base64-encoded private key
  • SNOWFLAKE_WAREHOUSE: Warehouse name to use
  • SNOWFLAKE_ROLE: Role name to use
• BigQuery:
  • GOOGLE_SERVICE_ACCOUNT_JSON: Service account JSON file
  • BIGQUERY_PROJECT_ID: Project ID
• PostgreSQL:
  • POSTGRES_URL: Connection URL (connection string)

---

Once the connection setup is complete, you can build dashboards while conversing with AI!