Create a Snowflake connection

Establish a zero copy connection to an external Snowflake account in Workflow Data Fabric Hub.

Before you begin

You can optimize queries to Snowflake by enabling table statistics. Consult your data source admin to confirm whether table statistics are enabled in Snowflake before enabling this option in Workflow Data Fabric Hub.

Role required: df_connection_admin

About this task

Work with your data source admin to create a connection to Snowflake. For additional information about connecting to Snowflake, refer to the Snowflake documentation.

Procedure

1. Navigate to the available primary connectors in Workflow Data Fabric Hub in one of the following ways:
   • Navigate to All > Workflow Data Fabric Hub > Available connectors > Primary connectors.
   • Navigate to Admin > Workflow Data Fabric Hub > Available connectors > Primary connectors.
2. Find the Snowflake connector and select Connect.
3. On the form, fill in the fields.

   Table 1. New Snowflake Connection form

   Field	Description
   Name and description
   Connection label	Unique name for this connection. This helps in identifying the connection within your system.
   Connection name	System-generated name based on the Connection label. This field cannot be modified once the connection is established.
   Short description	Description of the connection explaining what it is about.
   Connection attributes
   Connection URL	JDBC URL to establish the connection. For example: jdbc:snowflake://<account>.snowflakecomputing.com
   Database	Name of the database that you want to connect to.
   Warehouse	Name of the warehouse that you want to connect to.
   Connection user	Connection user to connect to Snowflake.
   Role	Role that determines your permissions within Snowflake.
   Enable table statistics	Option to enable table statistics. Optimize SQL queries using table statistics by selecting this option. Enabling table statistics allows the system to use estimates of stored data such as row count, distinct values, and data size for enhanced query processing. Note: You must ensure that gathering table statistics is enabled in the data source before selecting this option.

4. Configure secure authentication by uploading a private key file or by entering the private key details manually.

   Option	Description
   Upload private key file	Select Attach Private key. Browse and select the PEM file.
   Enter private key contents manually	Copy and paste the contents of the PEM file, ensuring the content begins with: -----BEGIN PRIVATE KEY----- and ends with: -----END PRIVATE KEY-----

5. Optional: Enter the passphrase if the private key is secured with a password.
6. Select Connect.

Result

A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

What to do next

If the connection succeeds, configure data steward access on the Access Control tab. See Manage access to an established connection using roles.

If the connection fails, verify the connection details with your data source administrator and try again.