Back to Connectors

Snowflake Connector

Connect to Snowflake to sync metadata, lineage, and access logs.

Prerequisites

  • Snowflake account with ACCOUNTADMIN or SECURITYADMIN privileges
  • Service account with read access to ACCOUNT_USAGE schema

Setup

  1. Create a service account user in Snowflake
  2. Grant the user access to read database metadata
  3. In Zenithdata, navigate to Settings → Connectors → Add Connector
  4. Select Snowflake and enter your credentials

Required SQL Grants

CREATE USER zenithdata_user PASSWORD = 'xxx';
CREATE ROLE zenithdata_role;
GRANT ROLE zenithdata_role TO USER zenithdata_user;
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE zenithdata_role;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE zenithdata_role;

Sync Options

  • Metadata: Tables, views, columns, schemas
  • Lineage: Query history parsing
  • Usage: Access patterns and popularity