Post reply

Loading data in Azure Synapse using Copy

  • July 13, 2020 at 12:00 am

    #3768249

    Comments posted to this topic are about the item Loading data in Azure Synapse using Copy

  • July 14, 2020 at 6:55 pm

    #3769852

    Nice article and steps!!!

    Thomas LeBlanc, MVP Data Platform Consultant

  • July 22, 2020 at 11:29 am

    #3773699

    Nice article but not able to see titanic.csv file to download to my machine and use it to load into my Azure Synapse.

    Also a screen shot at step #10 would be great.

    • This reply was modified 3 years, 9 months ago by  rbadiger.

    baazigar

  • July 22, 2020 at 5:55 pm

    #3773907

    Got it from one of the Git repository and used it to load the data  and it worked.

    baazigar

  • July 23, 2020 at 10:20 am

    #3774086

    Step #10 is same as the screenshot shared at step #4. Only the login id and the password used in the two steps are different.

    The CSV file I have used is attached here.

    Attachments:
    You must be logged in to view attached files.

  • October 27, 2020 at 4:23 pm

    #3801769

    I have followed the steps, downloaded the titanic csv from github but when I try to run the copy into command, it runs but no records are loaded. Correct container name, correct storage name, same permissions as listed above (screen shots slightly different due to Microsoft changing things, not sure why no records are being loaded. there is no red error message, just no records get loaded.

  • October 28, 2020 at 6:19 am

    #3801966

    You may try all the steps again with the attached file. Please make sure that the required permissions are in place.

    Attachments:
    You must be logged in to view attached files.

  • November 17, 2020 at 8:05 am

    #3808606

    Thanks for the article. But I keep having the same error message 'Incorrect syntax near the keyword 'INTO'

    The only difference is the region, and I saw in a forum that this functionality may not be present on all. But I can't find anywhere this information in the documentation...

    Does anyone know if the error message is accurate, that it doesn't occur even when the syntax is correct ?

    • This reply was modified 3 years, 5 months ago by  crazywolf.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply