⟳ Updates Hub
M
Home / Data & Analytics

MotherDuck Release Notes

Website ↗ RSS 79 items Fetched 16m ago
M
MotherDuck Release Notes Data & Analytics v1.5.6

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

DuckDB 1.5.6 support: MotherDuck supports DuckDB 1.5.6. Refer to the changelog and the official announcement for details. Note: Our install scripts ensure you always have a MotherDuck-supported DuckDB client version. Lower prices for AI functions: The prompt() and embedding() functions now cost 50–60% less on every OpenAI model, which brings them in line with other providers. Each AI Unit covers m…

M
MotherDuck Release Notes Data & Analytics v1.5.6

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

DuckDB 1.5.6 support: MotherDuck supports DuckDB 1.5.6. Refer to the changelog and the official announcement for details. Note: Our install scripts ensure you always have a MotherDuck-supported DuckDB client version. Lower prices for AI functions: prompt and embedding now cost 50–60% less on every OpenAI model, which brings them in line with other providers. Each AI Unit covers more input and outp…

M
MotherDuck Release Notes Data & Analytics

Cross-region DuckLake data paths: Users can now create a DuckLake on external object stora

Cross-region DuckLake data paths: Users can now create a DuckLake on external object storage, including in regions outside your MotherDuck organization. Lower memory use for LIMIT queries on wide tables: SELECT * FROM LIMIT n, LIMIT ... OFFSET, small ORDER BY ... LIMIT, and SAMPLE now scan only the row groups holding the requested rows instead of every row group in the table.

M
MotherDuck Release Notes Data & Analytics

Classify text with prompt_jev: prompt_jev sorts text (e.g., support tickets, reviews) into

Classify text with prompt_jev: prompt_jev sorts text (e.g., support tickets, reviews) into categories directly in SQL using Jev, a TypeSafe AI model that returns a true/false probability, a label, or a score instead of writing prose for 50x speed improvements at 1% of the cost of a frontier model. Ask one question or several in a single call about a piece of text: whether a statement is true, whic…

M
MotherDuck Release Notes Data & Analytics

Classify text with prompt_jev: prompt_jev sorts text (e.g., support tickets, reviews) into

Classify text with prompt_jev: prompt_jev sorts text (e.g., support tickets, reviews) into categories directly in SQL using Jev, a TypeSafe AI model that returns a true/false probability, a label, or a score instead of writing prose for 50x speed improvements at 1% of the cost of a frontier model. Ask one question or several in a single call about a piece of text: whether a statement is true, whic…

M
MotherDuck Release Notes Data & Analytics

Classify text with prompt_jev: Sort support tickets, reviews, or any other text into categ

Classify text with prompt_jev: Sort support tickets, reviews, or any other text into categories directly in SQL, at roughly 50x the speed and 1% of the cost of a frontier model with comparable accuracy. prompt_jev calls Jev, a model from TypeSafe AI that answers one closed question about a piece of text — whether a statement is true, which label from a list fits, or where the text sits on a scale…

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…