Integrations

Generic JDBC - Snowflake

Support

Being a cloud technology, it is supported up to the most recent version at the time of writing this document, which is the first version of 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 from which metadata is to be extracted.

User or role with SELECT permissions on the tables or views from which a data sample is to be obtained.

Metadata extraction

Below is the Snowflake documentation showing the different fields extracted from the 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 vary from the one extracted by Anjana; review the documentation mentioned above.

Tables with characters in the name

Important → The use of special characters such as “/” in the name of tables or views is NOT recommended, because the sample will not work.