Version:

MotherDuck

MotherDuck is a serverless cloud analytics platform built on DuckDB. It combines the simplicity of DuckDB with cloud-scale data sharing and collaboration.

Installation

Required packages: duckdb-engineduckdbduckdb-engine

Drivers

duckdb-engineRecommended

PyPI Package: duckdb-engine

duckdb:////path/to/duck.db

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Notes

DuckDB supports both local file and in-memory databases. Use `:memory:` for in-memory database.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit duckdb.py