Snowflake - data

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. You can store data about your customers, your business, or any other data on Snowflake and export it to other systems to build analytics and reporting on top of your data. Connect Snowflake with Blueshift to sync customer data, catalogs, events, and campaign reports.

Capability comparison

Capability	Direct integration	Amazon S3
Import customer data, events, and catalogs	✓	✓
Export campaign reports	✓	✓
Incremental import (Change Data Capture (CDC) — with table streams)	✓	—
Real-time sync	✓	—

---

Direct integration with Snowflake

With direct integration, Blueshift can import customer data, catalogs, and real-time events to build a 360-degree view of your customers. You can also export campaign activity reports to Snowflake using Secure Data Sharing and analyze them with BI tools.

Watch this video for a quick overview.

Back to top ↑

---

Set up integration

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

Step 1: Create an adapter in Blueshift

• 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 configured adapters.
• Click +ADAPTER to add an adapter.
• Add a Name for the adapter. If you have multiple adapters, the adapter's name helps you identify the integration.

Step 2: Configure access & provide warehouse details

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 necessary user in Snowflake are generated.

Field	Details
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, 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.

Step 3: Create a user & assign permissions in Snowflake

• In the adapter screen, you'll see auto-generated commands to create a user and assign permissions.
• Click Copy to Clipboard.
• Open Snowflake in a new tab and navigate to Worksheets.
• Paste and run the commands.

Step 4: Grant API permissions & verify

• Return to the Blueshift adapter screen.
• Click Generate Public key.
• Click Copy to Clipboard.
• Switch to Snowflake, go to Worksheets, paste and run the command.
• Return to Blueshift and click Check Access Status.
• Once verified, click Save.

Back to top ↑

---

Import data

Complete the prerequisites and set up the direct integration first. After the setup is complete, you can create a task to import data into Blueshift.

Once you have set up the integration, you can start importing the recommendation feeds, customer data, catalogs, and event data.

Export data

Export campaign activity reports from Blueshift to Snowflake using Secure Data Sharing. You can further analyze this data using business intelligence tools and gain deeper insights into campaign performance.

Back to top ↑

---

Integration with Snowflake via Amazon S3

Blueshift also supports integration with Snowflake via Amazon S3 to import or export data in batches — including customer data, interactions, campaign activities, recommendations, predictive intelligence, and user profile attributes.

Import data from Snowflake via S3

• Unload data from Snowflake to AWS S3 using Snowflake docs.
• Set up Blueshift to fetch and upload the data periodically.

Once imported, you can use the data to build profiles, run campaigns, or create syndications.

Export data to Snowflake via S3

Campaign activity data

Export campaign activities to build reports and dashboards for performance analysis.

• Set up Blueshift to export campaign activity data to S3.
• Load data into Snowflake using bulk loading.

Segments, recommendations, & predictive intelligence

Export user segments and predictions to measure campaign performance on paid media platforms.

• Set up customer data syndication in Blueshift.
• Load the data into Snowflake from S3.

Back to top ↑

---