Release· Databricks release notes (AWS)
Deleting a Unity Catalog pipeline now keeps its tables unless you cascade
Deleting a Unity Catalog pipeline in the default publishing mode, from the UI or the Pipelines DELETE API, now leaves its materialized views, streaming tables and views in place. They can still be queried but cannot be updated until they move into an active pipeline. To remove the tables too, the API request must set the cascade field to true; Hive metastore pipelines are unaffected.