CODEWITHSUNDEEP
azureazure-synapse
Arvind A
Arvind A

Reputation: 77

Ezport data from azure synapse sql

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 a weekly schedule from Azure synapse to any blob storage or FTP. I could not find documents related to export from synapse. Please guide me through this - I've been stuck here for a long time.

Upvotes: 1

Views: 1745

Answers (1)

Anders Swanson
Anders Swanson

Reputation: 3961

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

Upvotes: 1

Related Questions