9.40 Release Notes: Preview¶

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.

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;

Copy tags when running a CREATE OR REPLACE TABLE command (Preview)¶

A new COPY TAGS parameter of the CREATE OR REPLACE TABLE command allows you to copy tags that are associated with the original table and its columns. The newly created table and its columns are associated with the same tags.