- Overview
- Platform setup and administration
- Platform setup and administration
- Platform architecture
- Data Bridge onboarding overview
- Connecting a Peak-managed data lake
- Connecting a customer-managed data lake
- Creating an AWS IAM role for Data Bridge
- Connecting a Snowflake data warehouse
- Connecting a Redshift data warehouse (public connectivity)
- Connecting a Redshift data warehouse (private connectivity)
- Reauthorizing a Snowflake OAuth connection
- Using Snowflake with Peak
- SQL Explorer overview
- Roles and permissions
- User management
- Inventory management solution
- Commercial pricing solution
- Merchandising solution
Supply Chain & Retail Solutions user guide
Configuring a Snowflake connector for data extraction
A Snowflake database connector extracts specific datasets from your Snowflake account into Peak for detailed analysis. This connector enables targeted data extraction, distinct from connecting your entire Snowflake data warehouse through Data Bridge.
For connecting your Snowflake data warehouse to Data Bridge, see Connecting a Snowflake data warehouse.
Prerequisites
Before configuring a Snowflake connector feed, ensure you meet the following requirements:
- You have access to Peak with permissions to configure Data Sources.
- You have Snowflake account credentials (host, username, password, database name, warehouse name).
Configuring the connection
- In Peak, open Manage and select Data Sources.
- Select Add feed and choose the Snowflake connector.
- At the Connection stage, either select an existing connection from the dropdown or select New connection.
- Enter the connection parameters. See Connection parameters.
- Select Test to validate the connection. If the test fails, hover over the info icon for details.
- Select Save and proceed to the next stage.
Connection parameters
| Parameter | Description |
|---|---|
| Connection name | A name for this connection. Use alphanumeric characters. |
| Database host | Your Snowflake account identifier plus the Snowflake URL. Formats: <account_name>.snowflakecomputing.com or <account_name>.<region>.snowflakecomputing.com |
| Database port | The default port is 443. |
| Database username | Your Snowflake username. |
| Database password | Your Snowflake password. |
| Database name | The name of the Snowflake database. |
| Database role | Optional. The Snowflake role to use for this connection. |
| Warehouse name | The virtual warehouse to use once connected. The user must have the required role privileges to access this warehouse. |
Configuring import settings
- Select the database table to ingest and preview the data.
- Select a load type: Truncate and insert, Incremental, or Upsert. See Load types.
- Optionally, add field filters by operator and value.
- Add a primary key if using the upsert load type (required for upsert).
- Enter a feed name following these rules:
- Use only alphanumeric characters and underscores.
- Must start with a letter.
- Must not end with an underscore.
- Maximum 50 characters.
Configuring the destination
Select where your data will be ingested. Available options depend on your configured data warehouse. See Destination options.
Configuring the trigger
Set up how and when the feed runs. See Triggers and watchers.
Result
Peak creates the Snowflake connector feed and runs it according to the selected trigger. You can monitor feed runs and troubleshoot failures from Manage > Data Sources.