Hi folks,
I was like exporting stale data from dataverse to azure data lake storage using azure synapse link. which actually stores/export table rows to a blob file (CSV file) in azure data lake.
The problem is, In our scenario we need to update some rows in that actual exported blob file (CSV file which stores table rows data for each insert/update/delete) and we updated the file the next insert from azure synapse link is replacing the entire file not appending on it replaces entire file. so it is like if we do any changes on that blob file from azure synapse link it replaces entire file for the next insert.
Is azure synapse link process will work in this way or can we stop replacing the entire file and can we make it for only append after the last record is possible?
or any suggested option to sort this issue out.

Report
All responses (
Answers (