DROP multiple tables at once in Azure Databricks
Iterate through you AllTablesInDatabase as a list and issue a drop table statement if it doesn't exist in your RequiredTablesInDatabase list
I have two tables as below
Table 1: AllTablesInDatabase
Table 2: RequiredTablesInDatabase
Now, i want to drop all the table at a time which is not matching between these two tables using python or scala.