The compression type to use for exported files. The default value isNONE.

DEFLATE andSNAPPY areonly supported for Avro.

Asynchronous job: copy data into a table from other tables.

Configuration options for copy jobs.

All properties in this class are optional. Values which are :data:None ->server defaults. Set properties on the constructed configuration by usingthe property name as the name of a keyword argument.

Specifies whether the job is allowed to create new tables. The defaultvalue isCREATE_IF_NEEDED.

Creation, truncation and append actions occur as one atomic updateupon job completion.

The exported file format. The default value isCSV.

Tables with nested or repeated fields cannot be exported as CSV.

Detailed statistics for DML statements.

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

The character encoding of the data. The default isUTF_8.

BigQuery decodes the data after the raw, binary data has beensplit using the values of the quote and fieldDelimiter properties.

Asynchronous job: extract data from a table into Cloud Storage.

Configuration options for extract jobs.

All properties in this class are optional. Values which are :data:None ->server defaults. Set properties on the constructed configuration by usingthe property name as the name of a keyword argument.

Asynchronous job for loading data into a table.

Can load from Google Cloud Storage URIs or from a file.

Configuration options for load jobs.

Set properties on the constructed configuration by using the property nameas the name of a keyword argument. Values which are unset or :data:Noneuse the BigQuery REST API default values. See theBigQuery REST APIreference documentation<https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad>_for a list of default values.

Required options differ based on thesource_format value.For example, the BigQuery API's default value forsource_format is"CSV".When loading a CSV file, eitherschema must be set orautodetect must be set to:data:True.

Different operation types supported in table copy job.

https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#operationtype

Asynchronous job: query tables.

Configuration options for query jobs.

All properties in this class are optional. Values which are :data:None ->server defaults. Set properties on the constructed configuration by usingthe property name as the name of a keyword argument.

QueryPlanEntry represents a single stage of a query execution plan.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ExplainQueryStagefor the underlying API representation within query statistics.

Map a single step in a query plan entry.

Specifies a priority for the query. The default value isINTERACTIVE.

Job resource usage for a reservation.

Specifies an update to the destination table schema as a side effect ofa load job.

Options controlling the execution of scripts.

https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ScriptOptions

Stack frame showing the line/column/procedure name where the currentevaluation happened.

Statistics for a child job of a script.

The format of the data files. The default value isCSV.

Note that the set of allowed values for loading data is differentthan the set used for external data sources (seeExternalSourceFormat).

TimelineEntry represents progress of a query job at a particularpoint in time.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/Job#querytimelinesamplefor the underlying API representation within query statistics.

[Alpha] Information of a multi-statement transaction.

https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#TransactionInfo

.. versionadded:: 2.24.0

A job whose type cannot be determined.

Specifies the action that occurs if destination table already exists.

The default value isWRITE_APPEND.

Each action is atomic and only occurs if BigQuery is able to completethe job successfully. Creation, truncation and append actions occur as oneatomic update upon job completion.