franco_patano
Databricks Employee
Databricks Employee

You cant delete data from a view, but you can create or replace temp view with the same name with the data you want deleted filtered out.

For example, if you have a view myview, that you want to delete the record with id=2, do the following:

CREATE OR REPLACE TEMP VIEW myview

as

select * from myview where id = 2;

Franco Patano
Stragetic Data and AI Advisor