By connecting Crisp with Snowflake, you can sync your distributor and retailer data securely to the cloud and integrate that information with your own internal systems.
Requirements
To create this connection you will need the following:
- Be the Account Admin of an active Snowflake account
- Locate your Snowflake identifier and cloud platform/region. Snowflake account identifiers are typically based on your organization and account name, but may be based on your account locator. For information on the formatting of account identifiers, see Snowflake Documentation > Account identifiers. To find your organization and account name, see Snowflake Help > Viewing the name of your organization and its accounts. To find your account locator, see Snowflake SQL reference > CURRENT_ACCOUNT.
To connect Crisp to Snowflake
-
Log into your Crisp account.
- From the main menu at the top-right of the screen, select Outbound Connectors.
-
Select the Add connector button.
-
From the Outbound Connectors section, select the Snowflake connector tile.
-
If you want, update the default name of the connector. If you're going to set up multiple outbound feeds, we recommend using something unique.
-
Enter your account identifier.
-
If your Snowflake account identifier is based on your account name (true in most cases), enter your identifier in the following format: org_name.account_name (for example, BITEFOODS.CRISP) For more on how account identifiers are formatted, see: Snowflake Documentation > Account identifiers. If you need to locate your account or organization name, follow the instructions in the Snowflake Help > Viewing the name of your organization and its accounts article.
- If you have a legacy setup with an account identifier based on the account locator, enter your account locator in this field. If you need to find your account locator, you can use the current_account SQL function. For more information see Snowflake SQL reference > CURRENT_ACCOUNT.
-
If your Snowflake account identifier is based on your account name (true in most cases), enter your identifier in the following format: org_name.account_name (for example, BITEFOODS.CRISP) For more on how account identifiers are formatted, see: Snowflake Documentation > Account identifiers. If you need to locate your account or organization name, follow the instructions in the Snowflake Help > Viewing the name of your organization and its accounts article.
-
Select your cloud provider region. If you need to find your cloud region, you can use the Current Region SQL function. For more, see Snowflake SQL reference > CURRENT_REGION.
-
In the Connector source data section, select the Select button.
The Select source data screen appears. -
Select the retailer for which you want to export data to Snowflake (e.g., UNFI), then choose which data tables and columns to include in the export. For detailed instructions on making your outbound data feed selections, see Selecting Outbound Data Sources.
Hint: You can select the book icon to the right of a table name to see its documentation. -
To complete your selections, select the Accept button.
The window closes and you return to the connector setup screen. - Select the Save button.
Snowflake is now connected to the Crisp platform. You can check the status of the connection by clicking the new Snowflake tile.
A diagnostic checklist appears on the right side of the screen. Once all the items are complete, green check marks appear next to them and the connection is finalized.