Concepts

This section contains a collection of high level views of concepts & features.

Architecture and capabilities

MotherDuck is a serverless cloud analytics service with a unique architecture that combines the power and scale of the cloud with the efficiency and convenience of DuckDB.

Database Concepts

MotherDuck Database Concepts

Storage Lifecycle and Management

Understand how MotherDuck manages data storage across different lifecycle stages and how this affects your billing and data management strategies.

pg_duckdb Extension

pgduckdb is an Open-source Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres.

Object name resolution

Fully qualfied naming convention

DuckDB Extensions in MotherDuck

MotherDuck supports a wide array of DuckDB extensions to enhance your analytics workflows. Support varies depending on whether you are using the DuckDB CLI, the MotherDuck cloud service (server-side), or the MotherDuck Web UI.

DuckLake

Understanding DuckLake - A high-performance open table format for petabyte-scale analytics

Results

Results