Forum Discussion
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...
Hi jigarjadav89
You can use Azure Logic app to create or append the information from the new files once they created into a new single file.
For the task you simply use Azure Logic Apps trigger named "When blob is added or modified".
Once a new file will be added then this app will run and in the app you can append the data from the new file to the existing file.
Since this action will be triggers by external app and not related to the database server, it will NOT reduce any performance of your server, which make this solution useful
- Ronen_Ariely, Thanks for the response, It was one of our plan to do append through other app, we planned using ssis, but this looks a good solution, we will try this.
- You are most welcome 🙂
