DuckDB data store setup in minutes

Automate DuckDB from a single space with no code

DuckDB is an embeddable SQL database management system.

DuckDB is a high-performance, open-source SQL database management system designed to be embedded in other software applications. It is optimized for analytical queries and can handle large datasets with ease. DuckDB is easy to use and can be integrated into a wide range of applications, including data analysis tools, business intelligence software, and more. It supports standard SQL syntax and provides a range of advanced features, including support for window functions, common table expressions, and more. With its small footprint and low resource requirements, DuckDB is an ideal choice for developers looking to add powerful database functionality to their applications.

Settings

File Path

The path to the file or directory containing the data to be loaded into DuckDB.

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.