[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-26 UTC."],[[["\u003cp\u003eDataflow SQL uses a version of the ZetaSQL query syntax for its operations.\u003c/p\u003e\n"],["\u003cp\u003eIt also incorporates specific streaming extensions designed for running Dataflow streaming tasks.\u003c/p\u003e\n"],["\u003cp\u003eThe language supports various data types, detailed query syntax, and specific function call rules.\u003c/p\u003e\n"],["\u003cp\u003eDataflow SQL has a wide range of built-in functionalities including aggregate, mathematical, string, and timestamp functions.\u003c/p\u003e\n"],["\u003cp\u003eThe syntax is built around a structured lexical format that needs to be taken into consideration.\u003c/p\u003e\n"]]],[],null,["# Overview: Dataflow SQL reference\n\nDataflow SQL supports a variant of the [ZetaSQL](https://github.com/google/zetasql)\nquery syntax and includes additional [streaming extensions](/dataflow/docs/reference/sql/streaming-extensions)\nfor running Dataflow streaming jobs.\n\n- [Data types](/dataflow/docs/reference/sql/data-types)\n- [Query syntax](/dataflow/docs/reference/sql/query-syntax)\n- [Cloud Dataflow SQL streaming extensions](/dataflow/docs/reference/sql/streaming-extensions)\n- Functions \\& operators\n - [Function call rules](/dataflow/docs/reference/sql/syntax)\n - [Conversion rules](/dataflow/docs/reference/sql/conversion_rules)\n - [Aggregate functions](/dataflow/docs/reference/sql/aggregate_functions)\n - [Mathematical functions](/dataflow/docs/reference/sql/mathematical_functions)\n - [String functions](/dataflow/docs/reference/sql/string_functions)\n - [Timestamp functions](/dataflow/docs/reference/sql/timestamp_functions)\n - [Operators](/dataflow/docs/reference/sql/operators)\n - [Conditional expressions](/dataflow/docs/reference/sql/conditional_expressions)\n- [Lexical structure](/dataflow/docs/reference/sql/lexical)"]]