Skip to content

Snowflake

Snowflake is generally available in the DataSquares connection wizard. Connect with your account identifier and a virtual warehouse.

  1. In DataSquares, open Data Sources and choose Add data source.

  2. Pick Snowflake in the connector picker (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

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.

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.

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;
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