Skip to content
Katalogue Docs

Snowflake

Installation

Section titled “Installation”

The Snowflake connector is based on the Snowflake Node.js Driver package and is installed automatically with the Katalogue backend API service.

Authentication

Section titled “Authentication”

Authentication with username and password is supported.

Required Permissions

Section titled “Required Permissions”

By default, Katalogue requires read access to the following resources:

  • INFORMATION_SCHEMA.DATABASES
  • INFORMATION_SCHEMA.SCHEMATA
  • INFORMATION_SCHEMA.VIEWS
  • INFORMATION_SCHEMA.TABLES
  • INFORMATION_SCHEMA.COLUMNS
  • INFORMATION_SCHEMA.TABLE_STORAGE_METRICS
  • SHOW PRIMARY KEYS command
  • SHOW EXPORTED KEYS command

Note that other permissions might be required if custom import queries are used.

Filtering

Section titled “Filtering”

Datasource filters are applied in the source database as a WHERE clause before metadata is fetched, so filtered-out data never leaves the datasource. See Datasource Filters.

Limitations

Section titled “Limitations”

Lineage

Section titled “Lineage”

The Snowflake connector does not provide dataset/table lineage out of the box.