By connecting Crisp with Snowflake, you can Crisp sync your distributor and retailer data securely to the cloud and integrate that information with your own internal systems.

Note: To set up this connection, you will need to be the Account Admin of an active Snowflake account and you will need your Snowflake identifier and cloud platform/region. For more, see Snowflake Documentation > Account identifiers.

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

  6. If you need to locate your Snowflake account identifier and cloud provider region, complete the following steps:

    a. Log in to your Snowflake account.
    b. Select the the drop-down menu below your username.
    Snowflake_Account_ID.png
    Your account identifier appears below the Log Out option. Your cloud region appears in to the right of the Cloud and Region labels.
    For more, see Snowflake Documentation > Account Identifiers.

  7. Enter your Snowflake account identifier, then select your cloud provider 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.