Two staging models, one sync
Snowflake loads through its internal stage, MotherDuck through your S3 bucket. You configure each once and Polytomic does the rest.
Connect MotherDuck with Snowflake
Move tables between Snowflake and MotherDuck with Polytomic. The two warehouses stage loads differently, Snowflake through its own internal stage and MotherDuck through Parquet files in your S3 bucket, and Polytomic handles both sides so ETL and reverse ETL run on a schedule rather than through custom pipelines.
Connect MotherDuck and Snowflake with Polytomic
Semi structured data survives
Snowflake VARIANT and ARRAY columns map onto DuckDB STRUCT and LIST rather than being flattened into text on the way across.
Keyed merges, not blind appends
Tables with a primary key are reconciled on every run, so a Snowflake table synced hourly does not accumulate duplicate rows in MotherDuck.
Trusted by 1,000+ businesses worldwide
Bec Hu
Head of Sales Ops, Chowbus
“The support is among the best I have ever encountered.”
Step-by-step integration guide
Follow these simple steps to connect MotherDuck with Snowflake in minutes
Connect MotherDuck
Connect Snowflake
Create sync
Enable sync
1
Connect MotherDuck in Polytomic
Connect MotherDuck to Polytomic with an access token and your database name.
2
Connect Snowflake in Polytomic
Connect Snowflake to Polytomic with account details, a role, a warehouse, and credentials.
3
Create a sync between MotherDuck and Snowflake
Sync data in either direction between MotherDuck and Snowflake. 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 Snowflake.
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 Snowflake?
Start syncing your data in minutes