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.