MotherDuck Release Notes updates

M

MotherDuck Release Notes Data & Analytics 2d ago

Redesigned MotherDuck UI: The MotherDuck UI has a new look and feel. Home opens with an Ag

Redesigned MotherDuck UI: The MotherDuck UI has a new look and feel. Home opens with an Agent Chat prompt and a setup tile, while the updated sidebar groups Recents, Favorites, and Attached Databases. Every page also has Support chat in the top right to enable users to get help from our Support team. Introducing Agent Chat: Start an Agent Chat from the prompt box on Home and tell the agent what yo…

M

MotherDuck Release Notes Data & Analytics 13d ago

Row-Level Security, Column-Level Security, and Column Masking: Add secure views to a Share

Row-Level Security, Column-Level Security, and Column Masking: Add secure views to a Share to filter rows, hide columns, or mask values for each consumer. Use current_user and is_role_in_session() to show each consumer different rows. Existing queries keep working, and consumers can't see a view's definition. Set them up in the UI or with CREATE SHARE and ALTER SHARE. Available on Business and Ent…

M

MotherDuck Release Notes Data & Analytics 20d ago

Images and bounding boxes in prompt_jev(): prompt_jev() now supports image classification

Images and bounding boxes in prompt_jev(): prompt_jev() now supports image classification and scoring with PNG/JPEG inputs. New box questions identify bounding boxes matching a prompt, while multiple_choice picks every label that applies instead of just one. GPT-6 Luna in prompt(): Use model := 'gpt-6-luna' in prompt() to access OpenAI's GPT-6 Luna. reasoning_effort now defaults to 'none' for fast…

M

MotherDuck Release Notes Data & Analytics 20d ago

Images and bounding boxes in prompt_jev(): prompt_jev() can now classify and score images.

Images and bounding boxes in prompt_jev(): prompt_jev() can now classify and score images. Pass PNG or JPEG images as BLOBs, for example loaded from a URL with read_blob, and ask questions about what's in them. A new box question returns the rectangle in an image that matches your prompt, while multiple_choice picks every label that applies instead of just one. GPT-6 Luna in prompt(): Pass model :…

M

MotherDuck Release Notes Data & Analytics 28d ago

List users and service accounts with the Admin API: GET /v1/users returns every user and s

List users and service accounts with the Admin API: GET /v1/users returns every user and service account in your organization, with filters for is_service_account and is_deprovisioned and limit/offset paging. Refer to Manage service accounts and tokens for examples. Connection timeout: Set connection_timeout to cap how long opening a MotherDuck connection can take, for example md:my_db?connection_…

M

MotherDuck Release Notes Data & Analytics v1.5.6 1mo ago

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 1mo ago

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 1mo ago

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 1mo ago

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 1mo ago

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 1mo ago

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 1mo ago

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 1mo ago

User agent details in the Duckling Overview UI: The Duckling Overview UI now includes a Us

User agent details in the Duckling Overview UI: The Duckling Overview UI now includes a User Agent column to show Admins the associated client that issued each query, including any custom user agents you have set, for easier sorting, filtering, and search.

M

MotherDuck Release Notes Data & Analytics v1.5 1mo ago

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 2mo ago

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 2mo ago

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 2mo ago

[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 3mo ago

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 3mo ago

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