Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2024-11-01
Create a Snowflake Connection

Create a Snowflake Connection

Security:
Prism: Manage Connection
 domain in the Prism Analytics functional area.
You can create a Snowflake connection and use it as a source in a data change task.
After you create a connection, Workday displays it on the
Connections
 tab of the
Data Catalog
 report. You can right-click the connection to view or edit it.
  1. Navigate to the
    Data Catalog
    .
  2. Select
    Create
    Connection
    .
  3. Select
    Snowflake
    .
  4. As you complete the task consider:
    Option
    Description
    Name
    The connection name must be unique in the Data Catalog. Workday displays this name in the Data Catalog and when you select a connection in a data change task.
    Description
    (Optional) Workday recommends using the description to define the use of the connection and help differentiate between different connections.
    URL
    The URL of the Snowflake account.
    Warehouse
    The Snowflake warehouse to access.
    Snowflake Role
    (Optional) The role of the Snowflake user. When no role is specified, Workday uses the user’s default role.
    Authentication Type
    Select how to connect to Snowflake:
    • Basic Auth. Workday connects to Snowflake using the user credentials of the specified Snowflake account.
    • Key Pair. Workday uses a private key and public key pair that you can use to securely authenticate to Snowflake.
    When you use Key Pair authentication, Workday generates and stores a private key on the Workday tenant and generates a public key for you to copy (2048-bit RSA key pair). You must copy the public key and assign it to the user in Snowflake to enable authentication.
    User Name
    Enter the Snowflake user to connect as.
    Password
    (Required for Basic authentication.) The password associated with the configured Snowflake user name.
  5. (Required for Key Pair authentication) Copy the public key and assign it to the user in Snowflake to enable authentication.
    Because you assign the tenant-generated public key to the Snowflake user in order to connect to Snowflake, you can only have 1 connection per Snowflake user across all tenants using Key Pair authentication.
  6. (Optional) Use the
    Test Connection
     button to verify that Workday can connect to Snowflake using the connection information you configured.
Workday creates the Snowflake connection and displays it on the
Connections
 tab in the
Data Catalog
.

This content is not part of the Workday Administrator Guide.