topic Changes to deletion behavior of Materialized View and Streaming Tables defined by Delta Live Table in Data Engineering

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

MariuszK — Tue, 04 Feb 2025 08:53:50 GMT

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?

Re: Changes to deletion behavior of Materialized View and Streaming Tables defined by Delta Live Tab

Alberto_Umana — Wed, 05 Feb 2025 01:01:58 GMT

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-streaming-tables-defined-by-delta-live-table-pipelines-2/

Re: Changes to deletion behavior of Materialized View and Streaming Tables defined by Delta Live Tab

MariuszK — Wed, 05 Feb 2025 07:46:28 GMT

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.