My SQL row headers shows in one column in synapse

Question

when i run the usual command below, all my row headers are in one column in the output.

how do i fix that. Normally i would use 'sep=;' on pyspark. can someone explain how i do that on sql

SELECT
    TOP 100 *
FROM
    OPENROWSET(
        BULK 'https://path...',
        FORMAT = 'CSV',
        HEADER_ROW = TRUE,
        PARSER_VERSION = '2.0'
    ) AS [result]

Answer 1

Hi @FERGUS ESSO KETCHA ASSAM Welcome to the Microsoft Q&A forum, Thanks for posting your question.

Can you try the field terminator mentioned below, you can also refer to the example provided here.

SELECT
    TOP 100 *
FROM
    OPENROWSET(
        BULK 'https://path...',
        FORMAT = 'CSV',
        HEADER_ROW = TRUE,
        PARSER_VERSION = '2.0',
        FIELDTERMINATOR = '\t'
    ) AS [result]

Regards Geetha