Snowflake

Snowflake

  • Purpose: Connect to Snowflake cloud data warehouse for scalable analytics.
  • When to use it: Best for teams centralizing data in Snowflake and wanting live dashboards without data movement.
  • How to create it:
    1. Go to Data Sources and click Add.
    2. Select Snowflake.
    3. Name: Enter a unique name for this connection.
    4. Account: Your Snowflake account identifier (e.g., xy12345.us-east-1 — found in your Snowflake URL).
    5. Username / Password: Snowflake user credentials.
    6. Database: The Snowflake database to connect to.
    7. Schema: Default is PUBLIC.
    8. Warehouse: The virtual warehouse to use for queries (e.g., COMPUTE_WH).
    9. Role: (Optional) Snowflake role to use (e.g., SYSADMIN, REPORTER).
    10. Click Test Connection to verify, then Save.

Snowflake Configuration

Note: The Snowflake user must have USAGE privilege on the warehouse, database, and schema, plus SELECT on the tables to query.