Create Snowflake connection
After configuring Snowflake permissions for Data Access, create a Snowflake connection from an Edge or Collibra Cloud site to the Snowflake data source. This connection acts as a bridge between Data Access and your underlying data source.
Prerequisites
Steps
- Open the Edge or Collibra Cloud site:
-
On the main toolbar, click
> Settings.
The Settings page opens. -
In the Edge section, click Sites.
- Click the name of the site.
-
On the main toolbar, click
- Click Create Connection.
- In the Create Connection dialog box, select Snowflake.
- Enter the required information, and then click Create.
Field Description Name A unique name for the Snowflake connection. Description (optional) A brief explanation of the connection's purpose.
Vault (optional) A reference to a secure credential store from which the Snowflake credentials are retrieved at runtime. Account The Snowflake account identifier in the format org-account. This field also accepts legacy formats such as xy123.eu-west-1. Authentication Type The type of authentication that is used to connect to Snowflake. Username The username to authenticate against the Snowflake account. Private Key File (optional) The file path containing the private key that is used for key-pair authentication with Snowflake. Use either this field or the Password field for authentication. Private Key Passphrase (optional) The passphrase to decrypt the private key, if the private key file is encrypted.
Password (optional) The password for the Snowflake user. Use either this field or the Private Key File field for authentication. Programmatic Access Token (PAT) The PAT that is generated for the authentication.
Role The Snowflake sync role to assume when running data extraction and synchronization queries. If you do not specify a value, the ACCOUNTADMIN role is used by default. Warehouse The Snowflake warehouse to use to run data extraction queries. If you do not specify a value, the user's default warehouse is used.
The Snowflake connection is created.