DuckDB Connector

DuckDB

tap-duckdb (meltanolabs variant)

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

Flattening Enabled

Enables or disables flattening of nested data structures.

Flattening Max Depth

Specifies the maximum depth of nested data structures that can be flattened.

Path

Specifies the path to the database file.

Stream Map Config

Specifies the configuration for stream mapping.

Stream Maps

Specifies the stream mapping rules.

Meltano Cloud Connector

DuckDB connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Get in touch Book a demo

Why Meltano?

Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.

Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.

No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.

Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.

Resources

View source code