I have created a dlt pipeline based four sql notebooks, each containing between 1 and 3 queries.  Each query begins with "create or refresh live table ..." yet each one outputs a materialized view.  I have tried deleting the materialized views and running the pipeline from scratch but it creates views again.

I can't find any examples of other people having this issue. What am I doing wrong? Below is one of the queries.