Overview

With Snowflake’s Secure Data Sharing integration, you can gain instant access to valuable first-party user data generated from Cordial—directly in your designated Snowflake account. Cordial’s Snowflake portal gives you seamless, secure, and real-time access to your customer’s activity, orders, custom events, and profile data in an easy and frictionless way—all without the need for typical extract, transform, and load (ETL) data sharing solutions.

For Cordial customers on the Snowflake Data Cloud, this partnership will enable live access to your valuable first-party customer data, empowering you with the data agility to analyze engagement trends, monitor consumer behaviors, gauge performance, and unlock new insights about metrics driving your business. 

Data architecture

Use cases

• Analyze behavioral patterns and generate funnel reports to better understand your customer’s buying behavior and patterns.
• Leverage Cordial customer and event data alongside the rest of your Snowflake data to power feature sets within your application such as dashboards, attribution models, user predictions and recommendations, data visualizations, and more to enrich business insights.
• Empower your business intelligence team by getting them the data they need without engineering.

Prerequisites

You need a Snowflake account for this integration.

What is Data Sharing?

Snowflake’s Secure Data Sharing is a proprietary way to allow businesses, like Cordial, to seamlessly grant and share data with partner client organizations—like you! Unlike traditional data sharing, Snowflake Data Sharing is far easier to use because it provides immediate access to ready-to-query data, eliminating friction and unnecessary cost that come with ETL processes.

How it works

With Secure Data Sharing, no actual data is copied, transferred, or exchanged between accounts, which eliminates data movement. All sharing is accomplished through Snowflake’s unique multi-cluster shared data architecture.

This is an important concept because it means that sharing data from Cordial to your Snowflake account does not take up any storage in your Snowflake consumer account—and therefore does not contribute to your monthly Snowflake data storage cost. The only charges are for the compute resources used to query on shared Cordial data. 

• You can learn more about Snowflake's Data Sharing here.

Benefits

• Accelerate business insights: Engagement data, custom events, contact attributes, orders, cart items, and message sends are immediately accessible and query-able from the instant of arrival.
• Share live data with ease: Securely and seamlessly share data across your organization through account-to-account shared views.
• Replace traditional data sharing methods: Eliminate the need to move or copy data, rebuild schemas, or manage complex data pipelines.
• Reduce cost: Shared data does not take up any storage in your Snowflake account, so you'll only pay for the compute resources used for queries on shared Cordial data.
• Painless setup and secure access: Data engineering, storage, sharing, and governance all managed by Snowflake—resulting in turn-key setup and maintenance.
• Cloud region support: Cordial hosts all user-level data for clients in the Snowflake AWS US-West-2 cloud region. Cordial can provide secure data sharing to any joint client for global Snowflake cloud regions across AWS, Google Cloud, and Microsoft Azure.

Request a Secure Share

Visit Cordial's listing in the Snowflake marketplace to request a Secure Share and reach out to your client success manager. You may need to provide your Snowflake account information, which is available by clicking the Copy button in the Account Information dropdown, to help our team verify and provision your request. 

Once you've requested a Secure Share, Cordial will verify and provision the data share from our Cordial Snowflake account to your Snowflake account. After the share is provisioned, Cordial will notify you that your data share has been provisioned—and you'll need to follow the steps below to accept the Secure Share.

1. Your account administrator will need to log in to your Snowflake account, click on Shares in the top navigation bar, and accept the share request from Cordial.

2. To accept the share request, select the Secure Share and click Create Database from Secure Share. 

3. Your account administrator can then give the Secure Share a Database Name, select who can access the data, and leave any comments. 

4. You can then go to the Worksheets tab in the top navigation bar in your Snowflake instance and see the new Cordial shared database and shared dataset.

Query the Secure Data Share

Once you accept the Cordial data share and assign it to a new database in your Snowflake account, you can start querying the data share. Here are the datasets available to query.

The following datasets are available from Cordial through a secure data share. Data is refreshed multiple times per day, giving you direct access to live customer data in near real-time. 
 

Example queries

The Snowflake data share allows you to build powerful queries to get the exact data you want. Here are two examples.

CONTACTS

Here is an example query that uses the CONTACTS view to find (1) the grand total dollar amount of all cart items across all carts, (2) the average dollar amount of all cart items per cart, (3) the average number of items per cart, and finally (4) the total number of carts.

SELECT
  SUM(TRY_TO_NUMBER(cart:"totalAmount"::varchar)) as "grand_total_amount",
  AVG(TRY_TO_NUMBER(cart:"totalAmount"::varchar)) as "average_total_amount",
  AVG(ARRAY_SIZE(cart:"cartitems")) as "average_num_cart_items",
  count(*) as "total_carts"
FROM
  contacts
WHERE
  cart IS NOT NULL
;

This query demonstrates Snowflake’s support for querying structured data. In this case, the cart field is an object with several embedded keys such as totalAmount and cartitems (which is itself an array of zero or more nested item objects).

CONTACTACTIVITY

Here is an example query that demonstrates selecting data from the CONTACTACTIVITY view. The query returns total daily counts for several events (aka actions) related to sending messages for a specified date range (message sends, opens, clicks, and bounces). This query makes use of some advanced SQL features such as Common Table Expressions and the PIVOT function, demonstrating Snowflake’s rich SQL support.

WITH action_totals AS (
   SELECT
     to_date(action_date) as action_date,
     action,
     count(*) as total
   FROM
     contactactivity
   WHERE
     action_date BETWEEN '2024-09-19' AND '2024-09-25'
     AND action IN ('message-sent', 'open', 'click', 'bounce')
 GROUP BY
   action_date,
   action
)
SELECT
  *
FROM
  action_totals
PIVOT (
  SUM(total) FOR action IN ('message-sent', 'open', 'click', 'bounce')
) as p
ORDER BY
  action_date

Definitions

Message Sends

The statuses below indicate the current lifecycle state of a message send in the messagesends view.