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.
Also shipped Sep 10, 2026MotherDuck in September 2026 →
BigQuery conversational analytics adds ML.CORRELATION in preview
Conversational analytics can now use ML.CORRELATION to calculate statistical correlations between a target column and one or more metric columns in a table.
BigQuery ML.METRICS evaluates predictions without a stored model
The preview ML.METRICS function computes classification or regression evaluation metrics on any table or query with actual and predicted values, with no need to create or reference a stored model.
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data. This feature is in Preview .
BigQuery Data Engineering Agent integrates with BigQuery Graph
The Data Engineering Agent now uses BigQuery Graph for extra context between source and destination schemas, improving schema mapping accuracy in data engineering pipelines. It is generally available.
Using dbt artifacts for Slim CI and defer to production in dbt Projects on Snowflake (General availability)
Slim CI, defer to production, failed-execution recovery, and concurrent execution are now generally available for dbt Projects on Snowflake. Reuse dbt artifacts from recent production executions to accelerate development, streamline CI/CD workflows, and recover from failed production runs without maintaining a separate artifact store.
External secret providers (Preview)
External secret providers are now in preview. If your organization already keeps API keys, database passwords, and similar values in AWS Secrets Manager, Azure Key Vault, or Google Cloud Secret Manager, Snowflake can read those values when a query needs them, so you don't have to maintain a second copy in a Snowflake secret .
More from MotherDuckEvery MotherDuck release →
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.
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.
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.
prompt_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.
- 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 ...
Table-level security for shares via INCLUDE_PATTERN
Shares can now include specific tables, views, or schemas instead of an entire database, set with INCLUDE_PATTERN on CREATE SHARE, ALTER SHARE, or the share dialog. Available on Business and Enterprise plans.
Custom roles available on the Business plan
Business plan customers can now create custom roles, which inherit a preset role's platform permissions and can receive data grants directly.