Snowflake integration - Data

snowflakelogo – Archetype Consulting

 

Snowflake is a leading data cloud platform which offers workloads like Data warehouses, Data engineering, Data science, Data sharing and Data lake. You can store data about your customers, your business, or anything on Snowflake and export to a system of your choice to build analytics and reporting on top of your data.

With the integration of Blueshift and Snowflake, you can import data about customers and their interaction in your Blueshift account very easily. You can also export data related to campaign activities, recommendation, predictive score, and user profile attributes from Blueshift to snowflake, which in turn can be used to build campaign performance report on BI tools of your choice, help your data science team to build algorithms and recommendation outside Blueshift or just export it to some other application that Snowflake supports  

               

Import data from Snowflake

You can import data from Snowflake tables as users or events into Blueshift. You can do this using AWS S3. Just unload data from Snowflake on AWS S3, and then load it into Blueshift.

  1.  Unload data from Snowflake to AWS S3. You can follow the steps mentioned in this article.
  2. Setup Blueshift to periodically fetch data from S3 and upload to Blueshift. Follow the steps mention in this article.

Once you import the data from Snowflake to Blueshift, you can instantly use that data to build rich user profiles, use it in campaigns, or use it in syndications.

 

Export data to Snowflake

You can export data about campaign activities from Blueshift into Snowflake. You can use this data in your Snowflake account to build reports and dashboards for performance analysis and effectiveness of your campaigns. 

You can also export recommendations, predictive scores and user profiles of segments into your Snowflake account. This data can then be used to measure the campaign performance on paid media platform.

Follow the steps mentioned below to export campaign activity data.

  1. Setup Blueshift to export campaign activity data from Blueshift to AWS S3. Follow the instructions provided in this article.
  2. Setup Snowflake to load data from AWS S3. Follow the instructions provided in this article.

Note

To export segment data along with predictive intelligence and recommendations data to S3, and then from S3 to Snowflake, you need access to the Syndications feature. Get in touch with your Blueshift account's customer success manager or drop an email to support@blueshift.com to enable Syndications for your account. 

To export data of a segment into your Snowflake account, follow the steps below.

  1. Setup an attribute and recommendation syndication in Blueshift. Follow the instruction provided in this article.
  2. Setup Snowflake to load data from AWS S3. Follow the instructions provided in this article.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request