We can use ALTER TABLE table_name ENABLE NO_DROP to prevent a table partition from being dropped.
We can use ALTER TABLE table_name ENABLE OFFLINE to prevent a table partition from
being queried. In offline mode, we can still access metadata of a table partition.