Connect MotherDuck data with any data source.

Move data from any source into MotherDuck with Airbyte.

Load data into MotherDuck Read the docs

Sources: 590+
Certified support: 0.2.5

Overview

What is the Airbyte MotherDuck connector?

The Airbyte MotherDuck connector loads data from 590+ Airbyte sources into MotherDuck, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into MotherDuck from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the MotherDuck connector on Cloud, OSS, Hybrid.

Setup

Live in three steps

Confirm your MotherDuck destination credentials and permissions.
Configure the destination in Airbyte with the required connection settings.
Choose a source, map streams, and schedule syncs into MotherDuck.

Configuration fields

MotherDuck configuration fields
Field	Type	Description
motherduck_api_key*	string	API access token to use for authentication to a MotherDuck database.
destination_path	string	Path to a.duckdb file or 'md: ' to connect to a MotherDuck database. If 'md:' is specified without a database name, the default MotherDuck database name ('my_db') will be used.
schema	string	Database schema name, defaults to 'main' if not specified.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

MotherDuck connector questions

What data can I load into MotherDuck with Airbyte?

Airbyte moves data from any supported source into MotherDuck on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the MotherDuck connector support incremental sync?

Yes. The MotherDuck destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the MotherDuck connector?

Run the MotherDuck connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales