Beam ZetaSQL overview
Beam SQL supports a varient of the ZetaSQL language. ZetaSQL is similar to the language in BigQuery’s SQL framework. This Beam SQL dialect is especially useful in pipelines that write to or read from BigQuery tables.
Beam SQL has additional extensions leveraging Beam’s unified batch/streaming model and processing complex data types. You can use these extensions with all Beam SQL dialects, including Beam ZetaSQL.
A Beam SQL statement comprises a series of tokens. For more information about tokens in Beam ZetaSQL, see the Lexical structure reference.
Beam SQL supports standard SQL scalar data types as well as extensions including arrays, maps, and nested rows. For more information about scalar data in Beam ZetaSQL, see the Data types reference.
Functions and operators
The following table summarizes the ZetaSQL functions and operators supported by Beam ZetaSQL.