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
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Jason Kappel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      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