My SQL row headers shows in one column in synapse

FERGUS ESSO KETCHA ASSAM 115 Reputation points Student Ambassador
2023-02-24T16:01:45.2166667+00:00

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]
Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,471 questions
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,972 Reputation points Microsoft Employee
    2023-03-06T16:22:30.8933333+00:00

    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


0 additional answers

Sort by: Most helpful