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
duckdb-engineRecommended
PyPI Package:
duckdb-engineduckdb:////path/to/duck.dbSupported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Troubleshooting
Common error messages you may encounter when connecting to or querying MotherDuck, along with their causes and solutions.
Notes
DuckDB supports both local file and in-memory databases. Use `:memory:` for in-memory database.
Resources