MotherDuck Private Preview
MotherDuck is a DuckDB-powered serverless data warehouse with a unique architecture that combines the power and scale of the cloud with the efficiency and convenience of DuckDB. Fivetran supports MotherDuck as a destination.
Setup guide
Follow our step-by-step MotherDuck setup guide to connect your MotherDuck data warehouse with Fivetran.
NOTE: This destination is partner-built. For any questions related to MotherDuck destination and its documentation, contact MotherDuck Support.
Type transformation mapping
The data types in your MotherDuck data warehouse follow Fivetran's standard data type storage.
We use the following data type conversions:
| Fivetran Data Type | Destination Data Type |
|---|---|
| BOOLEAN | BOOLEAN |
| SHORT | SMALLINT |
| INT | INTEGER |
| LONG | BIGINT |
| FLOAT | FLOAT |
| DOUBLE | DOUBLE |
| DECIMAL | DECIMAL |
| LOCALDATE | DATE |
| LOCALDATETIME | TIMESTAMP |
| INSTANT | TIMESTAMP |
| STRING | VARCHAR |
| JSON | VARCHAR |
| BINARY | BIT |
Limitations
History mode is not supported for MotherDuck destinations.