The cloud data warehouse built for answers, in SQL or natural language. Fast, serverless analytics powered by DuckDB–from production apps to internal insights.

The target MotherDuck database is not created automatically, so it must already exist before running a pipeline.

Settings

MotherDuck Connection String

The MotherDuck connection string. The referenced database (e.g. my_database in md:my_database) is not created automatically so it must already exist in your MotherDuck account.

MotherDuck Token

Your MotherDuck token.

Batch Size Rows

The number of rows to load into DuckDB at a time.

Flush All Streams

Whether to flush all streams after loading data into DuckDB.

Default Target Schema

The default schema to use when loading data into DuckDB.

Add Metadata Columns

Whether to add metadata columns to the output table.

Hard Delete

Whether to perform a hard delete when deleting data from DuckDB.

Data Flattening Max Level

The maximum level of data flattening to perform when loading data into DuckDB.

Primary Key Required

Whether a primary key is required for the output table.

Validate Records

Whether to validate records before loading them into DuckDB.

Temporary Directory

The directory to use for temporary files when loading data into DuckDB.