SQL dialect

AWS Athena SQL Parser for Java and .NET

General SQL Parser (GSP) parses AWS Athena with a dedicated, hand-tuned grammar — full AST access, offline syntax validation, formatting, rewriting, and column-level data lineage . One commercial SDK, 38 dialects, Java and .NET.

529
AWS Athena keywords recognized by the grammar
466
keywords the parser also accepts as identifiers
39
AWS Athena test SQL files in the regression corpus
Weekly
release cadence — dialect fixes ship in days

Example

AWS Athena SQL that GSP parses

CREATE EXTERNAL TABLE logs (id STRING, ts TIMESTAMP)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://my-bucket/logs/';

Parse it in Java

import gudusoft.gsqlparser.*;

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

The .NET edition exposes the same API in C# — see the C# quick start.

Coverage

What GSP handles in AWS Athena

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

Actively maintained

Recent AWS Athena parser updates

Full history in the release notes.

Go deeper

AWS Athena resources

Common questions

Do I need a AWS Athena database connection to validate SQL?

No. GSP validates AWS Athena syntax completely offline. You get error line and column positions, the offending token, and a hint — with no server, driver, or credentials involved.

How complete is the AWS Athena grammar?

GSP uses a dedicated hand-tuned grammar for AWS Athena — not a generic SQL grammar with flags. The parser recognizes 529 AWS Athena keywords and knows which 466 of them can also be used as identifiers, which is exactly the kind of edge case that breaks generic parsers.

Can I use the AWS Athena parser from C# / .NET?

Yes. The .NET edition (NuGet package gudusoft.gsqlparser, .NET Standard 2.0) exposes the same API surface as the Java edition, so every AWS Athena parsing feature on this page works in C# and VB.NET.

Can GSP extract column-level lineage from AWS Athena SQL?

Yes. The built-in DataFlowAnalyzer produces column-level lineage, impact analysis, and call graphs from AWS Athena scripts — it is the engine behind Gudu SQLFlow and the lineage integrations for DataHub and OpenMetadata.