Stay organized with collections Save and categorize content based on your preferences.
BigQuery query processing.
Classes ArrayQueryParameterArrayQueryParameter(name, array_type, values)
Named / positional query parameters for array values.
Parameters Name Descriptionname
Optional[str]
Parameter name, used via @foo
syntax. If None, the parameter can only be addressed via position (?
).
array_type
Union[str, ScalarQueryParameterType, StructQueryParameterType]
The type of array elements. If given as a string, it must be one of 'STRING'
, 'INT64'
, 'FLOAT64'
, 'NUMERIC'
, 'BIGNUMERIC'
, 'BOOL'
, 'TIMESTAMP'
, 'DATE'
, or 'STRUCT'
/'RECORD'
. If the type is 'STRUCT'
/'RECORD'
and values
is empty, the exact item type cannot be deduced, thus a StructQueryParameterType
instance needs to be passed in.
values
List[appropriate type]
The parameter array values.
ArrayQueryParameterTypeArrayQueryParameterType(array_type, *, name=None, description=None)
Type representation for array query parameters.
Parameters Name Descriptionarray_type
Union[ScalarQueryParameterType, StructQueryParameterType]
The type of array elements.
name
Optional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
description
Optional[str]
The query parameter description. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
ConnectionProperty(key: str = "", value: str = "")
Parameters Name Description key
str
The key of the property to set, for example, 'time_zone'
or 'session_id'
.
value
str
The value of the property to set.
ScalarQueryParameterScalarQueryParameter(
name: typing.Optional[str],
type_: typing.Optional[
typing.Union[str, google.cloud.bigquery.query.ScalarQueryParameterType]
],
value: typing.Optional[
typing.Union[
str, int, float, decimal.Decimal, bool, datetime.datetime, datetime.date
]
],
)
Named / positional query parameters for scalar values.
Parameters Name Descriptionname
typing.Optional[str]
Parameter name, used via @foo
syntax. If None, the parameter can only be addressed via position (?
).
type_
typing.Union[str, google.cloud.bigquery.query.ScalarQueryParameterType, NoneType]
Name of parameter type. See SqlTypeNames and SqlParameterScalarTypes for supported types.
value
typing.Union[str, int, float, decimal.Decimal, bool, datetime.datetime, datetime.date, NoneType]
The scalar parameter value.
ScalarQueryParameterTypeScalarQueryParameterType(type_, *, name=None, description=None)
Type representation for scalar query parameters.
Parameters Name Descriptiontype_
str
One of 'STRING', 'INT64', 'FLOAT64', 'NUMERIC', 'BOOL', 'TIMESTAMP', 'DATETIME', or 'DATE'.
name
Optional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
description
Optional[str]
The query parameter description. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
SqlParameterScalarTypes()
Supported scalar SQL query parameter types as type objects.
StructQueryParameterStructQueryParameter(name, *sub_params)
Named / positional query parameters for struct values.
Parameter Name Descriptionname
Optional[str]
Parameter name, used via @foo
syntax. If None, the parameter can only be addressed via position (?
).
StructQueryParameterType(*fields, name=None, description=None)
Type representation for struct query parameters.
Parameters Name Descriptionfields
Iterable[Union[ ArrayQueryParameterType, ScalarQueryParameterType, StructQueryParameterType ]]
An non-empty iterable describing the struct's field types.
name
Optional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
description
Optional[str]
The query parameter description. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
UDFResource(udf_type, value)
Describe a single user-defined function (UDF) resource.
Parameters Name Descriptionudf_type
str
The type of the resource ('inlineCode' or 'resourceUri')
value
str See: https://cloud.google.com/bigquery/user-defined-functions#api
The inline code or resource URI.
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-08-07 UTC.
[[["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-07 UTC."],[],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4