Vaccum and backup - stg_nl_wholesaler

h4. Information

 

To optimize storage, we need to vacuum the stg_nl_wholesaler table while ensuring the data is backed up for future reference. The plan is to deep clone the stg_nl_wholesaler table to stg_nl_wholesaler_clone and then vacuum the original table, retaining only the last 7 days of data.

 

h4. Requirement

 

Write Databricks SQL queries to:

 

1. Clone the stg_nl_wholesaler table into stg_nl_wholesaler_clone if already exist replace it.
2. Using Databricks Vacuum retain 7 days (168 HOURS) of data for the table stg_nl_wholesaler.

 

 

Unity Catalog Information: purgo_playground.stg_nl_wholesaler.

 

Expected Output: A Databricks SQL query and purgo_playground.stg_nl_wholesaler_clone