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.
Prerequisites - before you begin
- Set up your Snowflake account.
- Ensure a user with CREATE and REPLACE privileges.
- Choose between direct access (read/write) or a reader account.
- For incremental import, set up Change Data Capture or use a column to identify increments.
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.
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.
Field | Details |
---|---|
Host URL of your data warehouse |
The URL to access your Snowflake warehouse. For most accounts, the format of the URL is For example, If you are using Snowflake's Snowsight View, use any of the following ways to find the hostname:
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
Required privileges in Snowflake
The user executing these commands in Snowflake must have CREATE and REPLACE role privileges.
- 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.
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 step
After setup, create an import task to bring your data into Blueshift.
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.
Exporting data via Snowflake
Configure exports from Account Settings → Campaign Activity Export. You can also request campaign exports via Snowflake Marketplace.
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.
Accessing syndications
To export segment, predictive intelligence, and recommendations data to S3, you must enable Syndications for your account. Contact your CSM or support@blueshift.com.
Data imports and exports
Blueshift supports importing and exporting customer, catalog, event, and campaign activity data through integrations with data warehouses, including BigQuery, Snowflake, and Databricks. For a comprehensive overview of supported data types and connection options, refer to Data in Blueshift.
Comments
0 comments