Structured types preserved
Maps become maps, named tuples become structs, and nested columns become arrays of structs rather than JSON.
Sync MotherDuck to ClickHouse
Move data between ClickHouse and MotherDuck with Polytomic. Both engines model nested data properly, so this pairing preserves structured types on the way across, with maps, tuples, and typed arrays surviving the trip.
Sync MotherDuck to ClickHouse with Polytomic
Arrays stay typed
Typed arrays keep their element type instead of collapsing into an untyped JSON value on arrival.
Watermark incremental
Reads resume on a tracking column, which moves only changed rows but does not surface deletions.
Or sync ClickHouse to MotherDuck
Polytomic is bi-directional by default, so you can move data the other way just as easily.
Trusted by businesses worldwide
Jonathan Krangel
VP Global Head of Revenue Operations
“Polytomic handles so many ETL and sync jobs at Cursor. They are a true partner to us.”
Step-by-step integration guide
Follow these simple steps to connect MotherDuck with ClickHouse in minutes
Connect MotherDuck
Connect ClickHouse
Create sync
Enable sync
1
Connect MotherDuck in Polytomic
Authentication is a MotherDuck access token rather than a host and password. You also supply the database name you want to work against. Database names accept letters, digits, hyphens, underscores, slashes, and dots.
2
Connect ClickHouse in Polytomic
Polytomic connects over the ClickHouse native protocol, typically port 9440 with TLS. ClickHouse Cloud and self hosted clusters use the same connector. For destination use you also provide cloud object storage for staging. SSH tunneling is supported.
3
Create a sync between MotherDuck and ClickHouse
Sync data in either direction between MotherDuck and ClickHouse. Choose the source data and destination objects for the direction you need.
4
Map fields and enable the sync
Map the fields, choose the sync schedule and behavior, then save and enable the sync.
Frequently asked questions
Get answers to common questions about the integration process
The sync and ETL platform that does it all
Powerful data sync
Sync data in either direction between MotherDuck and ClickHouse.
Advanced analytics
Use both integrations' source and destination capabilities in one managed sync workflow.
Enterprise security
Enterprise encryption and security protocols ensure your data remains protected.
Easy setup
Get up and running in minutes with our step-by-step integration guide.
Ready to connect MotherDuck with ClickHouse?
Start syncing your data in minutes