Sync Snowflake to Marketo in Five Minutes

Having accurate and up-to-date information synced from Snowflake to Marketo is crucial for effective marketing campaigns.

However, no native integration exists between these two systems.

Luckily, Polytomic enables fast syncing between Snowflake and Marketo.

This blog post will explore how you can use Polytomic to set up a sync between Snowflake and Marketo in less than five minutes. No coding required.

Step 1 - Setup

Once you get started with Polytomic, the first thing you’ll do is connect Snowflake and Marketo to Polytomic.

To connect Snowflake and enable Polytomic to write to Snowflake, you will need to take the steps outlined on our docs page.

To connect Marketo, you will need to enter three pieces of information: Client ID, Client Secret, and the Web Services REST API endpoint. Our docs page will help you find this information.

Once everything is connected to Polytomic, the next step is to create your data model.

Step 2 - Create a Model

A data model is a specific selection of data from your source system (Snowflake in this case) that you can then set up a sync for.

You can select any Snowflake schema, table, and even specific fields that you have access to and save them into your data model.

For example, you could select the ‘Contacts’ table from a ‘Sales CRM’ schema to save into your data model.

You might also want to create another model with account information and then join it to your first model so the data can be sent over together.

Whatever data you can join across Snowflake and Marketo using a common key, you can save that data into a model and sync it over. This leads us to the final step…

Step 3 - Set Up the Sync

Setting up the sync starts with you choosing your destination (Marketo in this case) as well as the target object in the destination system.

For example, the ‘Leads’ object within Marketo.

You can then select from one of three modes:

• Create: Create records when they don’t exist; don’t update existing ones
• Update: Update existing records only; don’t create new ones
• Create or Update: Update records when they exist and create them when they don’t

From there, you map the data from Snowflake to Marketo starting with the identity (the key) and then individual fields. That way, the data arrives where you expect it to.

Additionally, you can select model filters so that only data that meets certain criteria get synced, and you can select certain overrides.

The last step in this process is to select how often you’d like the data to sync. It could be continuous, hourly, daily, weekly, one-time, or based on a custom schedule.

Once that sync is saved, you can choose to sync five random records as a test or go ahead and enable the sync to start running.

And that’s it! Your data is now seamlessly flowing from Snowflake to Marketo.

Other Nice Features

Some other things we think you’ll love:

• Only sync data that has changed
• Minimal API usage
• Custom SQL queries
• Error detection and handling
• ‘Best Support’ in our category according to G2

Conclusion

With three quick steps, Polytomic makes it easy to have seamless data integration between Snowflake and Marketo.

Start today by getting a free trial.