Query Resource Classes

BigQuery query processing.

class google.cloud.bigquery.query.ArrayQueryParameter(name, array_type, values)

Named / positional query parameters for array values.

• Parameters

  • 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.

classmethod from_api_repr(resource: dict)

Factory: construct parameter from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.ArrayQueryParameter

classmethod positional(array_type: str, values: list)

Factory for positional parameters.

• Parameters

  • 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.

• Returns

  Instance without name

• Return type

  google.cloud.bigquery.query.ArrayQueryParameter

to_api_repr()

Construct JSON API representation for the parameter.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.ArrayQueryParameterType(array_type, *, name=None, description=None)

Type representation for array query parameters.

• Parameters

  • 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.

classmethod from_api_repr(resource)

Factory: construct parameter type from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.ArrayQueryParameterType

to_api_repr()

Construct JSON API representation for the parameter type.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.ConnectionProperty(key: str = '', value: str = '')

A connection-level property to customize query behavior.

See https://cloud.google.com/bigquery/docs/reference/rest/v2/ConnectionProperty

• Parameters

  • key – The key of the property to set, for example, 'time_zone' or 'session_id'.

  • value – The value of the property to set.

classmethod from_api_repr(resource)

Construct ConnectionProperty from JSON resource.

• Parameters

  resource – JSON representation.

• Returns

  A connection property.

property key(: [str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str )

Name of the property.

For example:

• time_zone

• session_id

to_api_repr()

Construct JSON API representation for the connection property.

• Returns

  JSON mapping

property value(: [str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str )

Value of the property.

class google.cloud.bigquery.query.RangeQueryParameter(range_element_type, start=None, end=None, name=None)

Named / positional query parameters for range values.

• Parameters

  • range_element_type (Union[str, **RangeQueryParameterType]) – The type of range elements. It must be one of ‘TIMESTAMP’, ‘DATE’, or ‘DATETIME’.

  • start (Optional[Union[ScalarQueryParameter, *[str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str)]*]) – The start of the range value. Must be the same type as range_element_type. If not provided, it’s interpreted as UNBOUNDED.

  • end (Optional[Union[ScalarQueryParameter, *[str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str)]*]) – The end of the range value. Must be the same type as range_element_type. If not provided, it’s interpreted as UNBOUNDED.

  • name (Optional[str]) – Parameter name, used via @foo syntax. If None, the parameter can only be addressed via position (?).

classmethod from_api_repr(resource: dict)

Factory: construct parameter from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.RangeQueryParameter

classmethod positional(range_element_type, start=None, end=None)

Factory for positional parameters.

• Parameters

  • range_element_type (Union[str, **RangeQueryParameterType]) – The type of range elements. It must be one of ‘TIMESTAMP’, ‘DATE’, or ‘DATETIME’.

  • start (Optional[Union[ScalarQueryParameter, *[str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str)]*]) – The start of the range value. Must be the same type as range_element_type. If not provided, it’s interpreted as UNBOUNDED.

  • end (Optional[Union[ScalarQueryParameter, *[str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str)]*]) – The end of the range value. Must be the same type as range_element_type. If not provided, it’s interpreted as UNBOUNDED.

• Returns

  Instance without name.

• Return type

  google.cloud.bigquery.query.RangeQueryParameter

to_api_repr()

Construct JSON API representation for the parameter.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.RangeQueryParameterType(type_, *, name=None, description=None)

Type representation for range query parameters.

• Parameters

  • type (Union[ScalarQueryParameterType, *[str](https://python.readthedocs.io/en/latest/library/stdtypes.html#str)]*) – Type of range element, must be one of ‘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.

classmethod from_api_repr(resource)

Factory: construct parameter type from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.RangeQueryParameterType

to_api_repr()

Construct JSON API representation for the parameter type.

• Returns

  JSON mapping

• Return type

  Dict

with_name(new_name: Optional[str])

Return a copy of the instance with name set to new_name.

• Parameters

  name (Union[str, **None]) – The new name of the range query parameter type. If None, the existing name is cleared.

• Returns

  A new instance with updated name.

• Return type

  google.cloud.bigquery.query.RangeQueryParameterType

class google.cloud.bigquery.query.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.

• Parameters

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

  • type – Name of parameter type. See google.cloud.bigquery.enums.SqlTypeNames and google.cloud.bigquery.query.SqlParameterScalarTypes for supported types.

  • value – The scalar parameter value.

classmethod from_api_repr(resource: dict)

Factory: construct parameter from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.ScalarQueryParameter

classmethod positional(type_: Union[str, google.cloud.bigquery.query.ScalarQueryParameterType], value: Optional[Union[str, int, float, decimal.Decimal, bool, datetime.datetime, datetime.date]])

Factory for positional paramater.

• Parameters

  • type – Name of parameter type. One of ‘STRING’, ‘INT64’, ‘FLOAT64’, ‘NUMERIC’, ‘BIGNUMERIC’, ‘BOOL’, ‘TIMESTAMP’, ‘DATETIME’, or ‘DATE’.

  • value – The scalar parameter value.

• Returns

  Instance without name

• Return type

  google.cloud.bigquery.query.ScalarQueryParameter

to_api_repr()

Construct JSON API representation for the parameter.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.ScalarQueryParameterType(type_, *, name=None, description=None)

Type representation for scalar query parameters.

• Parameters

  • 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.

classmethod from_api_repr(resource)

Factory: construct parameter type from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.ScalarQueryParameterType

to_api_repr()

Construct JSON API representation for the parameter type.

• Returns

  JSON mapping

• Return type

  Dict

with_name(new_name: Optional[str])

Return a copy of the instance with name set to new_name.

• Parameters

  name (Union[str, **None]) – The new name of the query parameter type. If None, the existing name is cleared.

• Returns

  A new instance with updated name.

• Return type

  google.cloud.bigquery.query.ScalarQueryParameterType

class google.cloud.bigquery.query.SqlParameterScalarTypes()

Supported scalar SQL query parameter types as type objects.

class google.cloud.bigquery.query.StructQueryParameter(name, *sub_params)

Named / positional query parameters for struct values.

• Parameters

  • name (Optional[str]) – Parameter name, used via @foo syntax. If None, the parameter can only be addressed via position (?).

  • (Union[Tuple[ (sub_params) – google.cloud.bigquery.query.ScalarQueryParameter, google.cloud.bigquery.query.ArrayQueryParameter, google.cloud.bigquery.query.StructQueryParameter

  • ]]) – The sub-parameters for the struct

classmethod from_api_repr(resource: dict)

Factory: construct parameter from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.StructQueryParameter

classmethod positional(*sub_params)

Factory for positional parameters.

• Parameters

  • (Union[Tuple[ (sub_params) – google.cloud.bigquery.query.ScalarQueryParameter, google.cloud.bigquery.query.ArrayQueryParameter, google.cloud.bigquery.query.StructQueryParameter

  • ]]) – The sub-parameters for the struct

• Returns

  Instance without name

• Return type

  google.cloud.bigquery.query.StructQueryParameter

to_api_repr()

Construct JSON API representation for the parameter.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.StructQueryParameterType(*fields, name=None, description=None)

Type representation for struct query parameters.

• Parameters

  • 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.

classmethod from_api_repr(resource)

Factory: construct parameter type from JSON resource.

• Parameters

  resource (Dict) – JSON mapping of parameter

• Returns

  Instance

• Return type

  google.cloud.bigquery.query.StructQueryParameterType

to_api_repr()

Construct JSON API representation for the parameter type.

• Returns

  JSON mapping

• Return type

  Dict

class google.cloud.bigquery.query.UDFResource(udf_type, value)

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

• Parameters

  • udf_type (str) – The type of the resource (‘inlineCode’ or ‘resourceUri’)

  • value (str) – The inline code or resource URI.

See: https://cloud.google.com/bigquery/user-defined-functions#api