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.
create or refresh live table table_name
comment "union of table1 and table2 data"
as
select * from live.table1 union select * from live.table2;
