You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Incorrect syntax: 'CREATE VIEW' must be the only statement in the batch when using OPENROWSET(BULK ('table')) #30
Paste this SQL into a .sql file in Visual Studio Code with the extension added:
CREATE OR ALTER VIEW [myschema].[myview] ASSELECTmytable.myidFROM OPENROWSET(BULK ('/blob_storage_address/**'), DATA_SOURCE ='my_datasource', FORMAT ='PARQUET') AS mytable
;
GO
You will get something like the below:
This is valid SQL, using OPENROWSET(BULK()) for Synapse, as per this guide.
Activity
kburtram commentedon Oct 1, 2025
This appears to be an issue with the SQL Parser that is used for detecting syntax errors. I'll transfer to that repo for triage. Thanks!