Tuesday, July 23, 2024

How to list drop schema in databricks

 %sql

SELECT event_time, user_identity.email, action_name, request_params
FROM system.access.audit
where action_name='deleteSchema'
AND event_date = current_date()
ORDER BY event_time DESC
LIMIT 100;