API documentation forbigquery.dbapi package.

API documentation forbigquery_v2.types package.

Client to bundle configuration needed for API requests.

Represents grant of an access role to an entity.

An entry must have exactly one of the allowedxref_EntityTypes. If anything butview,routine,ordataset are set, arole is also required.role is omitted forview,routine,dataset, because they are always read-only.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/datasets.

Datasets are containers for tables.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/datasets#resource-dataset

A read-only dataset resource from a list operation.

For performance reasons, the BigQuery API only includes some of thedataset properties when listing datasets. Notably,xref_access_entries is missing.

For a full list of the properties that the BigQuery API returns, see theREST documentation for datasets.list<https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/list>_.

DatasetReferences are pointers to datasets.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/datasets#datasetreference

Custom encryption configuration (e.g., Cloud KMS keys).

Options for a Bigtable column.

Options for a Bigtable column family.

Options that describe how to treat Bigtable tables as BigQuery tables.

Options that describe how to treat CSV files as BigQuery tables.

Description of an external data source.

The format for external data files.

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

Options that describe how to treat Google Sheets as BigQuery tables.

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.

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

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.

Model represents a machine learning model resource.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/models

ModelReferences are pointers to models.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/models#modelreference

Specifies determinism level for JavaScript user-defined functions (UDFs).

https://cloud.google.com/bigquery/docs/reference/rest/v2/routines#DeterminismLevel

Resource representing a user-defined routine.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/routines

Input/output argument of a function or a stored procedure.

See:https://cloud.google.com/bigquery/docs/reference/rest/v2/routines#argument

A pointer to a routine.

See:https://cloud.google.com/bigquery/docs/reference/rest/v2/routines#routinereference

The fine-grained type of the routine.

https://cloud.google.com/bigquery/docs/reference/rest/v2/routines#routinetype

.. versionadded:: 2.22.0

Define Policy Tags for a column.

Describe a single field within a table schema.

Definition of the ranges for range partitioning.

Range-based partitioning configuration for a table.

A BigQuery row.

Values can be accessed by position (index), by key like a dict,or as properties.

A class for iterating through HTTP/JSON API row list responses.

Information about base table and snapshot time of the snapshot.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#snapshotdefinition

Tables represent a set of rows whose values correspond to a schema.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#resource-table

A read-only table resource from a list operation.

For performance reasons, the BigQuery API only includes some of the tableproperties when listing tables. Notably,xref_schema andxref_num_rows are missing.

For a full list of the properties that the BigQuery API returns, see theREST documentation for tables.list<https://cloud.google.com/bigquery/docs/reference/rest/v2/tables/list>_.

TableReferences are pointers to tables.

Seehttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#tablereference

Configures time-based partitioning for a table.

Specifies the type of time partitioning to perform.

API documentation forbigquery.enums module.

API documentation forbigquery.format_options module.

Base classes and helpers for job classes.

BigQuery query processing.