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

[Bitros]

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

[nene]

Regarding Prettier SQL VSCode, please read the FAQ.

Regarding the @test syntax:

• Is this a syntax that Snowflake actually supports? Could you please point me to Snowflake documentation that describes this.
• Or is it some sort of templating syntax? Use the paramTypes config option.

[Bitros]

Hi, please see List syntax here https://docs.snowflake.com/en/sql-reference/sql/list#examples