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://***', format = 'csv', fieldterminator ='0x0b',fieldquote = '0x0b') with (doc nvarchar(max)) as j"

    I am running this exception Parse error at line: 1, column: 24: Incorrect syntax near 'OPENROWSET'.

    Any pointers would be appreciated. 

    Thank you!


    Thursday, September 3, 2020 6:23 PM

All replies