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:

To connect Crisp to Snowflake

  1. Log into your Crisp account.

  2. From the main menu at the top-right of the screen, select Outbound Connectors.

    Main_Menu_Outbound_Connectors.png

  3. Select the Add connector button.

      Connecting_Retailer_Portals_002.png

  4. From the Outbound Connectors section, select the Snowflake connector tile.

    Snowflake_001.png

  5. 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.

    Snowflake_003.jpg

  6. Enter your account identifier.
    Snowflake_006.png
  7. 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

    Snowflake_004.png

  8. In the Connector source data section, select the Select button.
    Snowflake_005.png
    The Select source data screen appears.

  9. 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.

    Excel_Outbound_003.png

  10. To complete your selections, select the Accept button.

    Excel_Outbound_004.png
    The window closes and you return to the connector setup screen.

     

  11. Select the Save button.

    Connecting_Retailer_Portals_005.png

    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.