- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2023 09:17 AM
From the DLT documentation it seems that the LIVE TABLE is conceptually the same as MATERIALIZED VIEW. When should I use one over another?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 12:40 AM - edited 12-10-2024 12:41 AM
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, useCREATE 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2023 03:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2024 02:28 AM - edited 12-02-2024 02:29 AM
I cant see the reply from @Mo, Has it been deleted or Am I missing something here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 12:40 AM - edited 12-10-2024 12:41 AM
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, useCREATE 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
![](/skins/images/8C2A30E5B696B676846234E4B14F2C7B/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/8C2A30E5B696B676846234E4B14F2C7B/responsive_peak/images/icon_anonymous_message.png)