PolyBase - Delete from external tables
Thanks for the request! This item is currently on our backlog. We will update this item when the status changes.
Sven Gfeller commented
Yes, a way to delete the underlying files of an external table would be great. My usecase is: I want to recreate an external table which I have created with the CETAS (CREATE EXTERNAL TABLE AS SELECT) sytax. Without removing the external files I cannot recreate the external table.
Delete files would be greatly appreciated. Since my external files were created with datestamp and QID (query id) it is also almost impossible to overwrite the data using SQL statements.
Greg Galloway commented
Or if you don't want to support deleting individual rows, it would at least be nice to have a TRUNCATE TABLE MyExternalTable functionality that will delete all the files.