Nov 11, 2026: Semantic view materializations (General availability)

Semantic view materializations are now generally available and are no longer in Preview. With materializations, you can pre-aggregate frequently queried dimensions and metrics in a semantic view to improve query performance.

With this release, you can also do the following:

  • Get recommendations from CoCo: Use the bundled suggest-sv-materializations skill in CoCo to analyze slow semantic view queries or a Snowflake dashboard and get recommended materializations.
  • Check whether a query can use a materialization: Call SYSTEM$CHECK_SEMANTIC_VIEW_MATERIALIZATION_REWRITE to check an existing materialization, or SYSTEM$CHECK_HYPOTHETICAL_SEMANTIC_VIEW_MATERIALIZATION_REWRITE to check a materialization before you create it.
  • Materialize semi-additive metrics: You can now include semi-additive metrics in materializations.

For more information, see the following topics: