Snowflake is a cloud-based data platform that stores and analyses your business data. When integrated with Dotdigital, it allows you to import contact and product data without restructuring your datasets. You can connect to multiple views in Snowflake, making it easier to sync consolidated datasets from different sources.
Public preview
This feature is currently in public preview. To join the preview, contact your Customer Success representative.
What you can do
Import contact data from Snowflake to build targeted segments and campaigns. This lets you bring together customer data from multiple systems using Snowflake views.
Import product data to support dynamic content, product recommendations, and personalised offers. Product data works alongside contact data to improve relevance.
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 accounts
Set up the connection between Dotdigital and Snowflake.
Read the integration information, then select NEXT.
For Connect to Snowflake, select Connect account.
Enter your Snowflake credentials to connect your account.
Select CREATE.
Select NEXT.
3. Sync contacts
Decide if you want to import contact data from Snowflake into Dotdigital.
If you already get your contacts from another source (such as a CRM), select No.
You can still sync product data even if you choose not to sync contacts.
Select Yes or No.
Select NEXT.
4. Sync product catalogue
Decide if you want to import product data from Snowflake into Dotdigital.
If your product data lives in another platform, select No.
You can still sync contact data even if you choose not to sync products.
Select Yes or No.
Select NEXT.
5. Select view
Choose whether your data source is a table or a view in Snowflake.
Select View to combine data from multiple tables, such as online and offline product data, without restructuring.
Your choice here affects only how Dotdigital reads the data, not what data is imported.
Select Table or View.
Select NEXT.
6. Select your data source for products
Select where your product or customer data lives in Snowflake.
Expand the Warehouse drop-down menu, and choose the warehouse where your data processing happens.
Expand the Database drop-down menu, and choose the database that contains your data.
Expand the Schema drop-down menu, and choose the schema that organises your tables.
Expand the Table drop-down menu, and choose the table (or view) that holds the data you want to sync.
Select NEXT.
7. Select your timestamp column
Select the column that tracks when records were last updated. This lets Dotdigital sync only the changes since your last import, enabling incremental syncs. If you delete a row in Snowflake, it won't be removed from Dotdigital.
Expand the Timestamp column drop-down menu, and choose the column that shows when each record was last modified.
Select NEXT.
8. Map your data fields
Connect your Snowflake data to the right places in Dotdigital.
You must map either an email address or mobile number to sync contacts.
When syncing product insight data, you must map mandatory schema fields. Mandatory fields are shown in grey. You can map optional fields as needed, but you can’t add additional custom fields.
Learn more in Insight data.
Expand the Dotdigital field drop-down menu, and choose where you want the data to appear in your Dotdigital account.
Expand the Snowflake field drop-down menu, and choose the column that contains this information.
To map additional fields, select ADD A NEW MAPPING and repeat the process.
Select NEXT.
9. Set sync schedule
Choose how often your data syncs. You can set a different schedule for each dataset.
For example, you can sync contact data more frequently than product data.
Sync options:
Hourly
Every four hours
Once a day (default)
Expand the Sync data every drop-down menu, and choose your sync frequency.
Select COMPLETE.
To change your sync schedule after setup, go back into your integration settings and edit the frequency. For example, if you originally set it to once a day, you can later change it to every four hours.
You can't pause syncing; to temporarily stop syncing, disable the integration and re-enable it when you are ready to resume.