Mo
Databricks Employee
Databricks Employee

@ImranA and @igorstar 

I repost my response here again:
to create materialized views, you could use CREATE OR REFRESH LIVE TABLE however according to the official docs:

  • The CREATE OR REFRESH LIVE TABLE syntax to create a materialized view is deprecated. Instead, use CREATE OR REFRESH MATERIALIZED VIEW.

As you can, it's changed so folks won't get confused about the namings.

Let me know if this helps

 

View solution in original post