how to create Materialized view for a existing table in delta live table in Databricks using pyspark?

Question

Here I am trying to create a materialized view for existing Delta Live Table using pyspark, I tried many times but it shows error every time. Can we create materialized view in DLT?, If so please share the resource? Thank you!

What is the use case for that? Change table structure, or something else? — Alex Ott, Aug 01 '22 at 13:30

score 2 · Answer 1 · answered Aug 01 '22 at 13:24

2

We cannot create materialized view for delta live table, because the delta live table does the same. Instead we can create view in delta live table

answered Aug 01 '22 at 13:24

xavier

51
4

you can accept your own answer using that green check mark – WestCoastProjects Feb 01 '23 at 23:17

how to create Materialized view for a existing table in delta live table in Databricks using pyspark?

1 Answers1