Hi, 5 years after,
using Azure SQL Database (servless),
I try to use this troubleshooting guide,
And even if Openrowset is now supported for parquet files on Blob storage,
https://learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16.
I think I face a compatibility issue (db is on 160)
I have created everything (credential, external datasource),
I am using a SAS token, that works ok on azure cli
but on the basic:
```select top 10 *
from OPENROWSET(
bulk 'members.parquet',
format = 'PARQUET',
data_source = 'angebi_parquets'
) AS [result]; ```
I have an error: Incorrect syntax near 'FORMAT'." (whatever the client used)
Other had (or still have ?) the same issue https://learn.microsoft.com/en-us/answers/questions/2069679/openrowset(format-parquet)-syntax-error-in-azure-s
but this should be now fully supported...
Any idea ?