Snowflake SQL Parser for Java and .NET

Snowflake SQL that GSP parses

COPY INTO mytable
FROM @my_int_stage
FILE_FORMAT = (TYPE = CSV);

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvsnowflake);
parser.sqltext = sql; // the Snowflake SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Parse it in C#

using gudusoft.gsqlparser;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvsnowflake);
parser.sqltext = sql; // the Snowflake SQL above
if (parser.parse() == 0)
{
    Console.WriteLine(parser.sqlstatements.size() + " statement(s) parsed");
}
else
{
    Console.WriteLine(parser.Errormessage);
}

Same grammar, .NET-idiomatic API — properties instead of Java getters. See the C# quick start or the .NET SQL Parser SDK.

What GSP handles in Snowflake

• COPY INTO (stages)
• Snowflake Scripting blocks
• Tasks, streams, and pipes
• Dynamic tables
• Semi-structured colon paths
• Procedural SQL: SQL stored procedures and standalone Snowflake Scripting blocks, including COPY INTO inside procedure bodies

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for Snowflake.

Recent Snowflake parser updates

• 2026-07-02 [Snowflake] Support GRANT OWNERSHIP COPY CURRENT GRANTS
• 2026-06-18 [Snowflake] Support SCOPED TEMPORARY table
• 2026-06-18 [Snowflake] Allow colon path access on constants

Full history in the release notes.