The really nice feature of Snowflake’s materialized views is that they are automatically kept in sync with their underlying SQL.
Snowflake is doing this in the background for us. And even if it has not been done yet, Snowflake realizes that from you SQL query, and as quickly as possible updates the MV and uses underlying tables rows to return the correct result.
Limitations:
- No joins
- No UDF
- No having clause
- No order by
- No limit
If you ever want to test Snowflake’s Materialized Views you may want to do this for repeat queries: alter session set use_cached_result = false;
alter session set use_cached_result = false;
Keywords: tune, optimize, performance, materialize