- 3.25.0 (latest)
- 3.24.0
- 3.23.1
- 3.22.0
- 3.21.0
- 3.20.1
- 3.19.0
- 3.18.0
- 3.17.2
- 3.16.0
- 3.15.0
- 3.14.1
- 3.13.0
- 3.12.0
- 3.11.4
- 3.4.0
- 3.3.6
- 3.2.0
- 3.1.0
- 3.0.1
- 2.34.4
- 2.33.0
- 2.32.0
- 2.31.0
- 2.30.1
- 2.29.0
- 2.28.1
- 2.27.1
- 2.26.0
- 2.25.2
- 2.24.1
- 2.23.3
- 2.22.1
- 2.21.0
- 2.20.0
- 2.19.0
- 2.18.0
- 2.17.0
- 2.16.1
- 2.15.0
- 2.14.0
- 2.13.1
- 2.12.0
- 2.11.0
- 2.10.0
- 2.9.0
- 2.8.0
- 2.7.0
- 2.6.2
- 2.5.0
- 2.4.0
- 2.3.1
- 2.2.0
- 2.1.0
- 2.0.0
- 1.28.2
- 1.27.2
- 1.26.1
- 1.25.0
- 1.24.0
- 1.23.1
- 1.22.0
- 1.21.0
- 1.20.0
- 1.19.0
- 1.18.0
- 1.17.0
- 1.16.0
BigQuery Enums
class google.cloud.bigquery.enums.AutoRowIDs(value)
How to handle automatic insert IDs when inserting rows as a stream.
DISABLED( = )
GENERATE_UUID( = )
class google.cloud.bigquery.enums.Compression(value)
The compression type to use for exported files. The default value is
NONE
.
DEFLATE
and SNAPPY
are
only supported for Avro.
DEFLATE( = 'DEFLATE )
Specifies DEFLATE format.
GZIP( = 'GZIP )
Specifies GZIP format.
NONE( = 'NONE )
Specifies no compression.
SNAPPY( = 'SNAPPY )
Specifies SNAPPY format.
ZSTD( = 'ZSTD )
Specifies ZSTD format.
class google.cloud.bigquery.enums.CreateDisposition()
Specifies whether the job is allowed to create new tables. The default
value is CREATE_IF_NEEDED
.
Creation, truncation and append actions occur as one atomic update upon job completion.
CREATE_IF_NEEDED( = 'CREATE_IF_NEEDED )
If the table does not exist, BigQuery creates the table.
CREATE_NEVER( = 'CREATE_NEVER )
The table must already exist. If it does not, a ‘notFound’ error is returned in the job result.
class google.cloud.bigquery.enums.DecimalTargetType()
The data types that could be used as a target type when converting decimal values.
Versionadded: New in version 2.21.0.
BIGNUMERIC( = 'BIGNUMERIC )
Decimal values could be converted to BIGNUMERIC type.
NUMERIC( = 'NUMERIC )
Decimal values could be converted to NUMERIC type.
STRING( = 'STRING )
Decimal values could be converted to STRING type.
class google.cloud.bigquery.enums.DefaultPandasDTypes(value)
Default Pandas DataFrem DTypes to convert BigQuery data. These Sentinel values are used instead of None to maintain backward compatibility, and allow Pandas package is not available. For more information: https://stackoverflow.com/a/60605919/101923
BOOL_DTYPE( = <object object )
Specifies default bool dtype
DATE_DTYPE( = <object object )
Specifies default date dtype
INT_DTYPE( = <object object )
Specifies default integer dtype
RANGE_DATETIME_DTYPE( = <object object )
Specifies default range datetime dtype
RANGE_DATE_DTYPE( = <object object )
Specifies default range date dtype
RANGE_TIMESTAMP_DTYPE( = <object object )
Specifies default range timestamp dtype
TIME_DTYPE( = <object object )
Specifies default time dtype
class google.cloud.bigquery.enums.DestinationFormat()
The exported file format. The default value is CSV
.
Tables with nested or repeated fields cannot be exported as CSV.
AVRO( = 'AVRO )
Specifies Avro format.
CSV( = 'CSV )
Specifies CSV format.
NEWLINE_DELIMITED_JSON( = 'NEWLINE_DELIMITED_JSON )
Specifies newline delimited JSON format.
PARQUET( = 'PARQUET )
Specifies Parquet format.
class google.cloud.bigquery.enums.DeterminismLevel()
Specifies determinism level for JavaScript user-defined functions (UDFs).
DETERMINISM_LEVEL_UNSPECIFIED( = 'DETERMINISM_LEVEL_UNSPECIFIED )
The determinism of the UDF is unspecified.
DETERMINISTIC( = 'DETERMINISTIC )
The UDF is deterministic, meaning that 2 function calls with the same inputs always produce the same result, even across 2 query runs.
NOT_DETERMINISTIC( = 'NOT_DETERMINISTIC )
The UDF is not deterministic.
class google.cloud.bigquery.enums.Encoding()
The character encoding of the data. The default is UTF_8
.
BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
ISO_8859_1( = 'ISO-8859-1 )
Specifies ISO-8859-1 encoding.
UTF_8( = 'UTF-8 )
Specifies UTF-8 encoding.
class google.cloud.bigquery.enums.EntityTypes(value)
Enum of allowed entity type names in AccessEntry
DATASET( = 'dataset )
DOMAIN( = 'domain )
GROUP_BY_EMAIL( = 'groupByEmail )
IAM_MEMBER( = 'iamMember )
ROUTINE( = 'routine )
SPECIAL_GROUP( = 'specialGroup )
USER_BY_EMAIL( = 'userByEmail )
VIEW( = 'view )
class google.cloud.bigquery.enums.KeyResultStatementKind()
Determines which statement in the script represents the “key result”.
The “key result” is used to populate the schema and query results of the script job.
FIRST_SELECT( = 'FIRST_SELECT )
KEY_RESULT_STATEMENT_KIND_UNSPECIFIED( = 'KEY_RESULT_STATEMENT_KIND_UNSPECIFIED )
LAST( = 'LAST )
class google.cloud.bigquery.enums.QueryApiMethod(value)
API method used to start the query. The default value is
INSERT
.
INSERT( = 'INSERT )
Submit a query job by using the jobs.insert REST API method.
This supports all job configuration options.
QUERY( = 'QUERY )
Submit a query job by using the jobs.query REST API method.
Differences from INSERT
:
Many parameters and job configuration options, including job ID and destination table, cannot be used with this API method. See the jobs.query REST API documentation for the complete list of supported configuration options.
API blocks up to a specified timeout, waiting for the query to finish.
The full job resource (including job statistics) may not be available. Call
reload()
orget_job()
to get full job statistics and configuration.query()
can raise API exceptions if the query fails, whereas the same errors don’t appear until callingresult()
when theINSERT
API method is used.
class google.cloud.bigquery.enums.QueryPriority()
Specifies a priority for the query. The default value is
INTERACTIVE
.
BATCH( = 'BATCH )
Specifies batch priority.
INTERACTIVE( = 'INTERACTIVE )
Specifies interactive priority.
class google.cloud.bigquery.enums.SchemaUpdateOption()
Specifies an update to the destination table schema as a side effect of a load job.
ALLOW_FIELD_ADDITION( = 'ALLOW_FIELD_ADDITION )
Allow adding a nullable field to the schema.
ALLOW_FIELD_RELAXATION( = 'ALLOW_FIELD_RELAXATION )
Allow relaxing a required field in the original schema to nullable.
class google.cloud.bigquery.enums.SourceFormat()
The format of the data files. The default value is CSV
.
Note that the set of allowed values for loading data is different
than the set used for external data sources (see
ExternalSourceFormat
).
AVRO( = 'AVRO )
Specifies Avro format.
CSV( = 'CSV )
Specifies CSV format.
DATASTORE_BACKUP( = 'DATASTORE_BACKUP )
Specifies datastore backup format
NEWLINE_DELIMITED_JSON( = 'NEWLINE_DELIMITED_JSON )
Specifies newline delimited JSON format.
ORC( = 'ORC )
Specifies Orc format.
PARQUET( = 'PARQUET )
Specifies Parquet format.
class google.cloud.bigquery.enums.SqlTypeNames(value)
Enum of allowed SQL type names in schema.SchemaField.
BIGDECIMAL( = 'BIGNUMERIC )
BIGNUMERIC( = 'BIGNUMERIC )
BOOL( = 'BOOLEAN )
BOOLEAN( = 'BOOLEAN )
BYTES( = 'BYTES )
DATE( = 'DATE )
DATETIME( = 'DATETIME )
DECIMAL( = 'NUMERIC )
FLOAT( = 'FLOAT )
FLOAT64( = 'FLOAT )
GEOGRAPHY( = 'GEOGRAPHY )
INT64( = 'INTEGER )
INTEGER( = 'INTEGER )
INTERVAL( = 'INTERVAL )
NUMERIC( = 'NUMERIC )
RANGE( = 'RANGE )
RECORD( = 'RECORD )
STRING( = 'STRING )
STRUCT( = 'RECORD )
TIME( = 'TIME )
TIMESTAMP( = 'TIMESTAMP )
class google.cloud.bigquery.enums.StandardSqlTypeNames(value)
An enumeration.
ARRAY( = 'ARRAY )
BIGNUMERIC( = 'BIGNUMERIC )
BOOL( = 'BOOL )
BYTES( = 'BYTES )
DATE( = 'DATE )
DATETIME( = 'DATETIME )
FLOAT64( = 'FLOAT64 )
GEOGRAPHY( = 'GEOGRAPHY )
INT64( = 'INT64 )
INTERVAL( = 'INTERVAL )
JSON( = 'JSON )
NUMERIC( = 'NUMERIC )
RANGE( = 'RANGE )
STRING( = 'STRING )
STRUCT( = 'STRUCT )
TIME( = 'TIME )
TIMESTAMP( = 'TIMESTAMP )
TYPE_KIND_UNSPECIFIED( = 'TYPE_KIND_UNSPECIFIED )
class google.cloud.bigquery.enums.WriteDisposition()
Specifies the action that occurs if destination table already exists.
The default value is WRITE_APPEND
.
Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
WRITE_APPEND( = 'WRITE_APPEND )
If the table already exists, BigQuery appends the data to the table.
WRITE_EMPTY( = 'WRITE_EMPTY )
If the table already exists and contains data, a ‘duplicate’ error is returned in the job result.
WRITE_TRUNCATE( = 'WRITE_TRUNCATE )
If the table already exists, BigQuery overwrites the table data.