What is the difference between LIVE TABLE and MATERIALIZED VIEW?

[igorstar]

From the DLT documentation it seems that the LIVE TABLE is conceptually the same as MATERIALIZED VIEW. When should I use one over another?

[Anonymous]

Hi @igorstar 

We haven't heard from you since the last response from @Mo , and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others. 

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[ImranA]

I cant see the reply from @Mo, Has it been deleted or Am I missing something here?

[Mo · Accepted solution]

@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