https://community.databricks.com/t5/data-engineering/programatically-remove-external-table-completely-azure/m-p/95454#M39105 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/79252">@johnb1</a>&nbsp;</P><P>You can achieve this with the code below. Please review.</P><LI-CODE lang="markup">table_name = "table_name" location = "abfss://container@storage-account.dfs.core.windows.net/path/to/table/data/" spark.sql(f"DROP TABLE IF EXISTS {table_name}") dbutils.fs.rm(location, recurse=True) ######################################## #Note even you can extract location by doing below df = spark.sql(f"DESCRIBE DETAIL {table_name}") location = df.select("location").collect()[0]["location"]</LI-CODE><P>&nbsp;</P> Tue, 22 Oct 2024 10:40:31 GMT Panda 2024-10-22T10:40:31Z https://community.databricks.com/t5/data-engineering/programatically-remove-external-table-completely-azure/m-p/95435#M39102 <P>Hi!</P><P>I have created external tables with data stored in an Azure storage account.</P><P>Is there a way to not only drop the tables but also remove the underlying folder in the storage account which contains the table's data? I want to do this from Databricks in either SQL or Python.</P> Tue, 22 Oct 2024 09:44:54 GMT https://community.databricks.com/t5/data-engineering/programatically-remove-external-table-completely-azure/m-p/95435#M39102 johnb1 2024-10-22T09:44:54Z https://community.databricks.com/t5/data-engineering/programatically-remove-external-table-completely-azure/m-p/95454#M39105 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/79252">@johnb1</a>&nbsp;</P><P>You can achieve this with the code below. Please review.</P><LI-CODE lang="markup">table_name = "table_name" location = "abfss://container@storage-account.dfs.core.windows.net/path/to/table/data/" spark.sql(f"DROP TABLE IF EXISTS {table_name}") dbutils.fs.rm(location, recurse=True) ######################################## #Note even you can extract location by doing below df = spark.sql(f"DESCRIBE DETAIL {table_name}") location = df.select("location").collect()[0]["location"]</LI-CODE><P>&nbsp;</P> Tue, 22 Oct 2024 10:40:31 GMT https://community.databricks.com/t5/data-engineering/programatically-remove-external-table-completely-azure/m-p/95454#M39105 Panda 2024-10-22T10:40:31Z