Crisp_and_Snowflake.png

Overview Sections:

What is Snowflake?
Crisp Snowflake Connection Configuration
Obtaining Crisp Data in Your Snowflake Account
Accessing Data in Snowflake
Working with Crisp Data in Snowflake
Crisp Data
Data Schema
Data Sync Timing

What is Snowflake?

As a platform-as-a-service (PaaS) data cloud warehouse, Snowflake is scalable, dynamic,  powerful, and enterprise-ready. Snowflake enables cloud agnostic data storage with robust yet simplified computing features and integrates with Amazon S3, Google Cloud Storage and Microsoft Azure cloud storage solutions.

Snowflake is a cloud service that offers enterprises the ability to scale their platform use both up and down to meet demand, which results in a balance of performance and cost. Snowflake enables this feature by separating data storage from data computation demand. This delivers a flexible solution capable of a near-unlimited number of concurrent workloads in near-real-time. Snowflake also enables secure data sharing internally and externally.

 

Crisp Snowflake Connection Configuration

Crisp offers data exports to your Snowflake instance, allowing you to capture retail and distributor data to apply the analytics needed to succeed with your customers. To get started, you'll need to have your Snowflake account identifier, cloud storage, and cloud region information available. 

For a guide on creating the connection, please refer to the connector configuration steps

 

Obtaining Crisp Data in Your Snowflake Account

Once your connection to Snowflake has been configured and the initial Crisp data has been loaded (~15 minutes), you can access your data by logging into your Snowflake account and following these steps:

1. Ensure that you are an "ACCOUNTADMIN," as Crisp uses Snowflake's "Shares" feature and you'll need an "ACCOUNTADMIN" permission level for it to work. Change_Snowflake_Role_to_AccountAdmin.gif

You can view or change your user role by clicking on the down arrow next to your user name, hovering over “Switch Role” in the drop down, and then clicking on “ACCOUNTADMIN”

 

2. Click on the Shares button.Shares_Button.png

 

3. Locate Crisp's data share in your list of Inbound Shares and click on it. Secure_Share_Name.png

 

4. A popup will appear. Click the link saying Create Database from Secure Share.Create_Database_From_Secure_Share.png

 

5. A new window will load. Enter a unique name for the database and select what user roles should have access to this data. Provide any comments about the database if desired. Once all has been filled in or selected, click Create Database.Snowflake_Create_Database.gif

6. Another pop-up will appear asking to confirm the database creation. Select OK.
Database_Overview_OK.png

 

Accessing Data in Snowflake

Crisp shares data tables through the Shares function in Snowflake.

To access your data:

1. Select the Databases button.

Databases_Icon.png

 

2. From the list of databases you have access to, click on the name of the one created for your Crisp data.
Crisp_Data_in_Databases.png

 

3. Select the Views tab, then you will see the Crisp table(s) selected during connector configuration under View Name and Schema name.

Databases_Views_Recent.png

Note: By default, Snowflake uses schema names to identify tables within a database, and the Crisp schema will fall under the naming convention: “Schema_(user Crisp Account ID)_***

 

4. Select the View Name link to open a table and see how the data is structured.

Amazon_Schema.gif



Working with Crisp Data in Snowflake

1. To work with the Crisp data, select the Worksheets button.

Worksheets.png

 

2. Click Select Schema in the top right and choose your database from the dropdown menu.

Select_Schema_and_Database.png

 

3. From the menu on the left side of the screen, select the database, then enter your data queries starting on line one. Click the Run button to obtain a view of the results at the bottom of the screen.

Run_Data_Queries.png

 

Crisp Data

Crisp allows users to export multiple source tables to a user’s Snowflake Instance. Users are able to select source or normalized tables from their source data connections from their Crisp destination connectors management page.

Crisp_Outbound_Connectors.png

You're able to select or deselect the tables you wish to enable within Snowflake. After making updates to your source table selections, select the Save button.

Source_Tables.png

Exported Crisp data includes the most recent reports published by the portal plus backfill data. Crisp backfills data up to the previous three years to date.

Data Schema

Data schema details vary between data table sources. Crisp provides users specific data schema information within our Data Catalog, where you can find up-to-date information on exported column attributes. Additionally, you can see the data schema within the Snowflake database views.

Data Sync Timing

Upon completion of the Snowflake connector configuration, Crisp initiates a data load into Snowflake within 15 minutes to export the first dataset that includes backfill data. Overall timing to backfill data for the first time depends on the number of tables requested. However, it should not take more than a few hours. Once the initial data set is loaded, recurring tasks are run on a schedule thereafter to update the data as it becomes available from the retailer or distributor portal. 

Since source data syncs are scheduled by the data provider, data availability varies based on the portal and ranges from daily, weekly to monthly reports. Crisp ingests the data to normalize and exports to users within six hours of the data availability.