OPENROWSET(FORMAT=’PARQUET’) syntax error in Azure SQL Database

admin

Documentation suggests that OPENROWSET should support retrieving data in Parquet files from Azure BLOB Storage in Azure SQL Database [1], but for me it is returning “[Code: 102, SQL State: S0001] Incorrect syntax near ‘FORMAT’.”

This is a new Azure SQL Database Serverless instance, with a database set to compatibility level 160.

Is SQL Database capable of reading formats other than CSV from BLOB Storage?

[1] learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver16

Read more here: Source link