Share via

Incorrect syntax near OPENROWSET

Jayesh Dave 296 Reputation points
2023-08-31T21:34:52.21+00:00

Hello:

When I run the below query on Azure Synapse dedicated SQL pool, get this error "Parse error at line: 9, column: 6: Incorrect syntax near 'OPENROWSET'.".

SELECT TOP 10 *

FROM OPENROWSET(BULK 'folder1/folder2/folder3/*.parquet', FORMAT_TYPE = 'PARQUET', DATA_SOURCE = 'enrichedtest') AS r;

GO

Any help is greatly appreciated.

Thanks

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.
5,373 questions
Accepted answer
  1. Subashri Vasudevan 11,226 Reputation points
    2023-09-02T02:58:12.9933333+00:00

    You can either use a copy into command or use copy activity/data flow activity in synapse pipeline.

    Please check here for copy into command usage and syntax.

    And here for a video reference for the same.

    If you want to use copy activity in the pipeline, you can have a look at this video

    Thanks.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.