Send feedback
Module standard_sql (3.36.0) Stay organized with collections
Save and categorize content based on your preferences.
Version latest keyboard_arrow_down
API documentation for bigquery.standard_sql
module.
Classes
StandardSqlDataType
(
type_kind
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
enums
.
StandardSqlTypeNames
]
=
StandardSqlTypeNames
.
TYPE_KIND_UNSPECIFIED
,
array_element_type
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlDataType
]
=
None
,
struct_type
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlStructType
]
=
None
,
range_element_type
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlDataType
]
=
None
,
)
The type of a variable, e.g., a function argument.
See: https://cloud.google.com/bigquery/docs/reference/rest/v2/StandardSqlDataType
Examples:
INT64: {type_kind="INT64"}
ARRAY: {type_kind="ARRAY", array_element_type="STRING"}
STRUCT<x STRING, y ARRAY>: {
type_kind="STRUCT",
struct_type={
fields=[
{name="x", type={type_kind="STRING"}},
{
name="y",
type={type_kind="ARRAY", array_element_type="DATE"}
}
]
}
}
RANGE: {type_kind="RANGE", range_element_type="DATETIME"}
array_element_type
typing.Optional[StandardSqlDataType]
The type of the array's elements, if type_kind is ARRAY.
struct_type
typing.Optional[StandardSqlStructType]
The fields of this struct, in order, if type_kind is STRUCT.
range_element_type
typing.Optional[StandardSqlDataType]
The type of the range's elements, if type_kind is RANGE.
StandardSqlField
(
name
:
typing
.
Optional
[
str
]
=
None
,
type
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlDataType
]
=
None
,
)
name
typing.Optional[str]
The name of this field. Can be absent for struct fields.
type
typing.Optional[ google.cloud.bigquery.standard_sql.StandardSqlDataType
] The type of this parameter. Absent if not explicitly specified. For example, CREATE FUNCTION statement can omit the return type; in this case the output parameter does not have this "type" field).
StandardSqlStructType
(
fields
:
typing
.
Optional
[
typing
.
Iterable
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlField
]
]
=
None
,
)
StandardSqlTableType
(
columns
:
typing
.
Iterable
[
google
.
cloud
.
bigquery
.
standard_sql
.
StandardSqlField
],
)
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License
, and code samples are licensed under the Apache 2.0 License
. For details, see the Google Developers Site Policies
. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-09-04 UTC.
Need to tell us more?
[[["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-09-04 UTC."],[],[],null,["# Module standard_sql (3.36.0)\n\nVersion latestkeyboard_arrow_down\n\n- [3.36.0 (latest)](/python/docs/reference/bigquery/latest/google.cloud.bigquery.standard_sql)\n- [3.35.1](/python/docs/reference/bigquery/3.35.1/google.cloud.bigquery.standard_sql)\n- [3.34.0](/python/docs/reference/bigquery/3.34.0/google.cloud.bigquery.standard_sql)\n- [3.33.0](/python/docs/reference/bigquery/3.33.0/google.cloud.bigquery.standard_sql)\n- [3.31.0](/python/docs/reference/bigquery/3.31.0/google.cloud.bigquery.standard_sql)\n- [3.30.0](/python/docs/reference/bigquery/3.30.0/google.cloud.bigquery.standard_sql)\n- [3.29.0](/python/docs/reference/bigquery/3.29.0/google.cloud.bigquery.standard_sql)\n- [3.27.0](/python/docs/reference/bigquery/3.27.0/google.cloud.bigquery.standard_sql)\n- [3.26.0](/python/docs/reference/bigquery/3.26.0/google.cloud.bigquery.standard_sql)\n- [3.25.0](/python/docs/reference/bigquery/3.25.0/google.cloud.bigquery.standard_sql)\n- [3.24.0](/python/docs/reference/bigquery/3.24.0/google.cloud.bigquery.standard_sql)\n- [3.23.1](/python/docs/reference/bigquery/3.23.1/google.cloud.bigquery.standard_sql)\n- [3.22.0](/python/docs/reference/bigquery/3.22.0/google.cloud.bigquery.standard_sql)\n- [3.21.0](/python/docs/reference/bigquery/3.21.0/google.cloud.bigquery.standard_sql)\n- [3.20.1](/python/docs/reference/bigquery/3.20.1/google.cloud.bigquery.standard_sql)\n- [3.19.0](/python/docs/reference/bigquery/3.19.0/google.cloud.bigquery.standard_sql)\n- [3.18.0](/python/docs/reference/bigquery/3.18.0/google.cloud.bigquery.standard_sql)\n- [3.17.2](/python/docs/reference/bigquery/3.17.2/google.cloud.bigquery.standard_sql)\n- [3.16.0](/python/docs/reference/bigquery/3.16.0/google.cloud.bigquery.standard_sql)\n- [3.15.0](/python/docs/reference/bigquery/3.15.0/google.cloud.bigquery.standard_sql)\n- [3.14.1](/python/docs/reference/bigquery/3.14.1/google.cloud.bigquery.standard_sql)\n- [3.13.0](/python/docs/reference/bigquery/3.13.0/google.cloud.bigquery.standard_sql)\n- [3.12.0](/python/docs/reference/bigquery/3.12.0/google.cloud.bigquery.standard_sql)\n- [3.11.4](/python/docs/reference/bigquery/3.11.4/google.cloud.bigquery.standard_sql)\n- [3.4.0](/python/docs/reference/bigquery/3.4.0/google.cloud.bigquery.standard_sql)\n- [3.3.6](/python/docs/reference/bigquery/3.3.6/google.cloud.bigquery.standard_sql)\n- [3.2.0](/python/docs/reference/bigquery/3.2.0/google.cloud.bigquery.standard_sql)\n- [3.1.0](/python/docs/reference/bigquery/3.1.0/google.cloud.bigquery.standard_sql)\n- [3.0.1](/python/docs/reference/bigquery/3.0.1/google.cloud.bigquery.standard_sql)\n- [2.34.4](/python/docs/reference/bigquery/2.34.4/google.cloud.bigquery.standard_sql)\n- [2.33.0](/python/docs/reference/bigquery/2.33.0/google.cloud.bigquery.standard_sql)\n- [2.32.0](/python/docs/reference/bigquery/2.32.0/google.cloud.bigquery.standard_sql)\n- [2.31.0](/python/docs/reference/bigquery/2.31.0/google.cloud.bigquery.standard_sql)\n- [2.30.1](/python/docs/reference/bigquery/2.30.1/google.cloud.bigquery.standard_sql)\n- [2.29.0](/python/docs/reference/bigquery/2.29.0/google.cloud.bigquery.standard_sql)\n- [2.28.1](/python/docs/reference/bigquery/2.28.1/google.cloud.bigquery.standard_sql)\n- [2.27.1](/python/docs/reference/bigquery/2.27.1/google.cloud.bigquery.standard_sql)\n- [2.26.0](/python/docs/reference/bigquery/2.26.0/google.cloud.bigquery.standard_sql)\n- [2.25.2](/python/docs/reference/bigquery/2.25.2/google.cloud.bigquery.standard_sql)\n- [2.24.1](/python/docs/reference/bigquery/2.24.1/google.cloud.bigquery.standard_sql)\n- [2.23.3](/python/docs/reference/bigquery/2.23.3/google.cloud.bigquery.standard_sql)\n- [2.22.1](/python/docs/reference/bigquery/2.22.1/google.cloud.bigquery.standard_sql)\n- [2.21.0](/python/docs/reference/bigquery/2.21.0/google.cloud.bigquery.standard_sql)\n- [2.20.0](/python/docs/reference/bigquery/2.20.0/google.cloud.bigquery.standard_sql)\n- [2.19.0](/python/docs/reference/bigquery/2.19.0/google.cloud.bigquery.standard_sql)\n- [2.18.0](/python/docs/reference/bigquery/2.18.0/google.cloud.bigquery.standard_sql)\n- [2.17.0](/python/docs/reference/bigquery/2.17.0/google.cloud.bigquery.standard_sql)\n- [2.16.1](/python/docs/reference/bigquery/2.16.1/google.cloud.bigquery.standard_sql)\n- [2.15.0](/python/docs/reference/bigquery/2.15.0/google.cloud.bigquery.standard_sql)\n- [2.14.0](/python/docs/reference/bigquery/2.14.0/google.cloud.bigquery.standard_sql)\n- [2.13.1](/python/docs/reference/bigquery/2.13.1/google.cloud.bigquery.standard_sql)\n- [2.12.0](/python/docs/reference/bigquery/2.12.0/google.cloud.bigquery.standard_sql)\n- [2.11.0](/python/docs/reference/bigquery/2.11.0/google.cloud.bigquery.standard_sql)\n- [2.10.0](/python/docs/reference/bigquery/2.10.0/google.cloud.bigquery.standard_sql)\n- [2.9.0](/python/docs/reference/bigquery/2.9.0/google.cloud.bigquery.standard_sql)\n- [2.8.0](/python/docs/reference/bigquery/2.8.0/google.cloud.bigquery.standard_sql)\n- [2.7.0](/python/docs/reference/bigquery/2.7.0/google.cloud.bigquery.standard_sql)\n- [2.6.2](/python/docs/reference/bigquery/2.6.2/google.cloud.bigquery.standard_sql)\n- [2.5.0](/python/docs/reference/bigquery/2.5.0/google.cloud.bigquery.standard_sql)\n- [2.4.0](/python/docs/reference/bigquery/2.4.0/google.cloud.bigquery.standard_sql)\n- [2.3.1](/python/docs/reference/bigquery/2.3.1/google.cloud.bigquery.standard_sql)\n- [2.2.0](/python/docs/reference/bigquery/2.2.0/google.cloud.bigquery.standard_sql)\n- [2.1.0](/python/docs/reference/bigquery/2.1.0/google.cloud.bigquery.standard_sql)\n- [2.0.0](/python/docs/reference/bigquery/2.0.0/google.cloud.bigquery.standard_sql)\n- [1.28.2](/python/docs/reference/bigquery/1.28.2/google.cloud.bigquery.standard_sql)\n- [1.27.2](/python/docs/reference/bigquery/1.27.2/google.cloud.bigquery.standard_sql)\n- [1.26.1](/python/docs/reference/bigquery/1.26.1/google.cloud.bigquery.standard_sql)\n- [1.25.0](/python/docs/reference/bigquery/1.25.0/google.cloud.bigquery.standard_sql)\n- [1.24.0](/python/docs/reference/bigquery/1.24.0/google.cloud.bigquery.standard_sql)\n- [1.23.1](/python/docs/reference/bigquery/1.23.1/google.cloud.bigquery.standard_sql)\n- [1.22.0](/python/docs/reference/bigquery/1.22.0/google.cloud.bigquery.standard_sql)\n- [1.21.0](/python/docs/reference/bigquery/1.21.0/google.cloud.bigquery.standard_sql)\n- [1.20.0](/python/docs/reference/bigquery/1.20.0/google.cloud.bigquery.standard_sql)\n- [1.19.0](/python/docs/reference/bigquery/1.19.0/google.cloud.bigquery.standard_sql)\n- [1.18.0](/python/docs/reference/bigquery/1.18.0/google.cloud.bigquery.standard_sql)\n- [1.17.0](/python/docs/reference/bigquery/1.17.0/google.cloud.bigquery.standard_sql)\n- [1.16.0](/python/docs/reference/bigquery/1.16.0/google.cloud.bigquery.standard_sql) \nAPI documentation for `bigquery.standard_sql` module.\n\nClasses\n-------\n\n### [StandardSqlDataType](/python/docs/reference/bigquery/latest/google.cloud.bigquery.standard_sql.StandardSqlDataType)\n\n StandardSqlDataType(\n type_kind: typing.Optional[\n google.cloud.bigquery.enums.StandardSqlTypeNames\n ] = StandardSqlTypeNames.TYPE_KIND_UNSPECIFIED,\n array_element_type: typing.Optional[\n google.cloud.bigquery.standard_sql.StandardSqlDataType\n ] = None,\n struct_type: typing.Optional[\n google.cloud.bigquery.standard_sql.StandardSqlStructType\n ] = None,\n range_element_type: typing.Optional[\n google.cloud.bigquery.standard_sql.StandardSqlDataType\n ] = None,\n )\n\nThe type of a variable, e.g., a function argument.\n\nSee:\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/StandardSqlDataType\u003e\n\nExamples: \n\n INT64: {type_kind=\"INT64\"}\n ARRAY: {type_kind=\"ARRAY\", array_element_type=\"STRING\"}\n STRUCT\u003cx STRING, y ARRAY\u003e: {\n type_kind=\"STRUCT\",\n struct_type={\n fields=[\n {name=\"x\", type={type_kind=\"STRING\"}},\n {\n name=\"y\",\n type={type_kind=\"ARRAY\", array_element_type=\"DATE\"}\n }\n ]\n }\n }\n RANGE: {type_kind=\"RANGE\", range_element_type=\"DATETIME\"}\n\n### [StandardSqlField](/python/docs/reference/bigquery/latest/google.cloud.bigquery.standard_sql.StandardSqlField)\n\n StandardSqlField(\n name: typing.Optional[str] = None,\n type: typing.Optional[\n google.cloud.bigquery.standard_sql.StandardSqlDataType\n ] = None,\n )\n\nA field or a column.\n\nSee:\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/StandardSqlField\u003e\n\n### [StandardSqlStructType](/python/docs/reference/bigquery/latest/google.cloud.bigquery.standard_sql.StandardSqlStructType)\n\n StandardSqlStructType(\n fields: typing.Optional[\n typing.Iterable[google.cloud.bigquery.standard_sql.StandardSqlField]\n ] = None,\n )\n\nType of a struct field.\n\nSee:\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/StandardSqlDataType#StandardSqlStructType\u003e\n\n### [StandardSqlTableType](/python/docs/reference/bigquery/latest/google.cloud.bigquery.standard_sql.StandardSqlTableType)\n\n StandardSqlTableType(\n columns: typing.Iterable[google.cloud.bigquery.standard_sql.StandardSqlField],\n )\n\nA table type.\n\nSee:\n\u003chttps://cloud.google.com/workflows/docs/reference/googleapis/bigquery/v2/Overview#StandardSqlTableType\u003e"]]
