A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://cloud.google.com/python/docs/reference/bigquery/3.11.4/google.cloud.bigquery.query below:

Module query (3.11.4) | Python client library

Skip to main content Module query (3.11.4)

Stay organized with collections Save and categorize content based on your preferences.

BigQuery query processing.

Classes ArrayQueryParameter
ArrayQueryParameter(name, array_type, values)

Named / positional query parameters for array values.

Parameters Name Description name 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.

ArrayQueryParameterType
ArrayQueryParameterType(array_type, *, name=None, description=None)

Type representation for array query parameters.

Parameters Name Description array_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
ConnectionProperty(key: str = "", value: str = "")
ScalarQueryParameter
ScalarQueryParameter(
    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.

ScalarQueryParameterType
ScalarQueryParameterType(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'.

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
SqlParameterScalarTypes()

Supported scalar SQL query parameter types as type objects.

StructQueryParameter
StructQueryParameter(name, *sub_params)

Named / positional query parameters for struct values.

Parameter Name Description name Optional[str]

Parameter name, used via @foo syntax. If None, the parameter can only be addressed via position (?).

StructQueryParameterType
StructQueryParameterType(*fields, name=None, description=None)

Type representation for struct query parameters.

Parameters Name Description fields 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
UDFResource(udf_type, value)

Describe a single user-defined function (UDF) resource.

Parameters Name Description udf_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