none
Running queries on Azure Synapse DW RRS feed

  • Question

  • Hi,

    I am trying to connect to a synapse dw through a python script. 

    The query I am running is 

    "SELECT * FROM OPENROWSET (BULK 'https://***.blob.core.windows.net/mysql/20200716000000.json', format = 'csv', fieldterminator ='0x0b',fieldquote = '0x0b') with (doc nvarchar(max)) as j"

    I am running this exception

    com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 1, column: 24: Incorrect syntax near 'OPENROWSET'.

    Any pointers would be appreciated. 

    Thank you!

    Geetha

     
    Thursday, September 3, 2020 6:23 PM

All replies