Class ComputeOptions (1.29.0)

ComputeOptions(
    maximum_bytes_billed: typing.Optional[int] = None,
    enable_multi_query_execution: bool = False,
)

Encapsulates the configuration for compute options.

Examples:

>>> import bigframes.pandas as bpd
>>> df = bpd.read_gbq("bigquery-public-data.ml_datasets.penguins")

>>> bpd.options.compute.maximum_bytes_billed = 500
>>> # df.to_pandas() # this should fail
google.api_core.exceptions.InternalServerError: 500 Query exceeded limit for bytes billed: 500. 10485760 or higher required.

>>> bpd.options.compute.maximum_bytes_billed = None  # reset option

To add multiple extra labels to a query configuration, use the assign_extra_query_labels method with keyword arguments:

>>> bpd.options.compute.assign_extra_query_labels(test1=1, test2="abc")
>>> bpd.options.compute.extra_query_labels
{'test1': 1, 'test2': 'abc'}

Alternatively, you can add labels individually by directly accessing the extra_query_labels dictionary:

>>> bpd.options.compute.extra_query_labels["test3"] = False
>>> bpd.options.compute.extra_query_labels
{'test1': 1, 'test2': 'abc', 'test3': False}

To remove a label from the configuration, use the del keyword on the desired label key:

>>> del bpd.options.compute.extra_query_labels["test1"]
>>> bpd.options.compute.extra_query_labels
{'test2': 'abc', 'test3': False}

Attributes

Name Description
maximum_bytes_billed int, Options
Limits the bytes billed for query jobs. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default. See maximum_bytes_billed: https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.QueryJobConfig#google_cloud_bigquery_job_QueryJobConfig_maximum_bytes_billed.
enable_multi_query_execution bool, Options
If enabled, large queries may be factored into multiple smaller queries in order to avoid generating queries that are too complex for the query engine to handle. However this comes at the cost of increase cost and latency.
extra_query_labels Dict[str, Any], Options
Stores additional custom labels for query configuration.

Methods

assign_extra_query_labels

assign_extra_query_labels(**kwargs: typing.Any) -> None

Assigns additional custom labels for query configuration. The method updates the extra_query_labels dictionary with new labels provided through keyword arguments.

Parameter
Name Description
kwargs Any

Custom labels provided as keyword arguments. Each key-value pair in kwargs represents a label name and its value.

Exceptions
Type Description
ValueError If a key matches one of the reserved attribute names, specifically 'maximum_bytes_billed' or 'enable_multi_query_execution', to prevent conflicts with built-in settings.