sql-formatter-org / sql-formatter-org/sql-formatter
Snowflake Unable to format SQL: Error: Parse error: Unexpected "@test;" at line 7 column 6
Open
Nobody has claimed this yet.
bug
snowflake
- Dominant language
- TypeScript
- Stars
- 2.9k
- Forks
- 456
- Avg merge
- 3d 4h
- Merged PRs (30d)
- 3
Description
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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the failure with the Snowflake SQL example in this issue, starting with the parser path used for Snowflake statements. The work is done when the sample formats successfully without the unexpected "@test;" parse error; add or update a regression test if the repository’s existing parser tests cover this syntax.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, typescript
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100