Ashwin_DSA
Databricks Employee
Databricks Employee

Hi @IM_01,

You can stream from views (including SDP temporary views) as long as those views ultimately sit on append‑only streaming/Delta tables. Using a materialized view as the base is not supported. MV refresh can rewrite history (updates/deletes), breaking the append‑only contract that streaming tables rely on, even if your pipeline currently runs without errors.

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***