MotherDuck Connect

MotherDuck data store setup in minutes

Setup the Matatika platform to deliver and process your data in MotherDuck in minutes.

Automate MotherDuck from a single space with no code

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

Settings

MotherDuck Connection String

The MotherDuck connection string.

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.

schema_mapping

A mapping of input schema names to output schema names.

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.


View source code

MotherDuck

Collect and process data from 100s of sources and tools with MotherDuck.

Interested in learning more?

Get in touch