Snowflake

Connect Datawise to Snowflake to enable Schema Radar detection and warehouse-level lineage.

Prerequisites

Before connecting, make sure you have:

A Snowflake account with a user that has USAGE on the target warehouse and SELECT on INFORMATION_SCHEMA in the target databases.
The account identifier for your Snowflake instance (format: orgname-accountname or the legacy account.region format).
The warehouse name, role, username, and password for the connecting user.

We recommend creating a dedicated Datawise service user in Snowflake rather than using a personal account. This avoids disruption if credentials are rotated.

Required Permissions

Grant the following to your Datawise Snowflake user:

-- Create a dedicated role
CREATE ROLE datawise_role;

-- Grant warehouse usage
GRANT USAGE ON WAREHOUSE <your_warehouse> TO ROLE datawise_role;

-- Grant database and schema access
GRANT USAGE ON DATABASE <your_database> TO ROLE datawise_role;
GRANT USAGE ON ALL SCHEMAS IN DATABASE <your_database> TO ROLE datawise_role;
GRANT SELECT ON ALL TABLES IN DATABASE <your_database> TO ROLE datawise_role;
GRANT SELECT ON ALL VIEWS IN DATABASE <your_database> TO ROLE datawise_role;

-- Grant future access
GRANT SELECT ON FUTURE TABLES IN DATABASE <your_database> TO ROLE datawise_role;
GRANT SELECT ON FUTURE VIEWS IN DATABASE <your_database> TO ROLE datawise_role;

-- Assign role to user
GRANT ROLE datawise_role TO USER <your_datawise_user>;
ALTER USER <your_datawise_user> SET DEFAULT_ROLE = datawise_role;

Connection Setup

Go to Connectors in the left navigation and click Add Connector, then select Snowflake.

Required Fields

Field	Description
Account ID	Your Snowflake account identifier. Find this in Snowflake under Admin > Accounts. Example: `xy12345.us-east-1`
Warehouse	The Snowflake virtual warehouse Datawise uses to run queries.
Username	The Snowflake user Datawise connects as.
Password	Password for the above user.
Role	The Snowflake role assigned to the connecting user.
Name	A display name for this connector in Datawise.

Filters

Use filters to control which databases and schemas Datawise ingests. Leave empty to ingest everything the user has access to.

Field	Description
Database	Restrict ingestion to specific databases by name.
Schemas	Add allow or deny patterns to include or exclude schemas. Supports glob patterns (e.g., `prod_*`).

Settings

Setting	Default	Description
Include Tables	On	Ingest table metadata and schema.
Include Views	On	Ingest view metadata.
Enable Table Profiling	Off	Collect row counts and column statistics. Increases query load.

Schedule

Configure how often Datawise syncs with Snowflake.

Field	Description
Run on a schedule	Recommended. Without a schedule, schema data goes stale between manual syncs.
Schedule	Cron-style schedule. Default: every day at 00:00.
Timezone	The timezone used to evaluate the schedule.

Testing the Connection

After filling in your credentials, click Test Connection. Datawise verifies it can authenticate and reach the specified warehouse. If the test fails, check:

The account identifier format. Common issue: using account.region when your org uses the newer orgname-accountname format.
That the role is granted and set as the default for the user.
That the warehouse is not suspended and the user has USAGE on it.

After Connecting

Once connected and the first ingestion runs:

Tables and views from the connected schemas appear in Data Assets.
Schema Radar begins detecting schema changes on your configured schedule.
Lineage from Snowflake populates when dbt Cloud is also connected.

Trigger a manual sync at any time from the Connectors page by clicking Run Now next to the Snowflake connector.