Snowflake
Snowflake is generally available in the DataSquares connection wizard. Connect with your account identifier and a virtual warehouse.
-
In DataSquares, open Data Sources and choose Add data source.
-
Pick Snowflake in the connector picker (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Account identifier | Your Snowflake account identifier (e.g. xy12345.eu-central-1). |
| Warehouse | The virtual warehouse queries should run on. |
| Role | Optional — a role with read access to the databases you want to analyze. |
| Database | The database to connect to. |
| Username / Password | Credentials for the connecting user. |
Finding your account identifier
Section titled “Finding your account identifier”Use the account identifier from Snowsight (Admin → Accounts), in the
orgname-account_name form — or the legacy locator form like
xy12345.eu-central-1. Don’t include .snowflakecomputing.com.
Grant what the role needs
Section titled “Grant what the role needs”The connecting user’s role needs usage on the warehouse and database, plus read on the schemas:
CREATE ROLE IF NOT EXISTS DATASQUARES_READER;GRANT USAGE ON WAREHOUSE analytics_wh TO ROLE DATASQUARES_READER;GRANT USAGE ON DATABASE analytics TO ROLE DATASQUARES_READER;GRANT USAGE ON ALL SCHEMAS IN DATABASE analytics TO ROLE DATASQUARES_READER;GRANT SELECT ON ALL TABLES IN DATABASE analytics TO ROLE DATASQUARES_READER;GRANT ROLE DATASQUARES_READER TO USER datasquares;Common errors
Section titled “Common errors”| Error | Cause / fix |
|---|---|
Incorrect username or password |
also raised for a wrong account identifier — verify it first |
No active warehouse |
the role lacks USAGE on the warehouse named in the form |
Object does not exist or not authorized |
missing database/schema grants for the role |
| network error from a corporate account | a Snowflake network policy may need to allowlist the DataSquares server’s IP |
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.