Deleting external table takes 8 hrs

Ankita1
New Contributor

Hi,

I am trying to delete the data from the external partitioned table, it has around 3 years of data, and the partition is created on the date column.

I am trying to delete each partition first and then the schema of the table, which takes around 8hrs of time. Is there any way to reduce this time?

Thanks.