Materialize View creation not supported from DLT Pipeline

abhijitnag
New Contributor II

Hi Team, I have a very basic scenario where I am using my custom catalog and want materialize view to get created from DLT table at the end of pipeline. The SQL used as below for the same.

abhijitnag_1-1704047659613.png

where "loom_data_transform" is a Streaming table. But pipeline fails at the last stage where materialize view is tried to create from "loom_data_transform" with following error message.

abhijitnag_0-1704047565470.png

Could someone please help me on this issue.

warsamebashir
New Contributor II

Hey @abhijitnag are you sure your loom_data_transform was created as a STREAMING table?

 

docs:

https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-streaming-table.html 

 

 

 

Yes, @warsamebashir "loom_data_transform" was created as a STREAMING table as below. And without this Materialize view, the pipeline is executing absolutely fine.

abhijitnag_0-1704077166693.png