MotherDuck
plus
Databricks

Connect MotherDuck with Databricks

Connect Databricks and MotherDuck with Polytomic to move tables between the lakehouse and DuckDB. Both platforms load through external cloud storage, so staging is configured on each side, and Polytomic runs the ETL and reverse ETL between them on whatever schedule suits your work.

Connect MotherDuck and Databricks with Polytomic

Staging on both sides

Databricks loads through its S3 or Azure staging and MotherDuck through your S3 bucket. This is the pair where you configure storage twice.

Complex types on both ends

Databricks and DuckDB both model nested data properly, so structs, arrays, and maps move across without being serialized into strings.

Unity Catalog respected

Reads and writes run as the identity you connect with, so Unity Catalog permissions apply exactly as they would to any other client.

Trusted by 1,000+ businesses worldwide

Bec Hu

Bec Hu

Head of Sales Ops, Chowbus

Chowbus

“The support is among the best I have ever encountered.”

MotherDuck
Databricks

Step-by-step integration guide

Follow these simple steps to connect MotherDuck with Databricks in minutes

1

Connect MotherDuck in Polytomic

Connect MotherDuck to Polytomic with an access token and your database name.

2

Connect Databricks in Polytomic

Connect Databricks with a SQL warehouse hostname and token, plus cloud storage if you are writing.

3

Create a sync between MotherDuck and Databricks

Sync data in either direction between MotherDuck and Databricks. 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

Sync icon

Powerful data sync

Sync data in either direction between MotherDuck and Databricks.

Analytics icon

Advanced analytics

Use both integrations' source and destination capabilities in one managed sync workflow.

Security icon

Enterprise security

Enterprise encryption and security protocols ensure your data remains protected.

Setup icon

Easy setup

Get up and running in minutes with our step-by-step integration guide.

Ready to connect MotherDuck with Databricks?

Start syncing your data in minutes