Integrations
Breadcrumbs

Generic JDBC - Snowflake

Support

As it is cloud technology, support is provided up to the most recent version at the time of writing this document, which is the first version from October 2025.

Configuration

Vendor

SNOWFLAKE

Connection format

The connection URL format is jdbc:snowflake://<orgname>-<account>.snowflakecomputing.com/?db=<database>&warehouse=<warehouse>&JDBC_QUERY_RESULT_FORMAT=JSON

Permissions

User or role with USAGE permissions on the database and schema where the tables/views to be governed are located.

User or role with REFERENCE permissions on the tables or views for which metadata extraction is desired.

User or role with SELECT permissions on the tables or views for which data sampling is desired.

Metadata extraction

Below is the Snowflake documentation showing the different fields extracted from tables *:

https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-api#object-databasemetadata

Important → For some column types, the length observed in the table may differ from that extracted by Anjana; see the documentation referenced above.

Tables with characters in their name

Important → The use of special characters such as “/” in table or view names is NOT recommended because the sample will not work.