Releasesby Glyphprompt_jev SQL function for text classification with TypeSafe AI Jev model
prompt_jev calls Jev, a model from TypeSafe AI, to classify text into categories directly in SQL, answering one closed question per call or several at once. It is unavailable in eu-central-1 and eu-west-1, and organization admins can turn it off.
Also shipped Sep 21, 2026MotherDuck in September 2026 →
BigQuery Studio query results pane shows recent run history
The Query results pane now shows a short history of recent runs for a query, including multi-statement queries, without switching to the Job history tab. It is generally available.
The query history system table is now generally available
The system.query.history system table is now generally available. Use it to access account-wide records for queries run on SQL warehouses or serverless compute, including execution status, duration metrics, and query source. See Query history system table reference .
Cortex AI Function Evaluation for measuring quality (Public Preview)
Snowflake Cortex AI Function Evaluation is now available in public preview, enabling customers to measure the output quality, cost, and token usage of custom AI Functions and Cortex AI calls against labeled datasets.
Cortex AI Function Optimization for more efficient AI implementations (Public Preview)
Snowflake Cortex AI Function Optimization is now available in public preview, enabling customers to automatically search across prompts and models for improved implementations of custom AI Functions.
Cortex Agents Compact API (Preview)
The Cortex Agents Compact API is now available in preview. Use the agent:compact endpoint to summarize a conversation and pass the compact representation to subsequent agent:run requests. Compacting conversation history reduces token consumption and helps conversations stay within the model context window.
You can now use the AlloyDB Columnar Engine as a read-optimized, in-memory cache for HNSW vector indexes
You can now use the AlloyDB Columnar Engine as a read-optimized, in-memory cache for HNSW vector indexes. This feature is generally available ( GA ). It accelerates vector search performance and increases queries per second (QPS) for vector workloads. For more information, see Accelerate queries with the Columnar Engine .
More from MotherDuckEvery MotherDuck release →
- Cross-region DuckLake data paths: Users can now create a DuckLake on external object storage , including in...
- 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 ...
User Agent column in the Duckling Overview UI
The Duckling Overview UI now includes a User Agent column showing Admins the client that issued each query, including custom user agents, for sorting, filtering, and search.
- DuckDB 1.5.6 support: MotherDuck supports DuckDB 1.5.6
- 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.
Official MotherDuck Terraform provider
MotherDuck's official Terraform provider supports Terraform 1.5 and later, for managing databases, shares, roles, secrets, and service accounts as code.
MotherDuck available on AWS Marketplace via Private Offer
MotherDuck is now available on AWS Marketplace via Private Offer, letting customers consolidate billing and transact directly through AWS.
- List users and service accounts with the Admin API: GET /v1/users returns every user and service account in...
- 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.
Flights generally available with HIPAA workload support
Flights have graduated from Preview and support HIPAA workloads. Processing protected health information requires a signed HIPAA BAA with MotherDuck; existing BAAs cover Flights.
Guide commands in the MotherDuck CLI
The motherduck guide command lets users create, edit, and version Guides from the terminal and keep them in version control alongside other source files.