dlt pipeline will not create live tables

mysteryuser000 — Tue, 18 Jun 2024 04:09:22 GMT

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"

select * from live.table1 union select * from live.table2;

topic dlt pipeline will not create live tables in Data Engineering

dlt pipeline will not create live tables