Documentation Index
Fetch the complete documentation index at: https://docs.trydatawise.com/llms.txt
Use this file to discover all available pages before exploring further.
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.
Create a dedicated Datawise service user in Snowflake rather than using a personal account. This avoids disruption if credentials are rotated.
Required Permissions
-- 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, click Add Connector, and 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
| Field | Description |
|---|
| Database | Restrict ingestion to specific databases by name. |
| Schemas | Add allow or deny patterns. Supports glob syntax (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
| 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. 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.
