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 Description nameOptional[str]
Parameter name, used via @foo
syntax. If None, the parameter can only be addressed via position (?
).
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.
List[appropriate type]
The parameter array values.
ArrayQueryParameterTypeArrayQueryParameterType(array_type, *, name=None, description=None)
Type representation for array query parameters.
Parameters Name Description array_typeUnion[ScalarQueryParameterType, StructQueryParameterType]
The type of array elements.
nameOptional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
Optional[str]
The query parameter description. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
ConnectionProperty(key: str = "", value: str = "")
ScalarQueryParameter
ScalarQueryParameter(
name: Optional[str],
type_: Optional[Union[str, google.cloud.bigquery.query.ScalarQueryParameterType]],
value: Optional[
Union[str, int, float, decimal.Decimal, bool, datetime.datetime, datetime.date]
],
)
Named / positional query parameters for scalar values.
ScalarQueryParameterTypeScalarQueryParameterType(type_, *, name=None, description=None)
Type representation for scalar query parameters.
Parameters Name Description type_str
One of 'STRING', 'INT64', 'FLOAT64', 'NUMERIC', 'BOOL', 'TIMESTAMP', 'DATETIME', or 'DATE'.
nameOptional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
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 Description nameOptional[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 Description fieldsIterable[Union[ ArrayQueryParameterType, ScalarQueryParameterType, StructQueryParameterType ]]
An non-empty iterable describing the struct's field types.
nameOptional[str]
The name of the query parameter. Primarily used if the type is one of the subfields in StructQueryParameterType
instance.
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 Description udf_typestr
The type of the resource ('inlineCode' or 'resourceUri')
valuestr 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