Create a Snowflake JDBC connection

To integrate Snowflake, you need a JDBC connector to connect your Snowflake instance to Collibra.

Prerequisites

You've completed the preflight checklist.

Steps

1. Open a site.
   1. On the main toolbar, click → Settings.
      The Settings page opens.
   2. In the tab pane, click Edge.
      The Sites tab opens and shows a table with an overview of your sites.
   3. In the site overview, click the name of a site.
      The site page appears.
2. In the JDBC Connections section, click Create Connection.
   The Create Connection dialog box appears.
3. Click the Generic JDBC connection connection type.
   Important 

   • If the authentication method you use includes the username and password properties, you can use either the Generic or Username/Password JDBC connection type. If you use the Generic JDBC connection type, add the username and password properties manually.
   • After creating a Generic JDBC Connection, you can update your connection to use a different authentication method if needed. However, if you initially use the Username/Password JDBC connection type and want to change to another authentication method, you must create a new connection by using the Generic JDBC Connection.
     

     Snowflake-specific behavior
     For Snowflake, if you initially use the Username/Password JDBC connection type, you can switch to a key pair authentication method by updating the existing connection. You do not need to create a new connection. Existing metadata and lineage are preserved.
     To upload the private key file, it must be in PKCS#8 format. PBE-SHA1-3DES and PBE-SHA1-RC4-128 are supported.

4. Enter the required information.

   Make sure you add the user in the JDBC Edge connection that has the minimum user permissions to read the metadata from the source.

   Field	Description
   Connection settings	This section contains the settings to connect to your data source.
   Name	The name of the JDBC connection. Note We recommend not to use the special character > in the JDBC connection name. This character is part of the full name of assets created via Edge. If you use this character, features such as sampling or classification can be impacted.
   Description	The description of the JDBC connection. This field is also visible when you register content.
   Vault	The vault whose secrets you want to use to fill out fields. This field is only available if one or more vaults have been configured for your Edge site.
   Connection parameters	This section contains general settings to connect to your data source.
   Driver class name	The driver class name of the connection. In the case of , enter this:
   Driver jar	The JAR file contains the JDBC driver. Click Upload to upload a JAR file.
   Additional classpath files	Any additional classpath files that you want to upload. Use this field if you want to upload more than one driver file.
   Connection string	The JDBC connection string. In the case of , enter this: You can add this property from your vault. For more information, go to the vault documentation. Warning Some connection properties can be added to the URL as name-value pairs separated by semicolons. However, most properties in the URL are ignored. Therefore, we recommend you not to use this mechanism unless we explicitly ask you to. We recommend you to specify all connection properties in the Connection properties section.
   Property	This section contains the connection properties. You can add this property from your vault. For more information, go to the vault documentation.

5. Click Create.

All available properties

For more information on the connection details of Snowflake, go to the Snowflake website.

What's next

Add the Catalog JDBC ingestion capability for Snowflake