--- title: Create a Snowflake connection description: Establish a zero copy connection to an external Snowflake account in Zero Copy Connector Hub. locale: en-US canonical_url: https://www.servicenow.com/docs/r/australia/integrate-applications/create-snowflake-connection-zcc.html release: australia topic_type: task last_updated: "2026-03-12" reading_time_minutes: 3 breadcrumb: [Snowflake, Primary connectors, Zero Copy Connectors, Workflow Data Fabric] --- # Create a Snowflake connection Establish a zero copy connection to an external Snowflake account in Zero Copy Connector 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 Zero Copy Connector 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](https://docs.snowflake.com/en/user-guide/key-pair-auth). ## Procedure 1. Navigate to the available primary connectors in Zero Copy Connector Hub in one of the following ways: - Navigate to **All** > **Zero Copy Connector Hub** > **Available connectors** > **Primary connectors**. - Navigate to **Admin** > **Zero Copy Connector Hub** > **Available connectors** > **Primary connectors**. 2. Find the Snowflake connector and select **Connect**. 3. On the form, fill in the fields.

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://.snowflakecomputing.com`
Database	Name of the database that you want to connect to.
Warehouse	Name of the warehouse that you want to connect to.
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 the authentication method that you want to use with Snowflake.

Option	Description
JWT	Option to use key pair authentication. 1. Attach the private key using one of the following options: - Upload the private key file by selecting Attach PEM file and selecting the file. - Copy and paste the contents of the PEM file, ensuring the content begins with: ``` -----BEGIN PRIVATE KEY----- ``` and ends with: ``` -----END PRIVATE KEY----- ``` 2. Enter the connection user to connect to Snowflake. 3. Enter the passphrase if the private key is secured with a password. 4. Enter the role that determines your permissions within Snowflake.
OAuth	Option to use OAuth authentication. Select the OAuth credential type that you want to use. - Client credentials Select this option to enter OAuth credentials directly from your identity provider. 1. Enter the client ID from your OAuth identity provider. 2. Enter the client secret from your OAuth identity provider. 3. Enter the token request URL from your OAuth identity provider. 4. Enter the scope from your OAuth identity provider. - Access Token Select this option if you created a record in the Application Registries \[oauth\_entity\] table with a Snowflake or IdP service principal for authentication. This option keeps credentials within the instance and uses the ServiceNow AI Platform OAuth framework for token lifecycle management. For details on creating an OAuth entity profile, see . When configuring the profile, select Client Credentials as the grant type. If your OAuth provider requires scopes, add them on the OAuth Entity Scopes tab. Consult your data source or identity provider documentation for the required scope values. Select the OAuth entity profile for your Snowflake or IdP service principal. Select the OAuth integration type that you want to use: - System: Use the selected OAuth entity profile for all users of this connection. This is the default option. - Personal: Require each user to authenticate individually with their own credentials before they can access Snowflake data through this connection. Select Get OAuth Token to open the authentication flow in a new browser tab and sign in. Note: Each user can view, renew, or revoke their personal access token from the Personal Integrations Dashboard in the Zero Copy Connector Hub. If a user's token expires or is missing, an alert appears when that user tries to access data assets for this connection, with a link to sign in again.

Option

Description

**JWT**

Option to use key pair authentication. 1. Attach the private key using one of the following options: - Upload the private key file by selecting **Attach PEM file** and selecting the file. - Copy and paste the contents of the PEM file, ensuring the content begins with: ``` -----BEGIN PRIVATE KEY----- ``` and ends with: ``` -----END PRIVATE KEY----- ``` 2. Enter the connection user to connect to Snowflake. 3. Enter the passphrase if the private key is secured with a password. 4. Enter the role that determines your permissions within Snowflake.

**OAuth**

Option to use OAuth authentication. Select the OAuth credential type that you want to use. - **Client credentials** Select this option to enter OAuth credentials directly from your identity provider. 1. Enter the client ID from your OAuth identity provider. 2. Enter the client secret from your OAuth identity provider. 3. Enter the token request URL from your OAuth identity provider. 4. Enter the scope from your OAuth identity provider. - **Access Token** Select this option if you created a record in the Application Registries \[oauth\_entity\] table with a Snowflake or IdP service principal for authentication. This option keeps credentials within the instance and uses the ServiceNow AI Platform OAuth framework for token lifecycle management. For details on creating an OAuth entity profile, see . When configuring the profile, select **Client Credentials** as the grant type. If your OAuth provider requires scopes, add them on the OAuth Entity Scopes tab. Consult your data source or identity provider documentation for the required scope values. Select the OAuth entity profile for your Snowflake or IdP service principal. Select the OAuth integration type that you want to use: - **System**: Use the selected OAuth entity profile for all users of this connection. This is the default option. - **Personal**: Require each user to authenticate individually with their own credentials before they can access Snowflake data through this connection. Select **Get OAuth Token** to open the authentication flow in a new browser tab and sign in. **Note:** Each user can view, renew, or revoke their personal access token from the Personal Integrations Dashboard in the Zero Copy Connector Hub. If a user's token expires or is missing, an alert appears when that user tries to access data assets for this connection, with a link to sign in again.

5. 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/manage-access-connection-zcc.md). If the connection fails, verify the connection details with your data source administrator and try again.