We have azure synapse with external data source as azure dala lake gen2. We need to export T-SQL query results as csv file on weekly schedule from azure synapse to any blob storage or FTP. I could not find documents related to export from synapse. Pls guide me through this .struck here for long time.

CodePudding user response：

Per this answer, I think the answer is:

1. Make a Dataflow where
   1. the source is the Synapse db and you pass the query you want
   2. the sink is a csv in ADLS gen2
2. Make an ADF pipeline with a weekly schedule trigger that calls your Dataflow