Forum Discussion

jigarjadav89's avatar
jigarjadav89
Copper Contributor
Jun 08, 2022

External table Always insert in a new file, is there any way to write to same file?

I have a external table in SQL Server which points to CSV files in folder of Azure blob storage, I enabled polybase export and trying to insert data using insert query. It works but it always creates...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 10, 2022

Hi jigarjadav89 -- This is not possible with PolyBase.  PolyBase uses WASB for Azure Blob Storage which is much like HDFS in that it is an append-only filesystem.  That is one of the advantages or use cases for external tables in that they enable interaction the data using standard TSQL syntax while the abstracting the physical storage of the data.  Take care.

Resources