Snowflake is a cloud-based data platform that stores and analyses your business data. When integrated with Dotdigital, you can sync datasets from individual tables or consolidated views, helping you unify data from multiple systems into a single marketing platform.
This integration supports syncing contacts, products, and orders from Snowflake into Dotdigital.
For order syncing, your data must follow a fixed structure.
Before you start
You need:
Access to your Snowflake warehouse, database, schema, and tables or views.
A timestamp column in
TIMESTAMP_LTZorTIMESTAMP_NTZformat.A table or view containing your contacts and/or products.
A dedicated Orders table in the required schema.
See Order data structure requirements.
The Snowflake integration syncs data into Dotdigital.
To sync data out of Dotdigital into Snowflake, use the Firehose integration.
If you need two‑way data movement, use both integrations together.
What you can do
Import contact data from Snowflake to build targeted segments and campaigns.
You can sync data from a single table or from a Snowflake view that combines multiple tables.
Import product data to support dynamic content, product recommendations, and personalised offers. Product data works alongside contact data to improve relevance.
Import order data to bring purchase history into Dotdigital, enabling RFM analysis, ecommerce segments, product recommendations, and personalised automations.
Connect to multiple views in Snowflake, allowing you to sync consolidated datasets without restructuring your source tables.
1. Integrate Snowflake with Dotdigital
Start the integration by finding Snowflake in the self‑serve integrations menu.
Go to Connect > Integrations.
In the left menu, under SHOW, select Self‑serve.
Find Snowflake, then select +ADD.
2. Connect your account
Set up the connection between Dotdigital and Snowflake.
Read the integration information, then select NEXT.
Select Connect account.
Enter your Snowflake connection details:
Unencrypted Private Key
Account
Username
Other fields are optional
Select CREATE.
Select NEXT.
3. Set up your datasets
You can configure Contacts, Products, and Orders independently, but the setup flow is linear.
You move through each dataset in order, starting with Contacts.
At each stage, you must choose Yes or No:
If you select Yes, the wizard guides you through the setup steps for that dataset.
If you select No, the wizard skips the detailed steps and moves on to the next dataset.
You cannot jump directly to Products or Orders without first answering the Contacts step.
Contacts setup
1. Sync contacts
Choose whether you want to sync contact data from Snowflake into Dotdigital.
If you already get your contacts from another source, such as a CRM, select No.
Select Yes or No.
Select NEXT.
2. Select your data source for Contacts
Select where your contact data lives in Snowflake.
Select Data source type.
Select Warehouse.
Select Database.
Select Schema.
Select View/Table.
Select NEXT.
3. Select timestamp for Contacts
Choose the column that tracks when each record was last updated.
If you use a view, ensure the timestamp column is included in the view output.
Must be a
TIMESTAMP_LTZorTIMESTAMP_NTZ.Rows without timestamps cannot sync.
Only records newer than the last sync are imported.
Select your timestamp column.
Select NEXT.
4. Sync opt-in/out status
Select if you want to sync the opt-in/out status.
Select NEXT.
Select the email opt in field, and then select NEXT.
5. Map data fields
Map Snowflake columns to Dotdigital contact fields.
Contacts require email or mobile number.
Select a Dotdigital field.
Select the matching Snowflake column.
Add mappings if needed.
Select NEXT.
6. Set sync frequency
Choose how often your contact data syncs (Snowflake supports hourly).
Select your sync frequency.
Select NEXT.
Products setup
1. Sync product catalog
Choose whether to sync product data into Dotdigital.
Select Yes or No.
Select NEXT.
2. Select data source for Products
Select where your contact data lives in Snowflake.
Select your Warehouse.
Select your Database.
Select your Schema.
Select your Table or View.
Select NEXT.
3. Select timestamp for Products
Choose the column that tracks when each record was last updated.
Must be a
TIMESTAMP_LTZorTIMESTAMP_NTZ.Rows without timestamps cannot be synced.
Only rows with timestamps newer than the last successful sync are imported.
Select your timestamp column.
Select NEXT.
4. Map data fields
Some product fields are greyed out because they’re mandatory. You must map these fields for the product sync to work, and you can’t remove or change them. You cannot skip this step.
Select a Dotdigital field.
Select the Snowflake product fields for the matching Dotdigital insight fields.
Add additional mappings as required.
Select NEXT.
5. Set sync frequency
Choose how often your data syncs. Dotdigital checks for updates on your chosen schedule, but only imports rows with timestamps newer than the last successful sync.
Select your sync frequency.
Select NEXT.
To change the schedule later, edit your integration settings.
To pause syncing, disable the integration and re‑enable it when you are ready.
Orders setup
1. Sync orders
Order syncing allows you to bring purchase history into Dotdigital.
Order data must follow a fixed schema containing:
Order‑level fields (ID, totals, currency, purchase date)
Customer identifier fields
Billing and delivery details
A nested items field for order lines
The integration will not work if your table does not follow the required structure.
Select Yes or No.
Select NEXT.
You cannot manually map order fields, the integration requires an exact schema because Dotdigital parses the structure directly.
2. Select data source for Orders
Select where your contact data lives in Snowflake.
Select your Warehouse.
Select your Database.
Select your Schema.
Select your View/Table.
Select NEXT.
3. Set sync frequency
Choose how often your data syncs. Dotdigital checks for updates on your chosen schedule, but only imports rows with timestamps newer than the last successful sync.
Select your sync frequency.
Select FINISH.
To change the schedule later, edit your integration settings.
To pause syncing, disable the integration and re‑enable it when you are ready.
The Orders sync uses a fixed schema, so Dotdigital reads the structure of your table directly instead of asking you to map fields manually. This ensures every order record is imported consistently, and avoids issues that can occur when custom field names or formats don’t match expected ecommerce standards. If your table doesn’t follow the required structure, update it before starting the sync.
Example SQL for creating a compatible Orders table
Example SQL for creating a compatible Orders table
create or replace TABLE DOTDIGITAL_PRODUCTION.INTEGRATION.MY_ORDERS_SYNC (
CREATED TIMESTAMP_NTZ(9) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
UPDATED TIMESTAMP_NTZ(9) NOT NULL DEFAULT CURRENT_TIMESTAMP(),
ID VARCHAR(255),
ORDER_TOTAL NUMBER(18,2) NOT NULL,
PAYMENT VARCHAR(255),
DELIVERY_METHOD VARCHAR(255),
DELIVERY_TOTAL NUMBER(18,2),
CURRENCY VARCHAR(3) NOT NULL,
ORDER_STATUS VARCHAR(255),
EMAIL VARCHAR(255) NOT NULL,
QUOTE_ID VARCHAR(255),
PURCHASE_DATE DATE NOT NULL,
BILLING_ADDRESS_1 VARCHAR(255),
BILLING_ADDRESS_2 VARCHAR(255),
BILLING_CITY VARCHAR(255),
BILLING_COUNTRY VARCHAR(255),
BILLING_POSTCODE VARCHAR(255),
DELIVERY_ADDRESS_1 VARCHAR(255),
DELIVERY_ADDRESS_2 VARCHAR(255),
DELIVERY_CITY VARCHAR(255),
DELIVERY_COUNTRY VARCHAR(255),
DELIVERY_POSTCODE VARCHAR(255),
PRODUCTS VARIANT,
ORDER_SUBTOTAL NUMBER(18,2) NOT NULL,
BASE_SUBTOTAL_INCL_TAX NUMBER(18,2),
DISCOUNT_AMOUNT NUMBER(18,2),
COUPONCODE VARCHAR(255)
);