🔄 Overview of Snowflake Data Sharing
Snowflake Secure Data Sharing is a powerful feature that allows organizations to share queryable data across different Snowflake accounts without copying or moving data.
It’s designed to eliminate data silos, reduce ETL overhead, and enable real-time collaboration on data between internal teams, partners, or external vendors.
➡️ Listrak Data Sharing
The Listrak > Snowflake integration provides a datashare to your Snowflake instance to unlock day to day engagement and activity data about your contacts in your Email and SMS channels.
🛠️ How Data Sharing Works
At the core of Snowflake’s architecture is a multi-cluster, shared data model, which separates:
Storage: your centralized data lake
Compute: virtual warehouses for querying
Services layer: governing metadata, access control, and sharing
When you share data:
No data is physically transferred or duplicated.
The recipient queries a live view of your dataset.
All governance (permissions, roles, policies) stays in place.
💹 Benefits of Sharing Data
Reduce time to insights
Eliminate lengthy ETL processes. Snowflake’s architecture makes customer data immediately accessible and queryable as it arrives in the data lake. No data is copied or moved, enabling real-time insights.
Bridge data together
Join Listrak engagement and campaign data with all other Snowflake datasets to create a holistic view of your customers and generate deeper insights from a single source of truth.
Identify Key Performing Campaigns
Use Listrak & Snowflake to compare performance metrics across channels and campaigns.
Discover Engaged Contacts
Easily identify your contacts across your channels who have been engaged but aren’t converting.
💡 Usage & Visualization Ideas
Sharing data unlocks many new possibilities and insights through this wider data lens.
Use Secure Data Sharing for:
Complex reporting and dashboards
Attribution modeling
Internal sharing within your organization
CRM mapping (e.g., Salesforce integration)
Custom analysis
🔐 Technical Requirements
You must have Admin-level access to your Snowflake account to enable secure data sharing integrations.
Integration Setup
Contact your Listrak Account Manager to kickoff the process of integrating with Listrak. Listrak will need to work with your Snowflake Admin.
Provide Listrak with your Snowflake account details and locator. To find it, run SELECT CURRENT_ACCOUNT(); in your Snowflake instance.
If applicable, specify the cloud provider and region.
Create the data share with Listrak.
In Snowflake, create a database from the shared data so you can query the tables.
Technical Notes
No data duplication
All sharing occurs via Snowflake’s services layer and metadata store, meaning shared data doesn’t consume storage in the consumer account and incurs compute costs only.
Data access governance
Control access to shared data using existing Snowflake roles and permissions. Apply the same policies as you would for your internal datasets.
Learn more in Snowflake's Introduction to Secure Data Sharing
Inbound Data Sharing
Listrak shares access to engagement data via Snowflake. You, the data consumer, create a database from the share and can begin querying it. The data is read-only.
Snowflake Hosting Regions
Data is currently hosted in Snowflake’s AWS US WEST. For clients using Snowflake in other regions (AWS, Azure, GCP), regional data sharing options are available.