M

MotherDuck Release Notes

M
MotherDuck Release Notes Data & Analytics v1.5

Terraform provider: MotherDuck's official Terraform provider supports Terraform 1.5 and la

Terraform provider: MotherDuck's official Terraform provider supports Terraform 1.5 and later, enabling you to manage databases, shares, roles, secrets, and service accounts as code. AWS Marketplace: MotherDuck is now available on AWS Marketplace via Private Offer, enabling you to consolidate billing and transact directly through AWS. Get in touch to learn more.

M
MotherDuck Release Notes Data & Analytics

Flights are generally available: Flights have graduated from Preview and support HIPAA wor

Flights are generally available: Flights have graduated from Preview and support HIPAA workloads. To process protected health information (PHI), you need a signed HIPAA BAA with MotherDuck. Existing BAAs cover Flights. Guide commands in the MotherDuck CLI: Create, edit, and version Guides from your terminal with motherduck guide, and keep them in version control alongside your other source files.…

M
MotherDuck Release Notes Data & Analytics

Table-level security: You can now share specific tables, views, or entire schemas instead

Table-level security: You can now share specific tables, views, or entire schemas instead of an entire database. Set an INCLUDE_PATTERN such as 'reporting.*, main.orders' when you create a share, change it later with ALTER SHARE, or set it from the share dialog in the UI. Available on Business and Enterprise plans. Refer to the documentation for pattern rules and limitations. Custom roles availabl…

M
MotherDuck Release Notes Data & Analytics

[Preview] MotherDuck CLI: The motherduck CLI lets you authenticate (motherduck login, logo

[Preview] MotherDuck CLI: The motherduck CLI lets you authenticate (motherduck login, logout, status), run SQL queries, and build Dives and Flights from your terminal, with table, JSON, or CSV output for scripting and automation. Refer to the MotherDuck CLI documentation for details. Windows install script for the DuckDB CLI: Windows users can install a MotherDuck-supported DuckDB CLI version with…

M
MotherDuck Release Notes Data & Analytics v1.5.5

DuckDB 1.5.5 support: MotherDuck supports DuckDB 1.5.5. Refer to the changelog and the off

DuckDB 1.5.5 support: MotherDuck supports DuckDB 1.5.5. Refer to the changelog and the official announcement for details. Note: Our install scripts ensure you always have a MotherDuck-supported DuckDB client version. Flights available in Asia Pacific: Flights are now available in AWS Sydney ap-southeast-2 and Tokyo ap-northeast-1 regions. Org-wide Flight visibility for Admins: Users with the Admin…

M
MotherDuck Release Notes Data & Analytics v1.5.5

DuckDB 1.5.5 support: MotherDuck supports DuckDB 1.5.5. Refer to the changelog and the off

DuckDB 1.5.5 support: MotherDuck supports DuckDB 1.5.5. Refer to the changelog and the official announcement for details. Flights available in Asia Pacific: Flights are now available in AWS Sydney ap-southeast-2 and Tokyo ap-northeast-1 regions. Org-wide Flight visibility for Admins: Users with the Admin role have view-only access to every Flight in the organization. Running, editing, and deleting…

M
MotherDuck Release Notes Data & Analytics

[Preview] Guides: You can now teach AI agents your organization's context with Guides: mar

[Preview] Guides: You can now teach AI agents your organization's context with Guides: markdown documents in MotherDuck holding your metric definitions, join rules, columns to avoid, and conventions for Dives and Flights. Agents read them automatically through the MCP server, so every session writes SQL against the same definitions instead of rediscovering them. Share Guides org-wide to align ever…

M
MotherDuck Release Notes Data & Analytics

[Preview] Guides: You can now teach AI agents your organization's context with Guides: mar

[Preview] Guides: You can now teach AI agents your organization's context with Guides: markdown documents in MotherDuck holding your metric definitions, join rules, columns to avoid, and conventions for Dives and Flights. Agents read them automatically through the MCP server, so every session writes SQL against the same definitions instead of rediscovering them. Share guides org-wide to align ever…

M
MotherDuck Release Notes Data & Analytics

Role-based access control (RBAC): Admins can assign roles and grant scoped privileges to c

Role-based access control (RBAC): Admins can assign roles and grant scoped privileges to control access to databases, shares, and platform-level resources using the Members and Roles page in Settings. RBAC is available on Business and Enterprise plans; custom roles are also available for Enterprise customers. Read and write to Cloudflare R2 Data Catalog: MotherDuck can now read from and write to C…

M
MotherDuck Release Notes Data & Analytics

Role-based access controls (RBAC): Admins can assign roles and grant scoped privileges to

Role-based access controls (RBAC): Admins can assign roles and grant scoped privileges to control access to databases, shares, and platform-level resources using the Members and Roles page in Settings. RBAC is available on Business and Enterprise plans; custom roles are also available for Enterprise customers. Read and write to Cloudflare R2 Data Catalog: MotherDuck can now read from and write to…

M
MotherDuck Release Notes Data & Analytics

MotherDuck cloud coverage extends to Asia Pacific: MotherDuck is now available on AWS in A

MotherDuck cloud coverage extends to Asia Pacific: MotherDuck is now available on AWS in Asia Pacific (Sydney) ap-southeast-2 and Asia Pacific (Tokyo) ap-northeast-1. Create new organizations in either region for lower latency and regional data residency. Flights are not yet available in these regions and are coming soon. Run a Flight with a custom config: In the Flights UI, users can click the Ru…

M
MotherDuck Release Notes Data & Analytics

Write to Databricks-managed Iceberg tables: MotherDuck can now write to Databricks-managed

Write to Databricks-managed Iceberg tables: MotherDuck can now write to Databricks-managed Iceberg tables. Flights available on all plans: Flights are now available on Free and Lite plans, in addition to Business. Flight secrets available as non-namespaced environment variables: Flight secrets are now injected into the Flight runtime under both the namespaced _ name and the bare name, so your code…

M
MotherDuck Release Notes Data & Analytics

[Preview] Server-side Iceberg attach: Attach an external Apache Iceberg REST catalog to Mo

[Preview] Server-side Iceberg attach: Attach an external Apache Iceberg REST catalog to MotherDuck and query your Iceberg tables server-side, alongside your MotherDuck and DuckLake data. Available in Preview. dbt Cloud support via the Postgres endpoint: You can now connect dbt Cloud to MotherDuck directly through the Postgres endpoint, without standing up a self-hosted pg_duckdb proxy.

M
MotherDuck Release Notes Data & Analytics v1.4.5

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the c

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the changelog and the official announcement for details. Postgres endpoint JDBC compatibility improvements: The Postgres endpoint now resolves primary keys and indexes, reports column precision and identity metadata, exposes table and column comments, and scopes catalog views to the connected database, enabling BI…

M
MotherDuck Release Notes Data & Analytics v1.4.5

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the c

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the changelog and the official announcement for details. Postgres endpoint JDBC compatibility improvements: The Postgres endpoint now resolves primary keys and indexes, reports column precision and identity metadata, exposes table and column comments, and scopes catalog views to the connected database, enabling [B…

M
MotherDuck Release Notes Data & Analytics

[Preview] Launching Flights - agent-native data pipelines in MotherDuck: Build and deploy

[Preview] Launching Flights - agent-native data pipelines in MotherDuck: Build and deploy data pipelines using a flexible Python runtime, natively connected to your MotherDuck data — for ingest, transformation, warehouse replication, SaaS ETL, and more. Create and manage Flights via SQL, UI, or any MCP-capable AI agent. Available in Preview to Business and Enterprise plans. Read the announcement b…

M
MotherDuck Release Notes Data & Analytics v1.5.3

DuckDB 1.5.3 support: MotherDuck supports DuckDB 1.5.3. Refer to the changelog and the off

DuckDB 1.5.3 support: MotherDuck supports DuckDB 1.5.3. Refer to the changelog and the official announcement for details. Compact URLs for Dives with large filter state: Sharing or copying the URL of a Dive with extensive filters now uses a shortened URL to facilitate easier sharing. Retool Cloud native integration: Connect Retool Cloud apps to MotherDuck through a native MotherDuck resource type,…

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire protocol-compatible MotherDuck client, now enables connectivity with Looker. DuckDB & MotherDuck plugin for Obsidian: Run DuckDB SQL or MotherDuck queries from inside an Obsidian note, with results frozen as a markdown table directly below the query. Local DuckDB blocks run in Wasm with no account required;…

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire protocol-compatible MotherDuck client, now enables connectivity with Looker. DuckDB & MotherDuck plugin for Obsidian: Run DuckDB SQL or MotherDuck queries from inside an Obsidian note, with results frozen as a markdown table directly below the query. Local DuckDB blocks run in Wasm with no account required;…

M
MotherDuck Release Notes Data & Analytics

SCIM provisioning: MotherDuck now supports SCIM, so you can manage MotherDuck users from y

SCIM provisioning: MotherDuck now supports SCIM, so you can manage MotherDuck users from your identity provider. Available on Business and Enterprise plans. Refer to the documentation for more details. Per-session database override for Dives: Embedded Dives and the view_dive MCP tool now accept a required_resources parameter that overrides the Dive's source-declared REQUIRED_DATABASES for the sess…

M
MotherDuck Release Notes Data & Analytics

Data exports from Dives: Dives can now include export buttons that deliver CSV, JSON, Parq

Data exports from Dives: Dives can now include export buttons that deliver CSV, JSON, Parquet, or Excel files, both in the MotherDuck UI and in embedded Dives. Wire up exports from your Dive code with the new exportAs and useExport hooks from @motherduck/react-sql-query. Embedded exports are delivered to your host page through a postMessage channel and require dual mode, now the default for embedd…

M
MotherDuck Release Notes Data & Analytics

Streamlined Dives sidebar: The Dives list in the Object Explorer is now capped at your 10

Streamlined Dives sidebar: The Dives list in the Object Explorer is now capped at your 10 most recent Dives, with a new View all Dives link that opens the full searchable Dives table. Wasm Client SDK no longer requires COI headers: The MotherDuck Wasm client SDK (now at version 1.5.2) no longer requires Cross-Origin Isolation (COI) headers, so custom DuckDB Wasm applications using LOAD motherduck…

M
MotherDuck Release Notes Data & Analytics

Duckling Overview UI: The Duckling Overview page in Settings provides a view of activity a

Duckling Overview UI: The Duckling Overview page in Settings provides a view of activity across every Duckling in the organization over the last 24 hours, including key metrics like status, disk spills, active minutes, and query-level drilldowns. Viewing it requires permission to view organization-wide Duckling activity, which the Admin and Builder preset roles include by default. Dive Viewer Inli…

M
MotherDuck Release Notes Data & Analytics

Duckling Overview UI: The Duckling Overview page in Settings provides a view of activity a

Duckling Overview UI: The Duckling Overview page in Settings provides a view of activity across every Duckling in the organization over the last 24 hours, including key metrics like status, disk spills, active minutes, and query-level drilldowns. Viewing it requires permission to view organization-wide Duckling activity, which the Admin and Builder preset roles include by default. Dive Viewer Inli…

M
MotherDuck Release Notes Data & Analytics

Duckling Overview UI: MotherDuck Admins now have access to a Duckling Overview page in Set

Duckling Overview UI: MotherDuck Admins now have access to a Duckling Overview page in Settings for a view of activity across every Duckling in the organization over the last 24 hours, including key metrics like status, disk spills, active minutes, and query-level drilldowns. Dive Viewer Inline Preview for Remote MCP Server: The MotherDuck remote MCP server now includes an inline preview Dive View…

M
MotherDuck Release Notes Data & Analytics v1.5.2

DuckDB 1.5.2 support: MotherDuck supports DuckDB 1.5.2, a bugfix release. Learn more in th

DuckDB 1.5.2 support: MotherDuck supports DuckDB 1.5.2, a bugfix release. Learn more in the official DuckDB Labs 1.5.2 announcement and changelog. DuckLake 1.0 support: MotherDuck supports DuckLake 1.0. Learn more in the official DuckDB Labs DuckLake 1.0 announcement. Concurrent checkpoints: Checkpoints can now run concurrently to reads, insertions and deletions. Previously they could block or be…

M
MotherDuck Release Notes Data & Analytics

[Preview] Embedded Dives: MotherDuck Dives can now be embedded directly in your customer-f

[Preview] Embedded Dives: MotherDuck Dives can now be embedded directly in your customer-facing applications. Create a Dive, generate an embed session, and drop an iframe into your app. Your end-users can explore data in real time, powered by MotherDuck. Embedded Dives currently require a Business plan. Read the announcement blog for more details or refer to the documentation to get started. Airby…

M
MotherDuck Release Notes Data & Analytics

Configurable Duckling cooldown periods: The cooldown period for Standard, Jumbo, Mega, and

Configurable Duckling cooldown periods: The cooldown period for Standard, Jumbo, Mega, and Giga Ducklings can now be configured from 1 minute to 24 hours via the UI, SQL, or REST API. Learn more in the Duckling sizes documentation. SHUTDOWN and SHUTDOWN TERMINATE commands: Two new SQL commands give you direct control over Duckling lifecycle without waiting for the cooldown period. SHUTDOWN shuts d…