Question 1

How does incremental syncing behave?

Accepted Answer

Reads resume on the standard modified timestamp with a short lookback for eventual consistency, and use a query mode that includes deleted and archived records. So each run into MotherDuck moves only what changed. One nuance specific to this pairing: incremental stays available only while the calculated fields you selected are ones Polytomic can parse. Selecting an unsupported formula pushes the sync onto the slower full read path, so a page of deeply nested formulas is worth checking.

Question 2

How do deleted Salesforce records appear?

Accepted Answer

As rows flagged deleted rather than removed, and that is worth designing around. Reads include soft deleted records while Salesforce still exposes them, so MotherDuck receives them with the deletion indicator set rather than losing them silently. Your models should filter on that flag unless you specifically want the history. A record that has been hard deleted and purged from the recycle bin can no longer be reported at all.

Question 3

What happens to formula and rollup fields?

Accepted Answer

They arrive as materialized typed values, meaning MotherDuck stores the computed result as an ordinary column rather than recreating the formula. That is usually what you want, since the value is queryable immediately and joins normally. Two things to watch: cross object and deeply nested formulas are the ones most likely to force the slower read path, and currency formulas need multi currency lookup enabled on the connection to resolve correctly.

Question 4

Can I write MotherDuck results back into Salesforce?

Accepted Answer

Yes, and it is the natural second half of this pairing. Once a health score or usage summary is computed in MotherDuck, it can be written onto accounts, contacts, opportunities, or a custom object. Identity is not limited to External ID fields, so you can match on any suitably filterable field, including a custom column holding a product or billing identifier. Relationships can be set by lookup value rather than requiring Salesforce record IDs.

Connect MotherDuck with Salesforce

Connect MotherDuck and Salesforce with Polytomic

Standard and custom objects

Formula fields materialized

Analysis and write back

Trusted by 1,000+ businesses worldwide

Step-by-step integration guide

Connect MotherDuck in Polytomic

Connect Salesforce in Polytomic

Create a sync between MotherDuck and Salesforce

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 MotherDuck with Salesforce?