Edit on GitHub
MotherDuck Partner-Built Private Previewlink
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 guidelink
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 mappinglink
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 | Notes |
---|---|---|
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 |