Snowflake-Labs / schemachange

A Database Change Management tool for Snowflake
Apache License 2.0
502 stars 224 forks source link

Empty SQL Statement Error #258

Open GeorgeAtMOD opened 3 months ago

GeorgeAtMOD commented 3 months ago

Describe the bug When using Azure Dev Ops & schemachange, I get an error of "Empty SQL Statement".

To Reproduce Complete a pull request in Azure Dev Ops. CI CD pipeline kicks off as normal

Expected behavior I expect the version file to be executed.

Screenshots Snipped from version file: drop view if exists mart.dim_store; create or replace view mart.dim_store as . . . No trailing comments, no dropped semi-colons. It is a pretty straightforward file that will execute perfectly in either VSC or Snowflake's UI.

Schemachange (please complete the following information):

Additional context Add any other context about the problem here.