Data Sharing with Snowflake
Data sharing exposes Vibes data for you to extract from Snowflake, our data storage partner. While the platform allows user to view aggregated data, data sharing is great for users who want to pull all data at a more granular level.
Users can securely access their data and extract it in whatever format, way, or cadence they need.
What is data sharing?
Secure Data Sharing is a way to give Vibes’ customers direct access to their Vibes-collected data. Using data sharing, you can extract data from Snowflake, our data storage partner. The service allows a “provider”—aka, Vibes—to share data with “consumers”—Vibes’ customers—without taking up any storage in the consumer’s account. You’ll provided with information on how to access this data during the Vibes onboarding process.
To learn more about data sharing, see Snowflake's Data Sharing documentation.
What data can be extracted?
Below is a table of all the data tables you can access.
|Data Table Name||Description||Example Use Case||Data Retention|
|CLICKS||Shows all clicks on links generated from the platform||Retaining all click events by individual||7 Days|
|MESSAGES||Shows all SMS/MMS messages coming to and from the platform||Retain all messages sent from and to an individual||7 Days|
|PERSON_DATA||Shows meta data assigned to an individual||Pulling all meta data associated with an individual in platform|
Including person meta data with other platform events
|PUSH_MESSAGE||Shows all push messages sent from platform||Retaining all push messages sent to an individual||7 Days|
|SUBSCRIPTIONS||Shows all subscription events for lists associated with your account.||Pulling all opt-ins for a specific list||7 Days|
|SUBSCRIPTION_STATUS||Shows all subscriptions and their current opt-in or opt-out status||Syncing a CRM system with the Vibes Platform||All Data|
|WALLET_INSTANCE||Shows all installs of mobile wallet objects||Retaining all installs of mobile wallet objects by individual||7 Days|
|WALLET_PAGE_VIEW||Shows all page views of mobile wallet objects||Retain all page views of mobile||7 Days|
|DATA_LOAD_STATUS||Shows when data sets were last updated||Check for if new data has been populated||All Data|
How often is this data updated?
While Vibes updates data on a regular basis, rare errors sometimes cause these updates to be delayed. Please utilize the Upload Status table to ensure when data was last updated to all data tables.
Does Vibes support direct data sharing?
For customers who are Snowflake customers, Vibes can give access to data directly in the customer's Snowflake instance through a Data Share. In the US, we support the AWS US West (AWS_US_WEST_2) and US East (AWS_US_EAST_1) as well as as well as Azure US West (AZURE_WESTUS2) and US East (AZURE_EASTUS2) instances of snowflake, and in the EU, we support the AWS EU West (AWS_EU_WEST_1) instance of Snowflake. To set this up, please reach out to your account representative.
Need More Help?
If you have questions, please reach out to your account representative for more information.
Updated about 1 month ago