Error: DML Operations are not supported with external tables when attempting to delete a ROW on Synapse SQL Dataware Serverless Pool

Question

Can someone let me know how to delete the first row from the External Table on Serverles SQL Pool

When I execute the code

DELETE TOP (1)
FROM [dbo].[MyTable]

I get the error:

DML Operations are not supported with external tables.

Answer 1

Hello @Carlton Patterson ,

Welcome to the MS Q&A platform.

The error message is expected when you try to delete the rows from the external tables. External tables are read-only. We can't perform DML operations.

With Synapse SQL, you can use external tables to read external data using dedicated SQL pool or serverless SQL pool.

Please see the below documentation for more details. Let us know if you have any further questions.

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop

------------------------------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators