Connect DuckDB data with any data source.

Send data from every Airbyte source to DuckDB.

Load data into DuckDB Read the docs

Sources: 590+
Standard support: 0.6.0

Overview

What is the Airbyte DuckDB connector?

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

01
Load from any source
Move data into DuckDB 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 DuckDB connector on Cloud, OSS, Hybrid.

Setup

Live in three steps

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

Configuration fields

DuckDB configuration fields
Field	Type	Description
destination_path*	string	Path to the.duckdb file, or the text 'md:' to connect to MotherDuck. The file will be placed inside that local mount. For more information check out our docs
motherduck_api_key	string	API key to use for authentication to a MotherDuck database.
schema	string	Database schema name, default for duckdb is 'main'.

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

DuckDB connector questions

What data can I load into DuckDB with Airbyte?

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

Does the DuckDB connector support incremental sync?

Yes. The DuckDB 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 DuckDB connector?

Run the DuckDB 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