If a query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
Materialized-view query rewrite is discretionary: Snowflake’s optimizer can choose the base table when it estimates equivalent or better performance, such as when clustering enables effective micro-partition pruning. A matching materialized view is therefore eligible for rewrite but is not guaranteed to be used.
Community Discussion