sql-formatter icon indicating copy to clipboard operation
sql-formatter copied to clipboard

Snowflake Unable to format SQL: Error: Parse error: Unexpected "@test;" at line 7 column 6

Open Bitros opened this issue 1 year ago • 2 comments

CREATE OR REPLACE STAGE test
  URL = 'azure://test.blob.core.windows.net/test/testfolder'
  STORAGE_INTEGRATION = DATALAKE_SI
  FILE_FORMAT = (TYPE = 'AVRO');

-- list stage
list @test;

Expected Output Prettier output

Actual Output Unable to format SQL: Error: Parse error: Unexpected "@test;" at line 7 column 6

Usage

  • How are you calling / using the library?
  • VS Code format
  • What SQL language(s) does this apply to?
  • Snowflake SQL
  • Which SQL Formatter version are you using?
  • Lastest Prettier SQL VSCode v1.6.0

Bitros avatar Apr 29 '24 06:04 Bitros