The ZetaSQL Toolkit is a library that helps users use ZetaSQL Java API to perform SQL analysis for multiple query engines, including BigQuery and Cloud Spanner.
Return AnalyzedStatement objects from ZetaSQLToolkitAnalyzer.analyzerStatements()
AnalyzedStatement objects contain the parsed statement and, optionally, the resolved statement
Statements are only resolved when they are supported by the ZetaSQL Analyzer. Resolution will stop altogether for a script after finding any scripting constructs apart from variable declaration and assignments.
Resolve and variable declaration and assignments when performing analysis.
This will validate assignments to variables and properly define them in the Catalog
Support building testing catalogs using a JSON representation of catalog resources
See CatalogResources::fromJson
Add initial support for understanding column-level lineage produced by analyzed queries
Release version 0.4.0 of the ZetaSQL Toolkit
Changelog:
AnalyzedStatementobjects fromZetaSQLToolkitAnalyzer.analyzerStatements()AnalyzedStatementobjects contain the parsed statement and, optionally, the resolved statementCatalogResources::fromJsonBigQueryCatalog::addAllResourcesUsedInQueryzetasql-toolkit-corecontaining the core of the Toolkitzetasql-toolkit-bigquerycontaining all BigQuery-specific featureszetasql-toolkit-spannercontaining all Spanner-specific features