Question 1

What can I write from Snowflake into Salesloft?

Accepted Answer

Accounts, people, and cadences, where writing to a cadence means adding people to it. The rest of Salesloft is source only, so you can read activity data into your data warehouse for reporting but not write back to it. The writable set covers what most teams want from reverse ETL here: keep account and person records accurate, and control who gets worked and when.

Question 2

Can I add people to a Salesloft cadence from Snowflake?

Accepted Answer

Yes, and missing people are handled for you. If a person selected for a cadence does not exist in Salesloft yet, they are created first and then added, so you do not have to run a separate sync to seed them beforehand. This makes it realistic to model a qualified list in your data warehouse and let enrolment happen automatically as people meet the criteria.

Question 3

What happens to people in my model who are not in Salesloft?

Accepted Answer

That is down to the mode you pick. Update or create adds them, update only skips them, and create only adds the new ones while leaving existing matches untouched. Choose based on whether your data warehouse should be introducing new people into Salesloft or only enriching the ones already there. Update only is the conservative choice if another system owns record creation.

Question 4

Does every run re-query the whole Snowflake model?

Accepted Answer

No. Model syncs are differential by default, so Polytomic runs the query, works out which rows changed since last time, and sends only those. You can go further and set one or more tracking fields, typically an updated at column that always advances when a row changes. After the initial full read, later queries pick up from the saved high water mark, which keeps warehouse compute and sync time down on big models.

Question 5

Why use reverse ETL to drive Salesloft cadences?

Accepted Answer

Because the list of who to contact should reflect everything you know, and that lives in your data warehouse rather than in the sales tool. Usage signals, renewal dates, support history and firmographics get combined in a model, and reverse ETL turns that model into enrolled people and updated fields on a schedule. Reps then work from something current instead of a spreadsheet someone exported last month.

Sync Snowflake to Salesloft

Sync Snowflake to Salesloft with Polytomic

Accounts, people, cadences

Add people to cadences

Create, update or both

Or sync Salesloft to Snowflake

Trusted by businesses worldwide

Step-by-step integration guide

Connect Snowflake in Polytomic

Connect Salesloft in Polytomic

Create a sync between Snowflake and Salesloft

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Snowflake with Salesloft?