Blog Post

Azure Synapse Analytics Blog
6 MIN READ

Advanced analytics of COVID data using Synapse SQL endpoint in Azure Synapse Analytics service

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Jun 18, 2020
Azure Synapse Analytics is a big data analytics service that enables you to analyze data on Azure storage using SQL language. You can use SQL endpoints (provisioned and serverless) to analyze your da...
Updated Jun 30, 2020
Version 3.0
Synapse SQL
synapse studio
cbslc's avatar
cbslc
Copper Contributor
Mar 14, 2022

Are you doing anything special? I'm running your example above 

select top 10  *
from openrowset(bulk 'https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet',
                format='parquet') as a

In SSMS connected to my Azure synapse environment and I get  

Failed to execute query. Error: Parse error at line: 2, column: 6: Incorrect syntax near 'openrowset'.