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.
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.