topic Re: What is the difference between LIVE TABLE and MATERIALIZED VIEW? in Warehousing & Analytics

What is the difference between LIVE TABLE and MATERIALIZED VIEW?

igorstar — Thu, 29 Jun 2023 16:17:00 GMT

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 — Wed, 12 Jul 2023 10:03:01 GMT

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 — Mon, 02 Dec 2024 10:29:47 GMT

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

Mo — Tue, 10 Dec 2024 08:41:47 GMT

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