• Parameters

  • name (Optional[str]) – Parameter name, used via@foo syntax. If None, theparameter 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' andvalues is empty,the exact item type cannot be deduced, thus aStructQueryParameterTypeinstance 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' andvalues is empty,the exact item type cannot be deduced, thus aStructQueryParameterTypeinstance 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 isone of the subfields inStructQueryParameterType instance.

  • description (Optional[str]) – The query parameter description. Primarily used if the type isone of the subfields inStructQueryParameterType 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.

Seehttps://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)

ConstructConnectionPropertyfrom JSON resource.

• Parameters

  resource – JSON representation.

• Returns

  A connection property.

property key(: [str](https://docs.python.org/3/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://docs.python.org/3/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://docs.python.org/3/library/stdtypes.html#str)]*]) – The start of the range value. Must be the same type asrange_element_type. If not provided, it’s interpreted as UNBOUNDED.

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

  • name (Optional[str]) – Parameter name, used via@foo syntax. If None, theparameter 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://docs.python.org/3/library/stdtypes.html#str)]*]) – The start of the range value. Must be the same type asrange_element_type. If not provided, it’s interpreted asUNBOUNDED.

  • end (Optional[Union[ScalarQueryParameter, *[str](https://docs.python.org/3/library/stdtypes.html#str)]*]) – The end of the range value. Must be the same type asrange_element_type. If not provided, it’s interpreted asUNBOUNDED.

• 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://docs.python.org/3/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 isone of the subfields inStructQueryParameterType instance.

  • description (Optional[str]) – The query parameter description. Primarily used if the type isone of the subfields inStructQueryParameterType 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 withname set tonew_name.

• Parameters

  name (Union[str, **None]) – The new name of the range query parameter type. IfNone, 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, theparameter can only be addressed via position (?).

  • type – Name of parameter type. Seegoogle.cloud.bigquery.enums.SqlTypeNames andgoogle.cloud.bigquery.query.SqlParameterScalarTypes forsupported 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 isone of the subfields inStructQueryParameterType instance.

  • description (Optional[str]) – The query parameter description. Primarily used if the type isone of the subfields inStructQueryParameterType 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 withname set tonew_name.

• Parameters

  name (Union[str, **None]) – The new name of the query parameter type. IfNone, 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)

Name / positional query parameters for struct values.

• Parameters

  • name (Optional[str]) – Parameter name, used via@foo syntax. If None, theparameter 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 isone of the subfields inStructQueryParameterType instance.

  • description (Optional[str]) – The query parameter description. Primarily used if the type isone of the subfields inStructQueryParameterType 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