How can we improve Microsoft Azure Logic Apps?

Read a csv file and bulk load into Azure SQL table

I would like to read in a file from blob and add a row to a table in Azure SQL server. It would be nice to have a bulk import like bcp but also be able to add new rows as the file grows.

126 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Jason Kappel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Matt commented  ·   ·  Flag as inappropriate

    The way I do this is move the Data Lake, then have a job there parse the data. Then I go to my ADW and pull the data in via polybase and external tables. A lot of work but ADL makes it very performant.

Feedback and Knowledge Base