How to remove specific data from bronze layer

Nisha_Aggarwal
New Contributor II

Hello Team,

At my end, we bring data from Kafka and through autoloader we ingest it in Bronze layer and further to silver and silver plus layer. Lately due to business changes, we need to delete specific data from the bronze and silver layer due to data protection act and governance side. How can I delete/update data in bronze especially when it is in streaming mode. Could you suggest the approach to go ahead with it?