9.40 Release Notes: Dec 15, 2025-Jan 09, 2026¶

Notifications for data quality incidents (Preview)¶

Snowflake can automatically send a notification when there is a data quality incident in a database. A data quality incident occurs when the return value of a data metric function (DMF) violates an expectation or constitutes an anomaly.

Notifications can be sent via email or through an external system like Slack, Teams, and PagerDuty.

For more information, see Sending notifications for data quality issues.

Deprecation of external OpenAI model routing for Cortex Analyst¶

Snowflake has deprecated the ENABLE_CORTEX_ANALYST_MODEL_AZURE_OPENAI account parameter that routes Cortex Analyst requests to external OpenAI GPT models using Azure OpenAI outside the Snowflake secure perimeter.

Snowflake deprecated this legacy configuration for the following reasons:

• It sends data outside Snowflake’s trusted environment.

• It uses older model versions.

• Newer GPT and Claude models now run fully within the Snowflake secure perimeter, offering better text-to-SQL accuracy and stronger security.

Snowflake no longer honors this parameter.

USE ROLE ACCOUNTADMIN;

ALTER ACCOUNT SET ENABLE_CORTEX_ANALYST_MODEL_AZURE_OPENAI = FALSE;

ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION';

Semantic views: Using standard SQL clauses to query semantic views (Preview)¶

You can now use standard SQL clauses in a SELECT statement to query a semantic view.

This feature is in Preview.

You can just specify the name of the semantic view in the FROM clause, rather than specifying the SEMANTIC_VIEW clause. For example, the following query specifies the SEMANTIC_VIEW clause:

SELECT * FROM SEMANTIC_VIEW(
    tpch_analysis
    DIMENSIONS customer.customer_market_segment
    METRICS orders.order_average_value
  )
  ORDER BY customer_market_segment;

The following statement demonstrates how to execute the same query without specifying the SEMANTIC_VIEW clause:

SELECT customer_market_segment, AGG(order_average_value)
  FROM tpch_analysis
  GROUP BY customer_market_segment
  ORDER BY customer_market_segment;

For information, see Specifying the name of the semantic view in the FROM clause.