Supply Chain & Retail Solutions user guide

Connecting a Snowflake data warehouse

Prerequisites​

• Access to Peak with permissions to configure Data Bridge.
• A data lake already configured in Peak, in the same region as your Snowflake account.
• A Snowflake account with a user, role, database, and schema prepared for Peak access. See Preparing your Snowflake account.
• Storage integration configured between your Snowflake account and the S3 data lake. See Setting up storage integration.

Preparing your Snowflake account​

Creating a user, role, and schema​

• A warehouse and resource monitor
• A database (or uses an existing one)
• A role with appropriate permissions
• A user with the role and warehouse assigned
• A default schema with write access for Peak
• An optional read-only schema

Setting up storage integration​

• S3 bucket name — the name of the data lake bucket
• Root path — the root path of the S3 bucket
• AWS IAM role ARN — in the format arn:aws:iam::794236216820:role/prod-<tenant_name>-System

Steps​

1. In Peak, open Manage and select Data Bridge.
2. Select Add data warehouse.
3. Enter a unique name for the connection and select Snowflake.
   • The name must be unique to your Peak organization.
   • Use only alphanumeric characters and underscores. No spaces or other special characters.
   • Minimum 3 characters, maximum 40 characters.
   • Must start and end with an alphanumeric character.
   • The name cannot be changed after the connection has been set up.
4. Select Next.
5. Select the cloud platform where your Snowflake account is hosted (AWS, Azure, or GCP).
6. Select the region where your Snowflake account is located. Ensure the region complies with your data localization requirements.
7. Select the authentication type:
   • Basic — authenticates using account ID, username, and password.
   • OAuth — authenticates using a Snowflake security integration. Follow the OAuth setup steps below before continuing.
8. Enter the required credentials for the selected authentication type. See Credential fields.
9. Select Test to validate the connection.
10. In the Data lake step, select the data lake connection to link to this data warehouse.
11. Review the configuration and select Finish.

Setting up OAuth​

1. In Peak, copy the SQL command displayed under Create Security Integration.
2. In your Snowflake account, sign in using the ACCOUNTADMIN role and run the command to create the security integration.
3. Copy and run the SQL command under Get Client Details to retrieve the Client ID, Authorization URL, and Token URL.
4. Copy and run the SQL command under Get Client Secret to retrieve the Client Secret.
5. Save all retrieved values — you will enter them in the database credentials step.
6. Select the confirmation checkbox in Peak to confirm the security integration has been set up.

Credential fields​

Basic authentication​

OAuth authentication​

Result​