snowflakelogo.jpeg

Snowflake’s Data Cloud is powered by an advanced data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. 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.

You can integrate Snowflake and Blueshift using either of the following methods:

Direct integration with Snowflake

With the direct integration of Blueshift and Snowflake, importing customer data, catalogs, and real-time customer interaction data (events) into your Blueshift account is easy and builds an up-to-date 360-degree view of all your customers. You can also export campaign activity reports to Snowflake using Snowflake's Secure Data Sharing feature.

Import data

Complete the prerequisites and then set up the direct integration with Snowflake. After you have set up the integration, you can create a task to import recommendation feeds, customer data, catalogs, or events data into Blueshift.

Watch this video for a quick overview of the integration.

Prerequisites

  • Before integrating with Blueshift, you must set up your Snowflake account.
  • Blueshift must be able to access data to import data from Snowflake. Decide whether you will provide direct access to the data (read and write access) or access through a reader account.
  • If you want incremental import, you can either set up Change Data Capture using Table Streams in Snowflake or use a specific column in your Snowflake tables to identify the increment. 
  • During the setup, you will have to run some commands to create a user in Snowflake, assign the required permissions to the user, and give Blueshift permissions to run APIs on your data warehouse. The user who runs these commands in Snowflake must have the CREATE and REPLACE Role privileges.

Set up integration

To give Blueshift access to the data in Snowflake, complete the following steps:

  • Sign in to the Blueshift app and click App Hub in the left navigation menu.
  • Go to All Apps, search for, and select Snowflake.
  • You can also go to Data Platform Apps and select Snowflake.
  • Click Configure to view all the configured adapters.
  • Click +ADAPTER to add an adapter.

    snowflake_adapter_name.png

  • Add a Name for the adapter. If you have multiple adapters, the adapter's name helps you identify the integration.
  • How would you like to import data from Snowflake?
    • Select Setup Direct Account Access or Setup Reader Account Access.
  • Select 'Is streams enabled?' if you have enabled change data capture using streams.
  • Provide the details of the data warehouse and the user who will have access to it. Using this information, the commands required to create the required user in Snowflake are generated.

  Data warehouse details

Ensure that the data warehouse details, including Warehouse Name, Database Name, Schema Name, and other fields, match the exact case defined in Snowflake. Incorrect casing may cause errors when setting up an import task.

Snowflake-Integration-Details-Data-Warehouse.png

Host URL of your data warehouse

The URL to access your Snowflake warehouse. For most accounts, the format of the URL is <account_name>.region.snowflakecomputing.com.

For example, https://ab12345.ap-south-1.aws.snowflakecomputing.com

If you are using Snowflake’s Snowsight View, use any of the following ways to find the hostname:

  • Go to Admin > Accounts > Locator to find the hostname. Click the link icon beside the locator value of the account from which you want to import data.
  • Click the account name in the account selector at the bottom of the left navigation. The selector lists accounts that you have previously signed in to. Click the current account name in the list. Click the link icon to copy the Account URL.

For more information, see Account Identifiers.

Warehouse name The name of the data warehouse as mentioned in Snowflake.
Database name The database name as mentioned in Snowflake.
Schema name The schema name as mentioned in Snowflake.
Role of the user The role of the user as mentioned in Snowflake.
Username The username of the user to access the Snowflake data.
    • Go to Step 2 on the adapter screen. Use the commands provided to create a user in Snowflake and assign the required permissions to the user.

  Required privileges in Snowflake

The user executing these commands in Snowflake must have CREATE and REPLACE role privileges.

Snowflake-Integration-Create-User.png

  • Click the Copy to Clipboard icon to copy the commands.
  • Log into your Snowflake account, go to Worksheets, and run the copied commands.
  • Go to Step 3 on the adapter screen and provide Blueshift permissions to run APIs on your data warehouse.

    snowflake_adapter_api_permission.png

  • Click Generate Public key.
  • Click the Copy to Clipboard icon to copy the command.
  • In your Snowflake account, go to Worksheets and run the copied command.
  • Click Check Access Status to verify that Blueshift can access the data.
  • Click Save.

  Avoiding access conflicts in adapters

Each user is mapped to a single token or public key when setting up an adapter. If the same user is assigned to multiple adapters, access will only work for the adapter with the most recently generated token/public key. To avoid conflicts, it is recommended that a separate user be used for each adapter.

Next steps

Create a task to import recommendation feeds, customer data, catalogs, or events data into Blueshift.

Export data

You can also export campaign activity reports from Blueshift into your Snowflake account by using Snowflake's Secure Data Sharing feature. You can further analyze the data using business intelligence tools and gain more insights.

  Exporting data via Snowflake

All customers can export data using Snowflake's Secure Data Sharing feature. You can set up the export from the Campaign Activity Export tab in Account Settings.

In addition to setting up this export within Blueshift, you can request a campaign activity export to Snowflake through our listing on the Snowflake marketplace.

Integration with Snowflake via Amazon S3

Blueshift also supports integration with Snowflake via Amazon S3. With the integration of Blueshift and Snowflake via Amazon S3, you can easily import data about customers and their interactions into your Blueshift account. You can also export data related to campaign activities, recommendations, predictive scores, and user profile attributes from Blueshift to Snowflake.

Import data from Snowflake via S3

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

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

Export data to Snowflake via S3

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 campaign effectiveness. 

You can also export recommendations and predictive scores and segment user profiles into your Snowflake account. This data can then be used to measure campaign performance on paid media platforms.

Follow the steps mentioned below to export campaign activity data.

  Accessing syndications for data export

To export segment data, predictive intelligence, and recommendations data to S3, you must have access to the Syndications feature. Contact your Blueshift customer success manager or email support@blueshift.com to enable Syndications for your account. 

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

  1. Set up a customer data syndication in Blueshift.
  2. Setup Snowflake to load data from AWS S3. For more information, see Bulk loading data from Amazon S3 into Snowflake.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.