Changes to deletion behavior of Materialized View and Streaming Tables defined by Delta Live Table

MariuszK
Valued Contributor III

Hi,

Sometime ago, I got a message that there will be a change (starting from 01/31/2025) in "deletion behavior of Materialized View and Streaming Tables defined by Delta Live Table", but when I remove dlt pipeline, it also removes related tables, will it be change?

Alberto_Umana
Databricks Employee
Databricks Employee

Hi @MariuszK,

The users will need to explicitly call DROP MATERIALIZED VIEW to delete MVs and DROP TABLE to delete STs, when deleting DLT pipelines. https://home.databricks.com/account-alert-deletion-behavior-change-for-materialized-view-and-streami...

MariuszK
Valued Contributor III

Hi @Alberto_Umana,

Thank you for your answer. The link isn't working for me.

I can't find this info in release notes, I tested the behavior and all tables created by DLT pipeline was removed, I created a pipeline using PySpark.