Below is the Json object which I have pushed from cosmos to data lake through azure synapse dataflow pipeline. Now if any changes in below data it must overwrite the data in the existing csv file which is present in data lake and if there is no transactional file , it should create new transaction file and continue to append the changes.
I wanted to create pipeline to address above query as I am new boy to this azure cloud platform

Data Exfiltration Protection is enabled on one of our Synapse Workspace. In a notebook, a python script must get a token from Entra ID in order to authenticate to another Azure Service to send data to.

When the code below is executed against a synapse analytics workspace,