Snowflake is a cloud data warehouse that stores and analyses your business data. Connect it to Dotdigital to turn your customer insights into personalised marketing campaigns.
What you can do
Import contact data from Snowflake to create targeted email, SMS, and WhatsApp campaigns. This brings together customer information from multiple systems, so you can reach all your customers with personalised messages.
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 your Snowflake.
Read the integration information, then select NEXT.
For Connect to Snowflake, select Connect account.
For Your authentication name, enter a name for this connection.
Enter your Snowflake credentials to connect your account.
Select CREATE.
Select NEXT.
3. Select your data source
Choose where your customer data lives in Snowflake.
Expand the Warehouse drop-down, and choose the warehouse where your data processing happens.
Expand the Database drop-down, and choose the database that contains your customer information.
Expand the Schema drop-down, and choose the schema that organises your tables.
Expand the Table drop-down, and choose the table that holds the contact data you want to sync.
Select NEXT.
4. Select your timestamp column
Choose the column that tracks when records were last updated. This helps you sync only the changes since your last import.
Expand the Timestamp column drop-down, and choose the column that shows when each record was last modified.
Select NEXT.
5. Map your data fields
Connect your Snowflake data to the right places in Dotdigital.
Before you start
You must map either an email address or mobile number to sync contacts.
Expand the Dotdigital field drop-down, and choose where you want this data to appear in your Dotdigital account.
Expand the Snowflake field drop-down, and choose the column from your table that contains this information.
To map additional fields, select Add another mapping and repeat the process.
Select COMPLETE.