Package Properties and Attributes (3.26.0)

Summary of entries of Properties and Attributes for bigquery.

The scopes required for authenticating as a BigQuery consumer.

See more: google.cloud.bigquery.client.Client.SCOPE

Default LoadJobConfig.

See more: google.cloud.bigquery.client.Client.default_load_job_config

Default QueryJobConfig or None.

See more: google.cloud.bigquery.client.Client.default_query_job_config

Default location for jobs / datasets / tables.

See more: google.cloud.bigquery.client.Client.location

API resource representation of a dataset reference.

See more: google.cloud.bigquery.dataset.AccessEntry.dataset

Which resources that the dataset in this entry applies to.

See more: google.cloud.bigquery.dataset.AccessEntry.dataset_target_types

A domain to grant access to.

See more: google.cloud.bigquery.dataset.AccessEntry.domain

The entity_id of the entry.

See more: google.cloud.bigquery.dataset.AccessEntry.entity_id

The entity_type of the entry.

See more: google.cloud.bigquery.dataset.AccessEntry.entity_type

An email address of a Google Group to grant access to.

See more: google.cloud.bigquery.dataset.AccessEntry.group_by_email

The role of the entry.

See more: google.cloud.bigquery.dataset.AccessEntry.role

API resource representation of a routine reference.

See more: google.cloud.bigquery.dataset.AccessEntry.routine

A special group to grant access to.

See more: google.cloud.bigquery.dataset.AccessEntry.special_group

An email address of a user to grant access to.

See more: google.cloud.bigquery.dataset.AccessEntry.user_by_email

API resource representation of a view reference.

See more: google.cloud.bigquery.dataset.AccessEntry.view

List[google.cloud.bigquery.dataset.AccessEntry]: Dataset's access entries.

See more: google.cloud.bigquery.dataset.Dataset.access_entries

Union[datetime.datetime, None]: Datetime at which the dataset was created (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.Dataset.created

str: Dataset ID.

See more: google.cloud.bigquery.dataset.Dataset.dataset_id

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for all tables in the dataset.

See more: google.cloud.bigquery.dataset.Dataset.default_encryption_configuration

Optional[int]: The default partition expiration for all partitioned tables in the dataset, in milliseconds.

See more: google.cloud.bigquery.dataset.Dataset.default_partition_expiration_ms

Union[str, None]: defaultRoundingMode of the dataset as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.default_rounding_mode

Union[int, None]: Default expiration time for tables in the dataset (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.default_table_expiration_ms

Optional[str]: Description of the dataset as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.description

Union[str, None]: ETag for the dataset resource (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.Dataset.etag

Union[str, None]: Title of the dataset as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.friendly_name

Union[str, None]: ID for the dataset resource (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.Dataset.full_dataset_id

Optional[bool]: True if the dataset and its table names are case-insensitive, otherwise False.

See more: google.cloud.bigquery.dataset.Dataset.is_case_insensitive

Dict[str, str]: Labels for the dataset.

See more: google.cloud.bigquery.dataset.Dataset.labels

Union[str, None]: Location in which the dataset is hosted as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.location

Optional[int]: Defines the time travel window in hours.

See more: google.cloud.bigquery.dataset.Dataset.max_time_travel_hours

Union[datetime.datetime, None]: Datetime at which the dataset was last modified (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.Dataset.modified

str: URL path for the dataset based on project and dataset ID.

See more: google.cloud.bigquery.dataset.Dataset.path

str: Project ID of the project bound to the dataset.

See more: google.cloud.bigquery.dataset.Dataset.project

google.cloud.bigquery.dataset.DatasetReference: A reference to this dataset.

See more: google.cloud.bigquery.dataset.Dataset.reference

Union[str, None]: URL for the dataset resource (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.Dataset.self_link

Union[str, None]: StorageBillingModel of the dataset as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.Dataset.storage_billing_model

str: Dataset ID.

See more: google.cloud.bigquery.dataset.DatasetListItem.dataset_id

Union[str, None]: Title of the dataset as set by the user (defaults to :data:None).

See more: google.cloud.bigquery.dataset.DatasetListItem.friendly_name

Union[str, None]: ID for the dataset resource (:data:None until set from the server).

See more: google.cloud.bigquery.dataset.DatasetListItem.full_dataset_id

Dict[str, str]: Labels for the dataset.

See more: google.cloud.bigquery.dataset.DatasetListItem.labels

str: Project bound to the dataset.

See more: google.cloud.bigquery.dataset.DatasetListItem.project

google.cloud.bigquery.dataset.DatasetReference: A reference to this dataset.

See more: google.cloud.bigquery.dataset.DatasetListItem.reference

str: Dataset ID.

See more: google.cloud.bigquery.dataset.DatasetReference.dataset_id

str: URL path for the dataset based on project and dataset ID.

See more: google.cloud.bigquery.dataset.DatasetReference.path

str: Project ID of the dataset.

See more: google.cloud.bigquery.dataset.DatasetReference.project

google.cloud.bigquery.job.query.QueryJob | None: The query job created by the last execute*() call, if a query job was created.

See more: google.cloud.bigquery.dbapi.Cursor.query_job

str: Resource ID of Cloud KMS key.

See more: google.cloud.bigquery.encryption_configuration.EncryptionConfiguration.kms_key_name

Specifies DEFLATE format.

See more: google.cloud.bigquery.enums.Compression.DEFLATE

Specifies GZIP format.

See more: google.cloud.bigquery.enums.Compression.GZIP

Specifies no compression.

See more: google.cloud.bigquery.enums.Compression.NONE

Specifies SNAPPY format.

See more: google.cloud.bigquery.enums.Compression.SNAPPY

Specifies ZSTD format.

See more: google.cloud.bigquery.enums.Compression.ZSTD

If the table does not exist, BigQuery creates the table.

See more: google.cloud.bigquery.enums.CreateDisposition.CREATE_IF_NEEDED

The table must already exist.

See more: google.cloud.bigquery.enums.CreateDisposition.CREATE_NEVER

Decimal values could be converted to BIGNUMERIC type.

See more: google.cloud.bigquery.enums.DecimalTargetType.BIGNUMERIC

Decimal values could be converted to NUMERIC type.

See more: google.cloud.bigquery.enums.DecimalTargetType.NUMERIC

Decimal values could be converted to STRING type.

See more: google.cloud.bigquery.enums.DecimalTargetType.STRING

Specifies default bool dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.BOOL_DTYPE

Specifies default date dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.DATE_DTYPE

Specifies default integer dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.INT_DTYPE

Specifies default range datetime dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.RANGE_DATETIME_DTYPE

Specifies default range date dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.RANGE_DATE_DTYPE

Specifies default range timestamp dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.RANGE_TIMESTAMP_DTYPE

Specifies default time dtype.

See more: google.cloud.bigquery.enums.DefaultPandasDTypes.TIME_DTYPE

Specifies Avro format.

See more: google.cloud.bigquery.enums.DestinationFormat.AVRO

Specifies CSV format.

See more: google.cloud.bigquery.enums.DestinationFormat.CSV

Specifies newline delimited JSON format.

See more: google.cloud.bigquery.enums.DestinationFormat.NEWLINE_DELIMITED_JSON

Specifies Parquet format.

See more: google.cloud.bigquery.enums.DestinationFormat.PARQUET

The determinism of the UDF is unspecified.

See more: google.cloud.bigquery.enums.DeterminismLevel.DETERMINISM_LEVEL_UNSPECIFIED

The UDF is deterministic, meaning that 2 function calls with the same inputs always produce the same result, even across 2 query runs.

See more: google.cloud.bigquery.enums.DeterminismLevel.DETERMINISTIC

The UDF is not deterministic.

See more: google.cloud.bigquery.enums.DeterminismLevel.NOT_DETERMINISTIC

Specifies ISO-8859-1 encoding.

See more: google.cloud.bigquery.enums.Encoding.ISO_8859_1

Specifies UTF-8 encoding.

See more: google.cloud.bigquery.enums.Encoding.UTF_8

Submit a query job by using the jobs.insert REST API method <https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/insert>_.

See more: google.cloud.bigquery.enums.QueryApiMethod.INSERT

Submit a query job by using the jobs.query REST API method <https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/query>_.

See more: google.cloud.bigquery.enums.QueryApiMethod.QUERY

Specifies batch priority.

See more: google.cloud.bigquery.enums.QueryPriority.BATCH

Specifies interactive priority.

See more: google.cloud.bigquery.enums.QueryPriority.INTERACTIVE

Allow adding a nullable field to the schema.

See more: google.cloud.bigquery.enums.SchemaUpdateOption.ALLOW_FIELD_ADDITION

Allow relaxing a required field in the original schema to nullable.

See more: google.cloud.bigquery.enums.SchemaUpdateOption.ALLOW_FIELD_RELAXATION

Specifies Avro format.

See more: google.cloud.bigquery.enums.SourceFormat.AVRO

Specifies CSV format.

See more: google.cloud.bigquery.enums.SourceFormat.CSV

Specifies datastore backup format.

See more: google.cloud.bigquery.enums.SourceFormat.DATASTORE_BACKUP

Specifies newline delimited JSON format.

See more: google.cloud.bigquery.enums.SourceFormat.NEWLINE_DELIMITED_JSON

Specifies Orc format.

See more: google.cloud.bigquery.enums.SourceFormat.ORC

Specifies Parquet format.

See more: google.cloud.bigquery.enums.SourceFormat.PARQUET

If the table already exists, BigQuery appends the data to the table.

See more: google.cloud.bigquery.enums.WriteDisposition.WRITE_APPEND

If the table already exists and contains data, a 'duplicate' error is returned in the job result.

See more: google.cloud.bigquery.enums.WriteDisposition.WRITE_EMPTY

If the table already exists, BigQuery overwrites the table data.

See more: google.cloud.bigquery.enums.WriteDisposition.WRITE_TRUNCATE

str: The encoding of the values when the type is not STRING.

See more: google.cloud.bigquery.external_config.BigtableColumn.encoding

str: An identifier to use if the qualifier is not a valid BigQuery field identifier.

See more: google.cloud.bigquery.external_config.BigtableColumn.field_name

bool: If this is set, only the latest version of value in this column are exposed.

See more: google.cloud.bigquery.external_config.BigtableColumn.only_read_latest

Union[str, bytes]: The qualifier encoded in binary.

See more: google.cloud.bigquery.external_config.BigtableColumn.qualifier_encoded

str: A valid UTF-8 string qualifier.

See more: google.cloud.bigquery.external_config.BigtableColumn.qualifier_string

str: The type to convert the value in cells of this column.

See more: google.cloud.bigquery.external_config.BigtableColumn.type_

List[BigtableColumn]: Lists of columns that should be exposed as individual fields.

See more: google.cloud.bigquery.external_config.BigtableColumnFamily.columns

str: The encoding of the values when the type is not STRING.

See more: google.cloud.bigquery.external_config.BigtableColumnFamily.encoding

str: Identifier of the column family.

See more: google.cloud.bigquery.external_config.BigtableColumnFamily.family_id

bool: If this is set only the latest version of value are exposed for all columns in this column family.

See more: google.cloud.bigquery.external_config.BigtableColumnFamily.only_read_latest

str: The type to convert the value in cells of this column family.

See more: google.cloud.bigquery.external_config.BigtableColumnFamily.type_

List[.external_config.BigtableColumnFamily]: List of column families to expose in the table schema along with their types.

See more: google.cloud.bigquery.external_config.BigtableOptions.column_families

bool: If :data:True, ignore columns not specified in column_families list.

See more: google.cloud.bigquery.external_config.BigtableOptions.ignore_unspecified_column_families

bool: If :data:True, rowkey column families will be read and converted to string.

See more: google.cloud.bigquery.external_config.BigtableOptions.read_rowkey_as_string

bool: If :data:True, BigQuery treats missing trailing columns as null values.

See more: google.cloud.bigquery.external_config.CSVOptions.allow_jagged_rows

bool: If :data:True, quoted data sections that contain newline characters in a CSV file are allowed.

See more: google.cloud.bigquery.external_config.CSVOptions.allow_quoted_newlines

str: The character encoding of the data.

See more: google.cloud.bigquery.external_config.CSVOptions.encoding

str: The separator for fields in a CSV file.

See more: google.cloud.bigquery.external_config.CSVOptions.field_delimiter

bool: Indicates if the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '' to '') are preserved.

See more: google.cloud.bigquery.external_config.CSVOptions.preserve_ascii_control_characters

str: The value that is used to quote data sections in a CSV file.

See more: google.cloud.bigquery.external_config.CSVOptions.quote_character

int: The number of rows at the top of a CSV file.

See more: google.cloud.bigquery.external_config.CSVOptions.skip_leading_rows

bool: If :data:True, try to detect schema and format options automatically.

See more: google.cloud.bigquery.external_config.ExternalConfig.autodetect

Additional properties to set if sourceFormat is set to AVRO.

See more: google.cloud.bigquery.external_config.ExternalConfig.avro_options

Additional properties to set if sourceFormat is set to BIGTABLE.

See more: google.cloud.bigquery.external_config.ExternalConfig.bigtable_options

str: The compression type of the data source.

See more: google.cloud.bigquery.external_config.ExternalConfig.compression

Optional[str]: [Experimental] ID of a BigQuery Connection API resource.

See more: google.cloud.bigquery.external_config.ExternalConfig.connection_id

Additional properties to set if sourceFormat is set to CSV.

See more: google.cloud.bigquery.external_config.ExternalConfig.csv_options

Possible SQL data types to which the source decimal values are converted.

See more: google.cloud.bigquery.external_config.ExternalConfig.decimal_target_types

Additional properties to set if sourceFormat is set to GOOGLE_SHEETS.

See more: google.cloud.bigquery.external_config.ExternalConfig.google_sheets_options

Optional[.external_config.HivePartitioningOptions]: [Beta] When set, it configures hive partitioning support.

See more: google.cloud.bigquery.external_config.ExternalConfig.hive_partitioning

bool: If :data:True, extra values that are not represented in the table schema are ignored.

See more: google.cloud.bigquery.external_config.ExternalConfig.ignore_unknown_values

int: The maximum number of bad records that BigQuery can ignore when reading data.

See more: google.cloud.bigquery.external_config.ExternalConfig.max_bad_records

Source-specific options.

See more: google.cloud.bigquery.external_config.ExternalConfig.options

Additional properties to set if sourceFormat is set to PARQUET.

See more: google.cloud.bigquery.external_config.ExternalConfig.parquet_options

Optional[str]: When creating an external table, the user can provide a reference file with the table schema.

See more: google.cloud.bigquery.external_config.ExternalConfig.reference_file_schema_uri

List[SchemaField]: The schema for the data.

See more: google.cloud.bigquery.external_config.ExternalConfig.schema

.external_config.ExternalSourceFormat: Format of external source.

See more: google.cloud.bigquery.external_config.ExternalConfig.source_format

List[str]: URIs that point to your data in Google Cloud.

See more: google.cloud.bigquery.external_config.ExternalConfig.source_uris

Specifies Avro format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.AVRO

Specifies Bigtable format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.BIGTABLE

Specifies CSV format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.CSV

Specifies datastore backup format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.DATASTORE_BACKUP

Specifies Google Sheets format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.GOOGLE_SHEETS

Specifies newline delimited JSON format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.NEWLINE_DELIMITED_JSON

Specifies ORC format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.ORC

Specifies Parquet format.

See more: google.cloud.bigquery.external_config.ExternalSourceFormat.PARQUET

str: The range of a sheet that BigQuery will query from.

See more: google.cloud.bigquery.external_config.GoogleSheetsOptions.range

int: The number of rows at the top of a sheet that BigQuery will skip when reading the data.

See more: google.cloud.bigquery.external_config.GoogleSheetsOptions.skip_leading_rows

Optional[str]: When set, what mode of hive partitioning to use when reading data.

See more: google.cloud.bigquery.external_config.HivePartitioningOptions.mode

Optional[bool]: If set to true, queries over the partitioned table require a partition filter that can be used for partition elimination to be specified.

See more: google.cloud.bigquery.external_config.HivePartitioningOptions.require_partition_filter

Optional[str]: When hive partition detection is requested, a common prefix for all source URIs is required.

See more: google.cloud.bigquery.external_config.HivePartitioningOptions.source_uri_prefix

[Optional] If sourceFormat is set to 'AVRO', indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).

See more: google.cloud.bigquery.format_options.AvroOptions.use_avro_logical_types

Indicates whether to use schema inference specifically for Parquet LIST logical type.

See more: google.cloud.bigquery.format_options.ParquetOptions.enable_list_inference

Indicates whether to infer Parquet ENUM logical type as STRING instead of BYTES by default.

See more: google.cloud.bigquery.format_options.ParquetOptions.enum_as_string

Indicates whether to simplify the representation of parquet maps to only show keys and values.

See more: google.cloud.bigquery.format_options.ParquetOptions.map_target_type

Specifies DEFLATE format.

See more: google.cloud.bigquery.job.Compression.DEFLATE

Specifies GZIP format.

See more: google.cloud.bigquery.job.Compression.GZIP

Specifies no compression.

See more: google.cloud.bigquery.job.Compression.NONE

Specifies SNAPPY format.

See more: google.cloud.bigquery.job.Compression.SNAPPY

Specifies ZSTD format.

See more: google.cloud.bigquery.job.Compression.ZSTD

The configuration for this copy job.

See more: google.cloud.bigquery.job.CopyJob.configuration

See create_disposition.

See more: google.cloud.bigquery.job.CopyJob.create_disposition

Datetime at which the job was created.

See more: google.cloud.bigquery.job.CopyJob.created

google.cloud.bigquery.table.TableReference: Table into which data is to be loaded.

See more: google.cloud.bigquery.job.CopyJob.destination

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.CopyJob.destination_encryption_configuration

Datetime at which the job finished.

See more: google.cloud.bigquery.job.CopyJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.CopyJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.CopyJob.errors

ETag for the job resource.

See more: google.cloud.bigquery.job.CopyJob.etag

str: ID of the job.

See more: google.cloud.bigquery.job.CopyJob.job_id

Type of job.

See more: google.cloud.bigquery.job.CopyJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.CopyJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.CopyJob.location

The number of child jobs executed.

See more: google.cloud.bigquery.job.CopyJob.num_child_jobs

Return the ID of the parent job.

See more: google.cloud.bigquery.job.CopyJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.CopyJob.path

Project bound to the job.

See more: google.cloud.bigquery.job.CopyJob.project

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.CopyJob.reservation_usage

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.CopyJob.script_statistics

URL for the job resource.

See more: google.cloud.bigquery.job.CopyJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.CopyJob.session_info

List[google.cloud.bigquery.table.TableReference]): Table(s) from which data is to be loaded.

See more: google.cloud.bigquery.job.CopyJob.sources

Datetime at which the job was started.

See more: google.cloud.bigquery.job.CopyJob.started

Status of the job.

See more: google.cloud.bigquery.job.CopyJob.state

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.CopyJob.transaction_info

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.CopyJob.user_email

See write_disposition.

See more: google.cloud.bigquery.job.CopyJob.write_disposition

google.cloud.bigquery.job.CreateDisposition: Specifies behavior for creating tables.

See more: google.cloud.bigquery.job.CopyJobConfig.create_disposition

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.CopyJobConfig.destination_encryption_configuration

google.cloud.bigquery.job.DestinationExpirationTime: The time when the destination table expires.

See more: google.cloud.bigquery.job.CopyJobConfig.destination_expiration_time

Optional parameter.

See more: google.cloud.bigquery.job.CopyJobConfig.job_timeout_ms

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.CopyJobConfig.labels

The operation to perform with this copy job.

See more: google.cloud.bigquery.job.CopyJobConfig.operation_type

google.cloud.bigquery.job.WriteDisposition: Action that occurs if the destination table already exists.

See more: google.cloud.bigquery.job.CopyJobConfig.write_disposition

If the table does not exist, BigQuery creates the table.

See more: google.cloud.bigquery.job.CreateDisposition.CREATE_IF_NEEDED

The table must already exist.

See more: google.cloud.bigquery.job.CreateDisposition.CREATE_NEVER

Specifies Avro format.

See more: google.cloud.bigquery.job.DestinationFormat.AVRO

Specifies CSV format.

See more: google.cloud.bigquery.job.DestinationFormat.CSV

Specifies newline delimited JSON format.

See more: google.cloud.bigquery.job.DestinationFormat.NEWLINE_DELIMITED_JSON

Specifies Parquet format.

See more: google.cloud.bigquery.job.DestinationFormat.PARQUET

Number of deleted rows.

See more: google.cloud.bigquery.job.DmlStats.deleted_row_count

Number of inserted rows.

See more: google.cloud.bigquery.job.DmlStats.inserted_row_count

Number of updated rows.

See more: google.cloud.bigquery.job.DmlStats.updated_row_count

Specifies ISO-8859-1 encoding.

See more: google.cloud.bigquery.job.Encoding.ISO_8859_1

Specifies UTF-8 encoding.

See more: google.cloud.bigquery.job.Encoding.UTF_8

See compression.

See more: google.cloud.bigquery.job.ExtractJob.compression

The configuration for this extract job.

See more: google.cloud.bigquery.job.ExtractJob.configuration

Datetime at which the job was created.

See more: google.cloud.bigquery.job.ExtractJob.created

See destination_format.

See more: google.cloud.bigquery.job.ExtractJob.destination_format

Return file counts from job statistics, if present.

See more: google.cloud.bigquery.job.ExtractJob.destination_uri_file_counts

List[str]: URIs describing where the extracted data will be written in Cloud Storage, using the format gs://<bucket_name>/<object_name_or_glob>.

See more: google.cloud.bigquery.job.ExtractJob.destination_uris

Datetime at which the job finished.

See more: google.cloud.bigquery.job.ExtractJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.ExtractJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.ExtractJob.errors

ETag for the job resource.

See more: google.cloud.bigquery.job.ExtractJob.etag

See field_delimiter.

See more: google.cloud.bigquery.job.ExtractJob.field_delimiter

str: ID of the job.

See more: google.cloud.bigquery.job.ExtractJob.job_id

Type of job.

See more: google.cloud.bigquery.job.ExtractJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.ExtractJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.ExtractJob.location

The number of child jobs executed.

See more: google.cloud.bigquery.job.ExtractJob.num_child_jobs

Return the ID of the parent job.

See more: google.cloud.bigquery.job.ExtractJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.ExtractJob.path

See print_header.

See more: google.cloud.bigquery.job.ExtractJob.print_header

Project bound to the job.

See more: google.cloud.bigquery.job.ExtractJob.project

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.ExtractJob.reservation_usage

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.ExtractJob.script_statistics

URL for the job resource.

See more: google.cloud.bigquery.job.ExtractJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.ExtractJob.session_info

Union[ google.cloud.bigquery.table.TableReference, google.cloud.bigquery.model.ModelReference ]: Table or Model from which data is to be loaded or extracted.

See more: google.cloud.bigquery.job.ExtractJob.source

Datetime at which the job was started.

See more: google.cloud.bigquery.job.ExtractJob.started

Status of the job.

See more: google.cloud.bigquery.job.ExtractJob.state

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.ExtractJob.transaction_info

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.ExtractJob.user_email

google.cloud.bigquery.job.Compression: Compression type to use for exported files.

See more: google.cloud.bigquery.job.ExtractJobConfig.compression

google.cloud.bigquery.job.DestinationFormat: Exported file format.

See more: google.cloud.bigquery.job.ExtractJobConfig.destination_format

str: Delimiter to use between fields in the exported data.

See more: google.cloud.bigquery.job.ExtractJobConfig.field_delimiter

Optional parameter.

See more: google.cloud.bigquery.job.ExtractJobConfig.job_timeout_ms

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.ExtractJobConfig.labels

bool: Print a header row in the exported data.

See more: google.cloud.bigquery.job.ExtractJobConfig.print_header

bool: For loads of Avro data, governs whether Avro logical types are converted to their corresponding BigQuery types (e.g.

See more: google.cloud.bigquery.job.ExtractJobConfig.use_avro_logical_types

See allow_jagged_rows.

See more: google.cloud.bigquery.job.LoadJob.allow_jagged_rows

See allow_quoted_newlines.

See more: google.cloud.bigquery.job.LoadJob.allow_quoted_newlines

See autodetect.

See more: google.cloud.bigquery.job.LoadJob.autodetect

See clustering_fields.

See more: google.cloud.bigquery.job.LoadJob.clustering_fields

The configuration for this load job.

See more: google.cloud.bigquery.job.LoadJob.configuration

See connection_properties.

See more: google.cloud.bigquery.job.LoadJob.connection_properties

See create_disposition.

See more: google.cloud.bigquery.job.LoadJob.create_disposition

See create_session.

See more: google.cloud.bigquery.job.LoadJob.create_session

Datetime at which the job was created.

See more: google.cloud.bigquery.job.LoadJob.created

google.cloud.bigquery.table.TableReference: table where loaded rows are written.

See more: google.cloud.bigquery.job.LoadJob.destination

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.LoadJob.destination_encryption_configuration

Optional[str] name given to destination table.

See more: google.cloud.bigquery.job.LoadJob.destination_table_description

Optional[str] name given to destination table.

See more: google.cloud.bigquery.job.LoadJob.destination_table_friendly_name

See encoding.

See more: google.cloud.bigquery.job.LoadJob.encoding

Datetime at which the job finished.

See more: google.cloud.bigquery.job.LoadJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.LoadJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.LoadJob.errors

ETag for the job resource.

See more: google.cloud.bigquery.job.LoadJob.etag

See field_delimiter.

See more: google.cloud.bigquery.job.LoadJob.field_delimiter

See ignore_unknown_values.

See more: google.cloud.bigquery.job.LoadJob.ignore_unknown_values

Count of bytes loaded from source files.

See more: google.cloud.bigquery.job.LoadJob.input_file_bytes

Count of source files.

See more: google.cloud.bigquery.job.LoadJob.input_files

str: ID of the job.

See more: google.cloud.bigquery.job.LoadJob.job_id

Type of job.

See more: google.cloud.bigquery.job.LoadJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.LoadJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.LoadJob.location

See max_bad_records.

See more: google.cloud.bigquery.job.LoadJob.max_bad_records

See null_marker.

See more: google.cloud.bigquery.job.LoadJob.null_marker

The number of child jobs executed.

See more: google.cloud.bigquery.job.LoadJob.num_child_jobs

Count of bytes saved to destination table.

See more: google.cloud.bigquery.job.LoadJob.output_bytes

Count of rows saved to destination table.

See more: google.cloud.bigquery.job.LoadJob.output_rows

Return the ID of the parent job.

See more: google.cloud.bigquery.job.LoadJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.LoadJob.path

Project bound to the job.

See more: google.cloud.bigquery.job.LoadJob.project

See quote_character.

See more: google.cloud.bigquery.job.LoadJob.quote_character

See range_partitioning.

See more: google.cloud.bigquery.job.LoadJob.range_partitioning

See: attr:<xref uid="google.cloud.bigquery.job.LoadJobConfig.reference_file_schema_uri">google.cloud.bigquery.job.LoadJobConfig.reference_file_schema_uri</xref>.

See more: google.cloud.bigquery.job.LoadJob.reference_file_schema_uri

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.LoadJob.reservation_usage

See schema.

See more: google.cloud.bigquery.job.LoadJob.schema

See schema_update_options.

See more: google.cloud.bigquery.job.LoadJob.schema_update_options

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.LoadJob.script_statistics

URL for the job resource.

See more: google.cloud.bigquery.job.LoadJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.LoadJob.session_info

See skip_leading_rows.

See more: google.cloud.bigquery.job.LoadJob.skip_leading_rows

See source_format.

See more: google.cloud.bigquery.job.LoadJob.source_format

Optional[Sequence[str]]: URIs of data files to be loaded.

See more: google.cloud.bigquery.job.LoadJob.source_uris

Datetime at which the job was started.

See more: google.cloud.bigquery.job.LoadJob.started

Status of the job.

See more: google.cloud.bigquery.job.LoadJob.state

See time_partitioning.

See more: google.cloud.bigquery.job.LoadJob.time_partitioning

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.LoadJob.transaction_info

See use_avro_logical_types.

See more: google.cloud.bigquery.job.LoadJob.use_avro_logical_types

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.LoadJob.user_email

See write_disposition.

See more: google.cloud.bigquery.job.LoadJob.write_disposition

Optional[bool]: Allow missing trailing optional columns (CSV only).

See more: google.cloud.bigquery.job.LoadJobConfig.allow_jagged_rows

Optional[bool]: Allow quoted data containing newline characters (CSV only).

See more: google.cloud.bigquery.job.LoadJobConfig.allow_quoted_newlines

Optional[bool]: Automatically infer the schema from a sample of the data.

See more: google.cloud.bigquery.job.LoadJobConfig.autodetect

Optional[List[str]]: Fields defining clustering for the table.

See more: google.cloud.bigquery.job.LoadJobConfig.clustering_fields

Optional[google.cloud.bigquery.job.ColumnNameCharacterMap]: Character map supported for column names in CSV/Parquet loads.

See more: google.cloud.bigquery.job.LoadJobConfig.column_name_character_map

Connection properties.

See more: google.cloud.bigquery.job.LoadJobConfig.connection_properties

Optional[google.cloud.bigquery.job.CreateDisposition]: Specifies behavior for creating tables.

See more: google.cloud.bigquery.job.LoadJobConfig.create_disposition

[Preview] If :data:True, creates a new session, where session_info will contain a random server generated session id.

See more: google.cloud.bigquery.job.LoadJobConfig.create_session

Possible SQL data types to which the source decimal values are converted.

See more: google.cloud.bigquery.job.LoadJobConfig.decimal_target_types

Optional[google.cloud.bigquery.encryption_configuration.EncryptionConfiguration]: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.destination_encryption_configuration

Optional[str]: Description of the destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.destination_table_description

Optional[str]: Name given to destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.destination_table_friendly_name

Optional[google.cloud.bigquery.job.Encoding]: The character encoding of the data.

See more: google.cloud.bigquery.job.LoadJobConfig.encoding

Optional[str]: The separator for fields in a CSV file.

See more: google.cloud.bigquery.job.LoadJobConfig.field_delimiter

Optional[.external_config.HivePartitioningOptions]: [Beta] When set, it configures hive partitioning support.

See more: google.cloud.bigquery.job.LoadJobConfig.hive_partitioning

Optional[bool]: Ignore extra values not represented in the table schema.

See more: google.cloud.bigquery.job.LoadJobConfig.ignore_unknown_values

Optional parameter.

See more: google.cloud.bigquery.job.LoadJobConfig.job_timeout_ms

Optional[str]: The extension to use for writing JSON data to BigQuery.

See more: google.cloud.bigquery.job.LoadJobConfig.json_extension

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.LoadJobConfig.labels

Optional[int]: Number of invalid rows to ignore.

See more: google.cloud.bigquery.job.LoadJobConfig.max_bad_records

Optional[str]: Represents a null value (CSV only).

See more: google.cloud.bigquery.job.LoadJobConfig.null_marker

Optional[google.cloud.bigquery.format_options.ParquetOptions]: Additional properties to set if sourceFormat is set to PARQUET.

See more: google.cloud.bigquery.job.LoadJobConfig.parquet_options

Optional[bool]: Preserves the embedded ASCII control characters when sourceFormat is set to CSV.

See more: google.cloud.bigquery.job.LoadJobConfig.preserve_ascii_control_characters

Optional[List[str]]: If source_format is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup.

See more: google.cloud.bigquery.job.LoadJobConfig.projection_fields

Optional[str]: Character used to quote data sections (CSV only).

See more: google.cloud.bigquery.job.LoadJobConfig.quote_character

Optional[google.cloud.bigquery.table.RangePartitioning]: Configures range-based partitioning for destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.range_partitioning

Optional[str]: When creating an external table, the user can provide a reference file with the table schema.

See more: google.cloud.bigquery.job.LoadJobConfig.reference_file_schema_uri

Optional[Sequence[Union[ SchemaField, Mapping[str, Any] ]]]: Schema of the destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.schema

Optional[List[google.cloud.bigquery.job.SchemaUpdateOption]]: Specifies updates to the destination table schema to allow as a side effect of the load job.

See more: google.cloud.bigquery.job.LoadJobConfig.schema_update_options

Optional[int]: Number of rows to skip when reading data (CSV only).

See more: google.cloud.bigquery.job.LoadJobConfig.skip_leading_rows

Optional[google.cloud.bigquery.job.SourceFormat]: File format of the data.

See more: google.cloud.bigquery.job.LoadJobConfig.source_format

Optional[google.cloud.bigquery.table.TimePartitioning]: Specifies time-based partitioning for the destination table.

See more: google.cloud.bigquery.job.LoadJobConfig.time_partitioning

Optional[bool]: For loads of Avro data, governs whether Avro logical types are converted to their corresponding BigQuery types (e.g.

See more: google.cloud.bigquery.job.LoadJobConfig.use_avro_logical_types

Optional[google.cloud.bigquery.job.WriteDisposition]: Action that occurs if the destination table already exists.

See more: google.cloud.bigquery.job.LoadJobConfig.write_disposition

The source table type is TABLE and the destination table type is CLONE.

See more: google.cloud.bigquery.job.OperationType.CLONE

The source and destination table have the same table type.

See more: google.cloud.bigquery.job.OperationType.COPY

Unspecified operation type.

See more: google.cloud.bigquery.job.OperationType.OPERATION_TYPE_UNSPECIFIED

The source table type is SNAPSHOT and the destination table type is TABLE.

See more: google.cloud.bigquery.job.OperationType.RESTORE

The source table type is TABLE and the destination table type is SNAPSHOT.

See more: google.cloud.bigquery.job.OperationType.SNAPSHOT

See allow_large_results.

See more: google.cloud.bigquery.job.QueryJob.allow_large_results

Return billing tier from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.billing_tier

Return whether or not query results were served from cache.

See more: google.cloud.bigquery.job.QueryJob.cache_hit

See clustering_fields.

See more: google.cloud.bigquery.job.QueryJob.clustering_fields

The configuration for this query job.

See more: google.cloud.bigquery.job.QueryJob.configuration

See connection_properties.

See more: google.cloud.bigquery.job.QueryJob.connection_properties

See create_disposition.

See more: google.cloud.bigquery.job.QueryJob.create_disposition

See create_session.

See more: google.cloud.bigquery.job.QueryJob.create_session

Datetime at which the job was created.

See more: google.cloud.bigquery.job.QueryJob.created

Optional[str]: Return the DDL operation performed.

See more: google.cloud.bigquery.job.QueryJob.ddl_operation_performed

Optional[google.cloud.bigquery.routine.RoutineReference]: Return the DDL target routine, present for CREATE/DROP FUNCTION/PROCEDURE queries.

See more: google.cloud.bigquery.job.QueryJob.ddl_target_routine

Optional[google.cloud.bigquery.table.TableReference]: Return the DDL target table, present for CREATE/DROP TABLE/VIEW queries.

See more: google.cloud.bigquery.job.QueryJob.ddl_target_table

See default_dataset.

See more: google.cloud.bigquery.job.QueryJob.default_dataset

See destination.

See more: google.cloud.bigquery.job.QueryJob.destination

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.QueryJob.destination_encryption_configuration

See dry_run.

See more: google.cloud.bigquery.job.QueryJob.dry_run

Datetime at which the job finished.

See more: google.cloud.bigquery.job.QueryJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.QueryJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.QueryJob.errors

Return the estimated number of bytes processed by the query.

See more: google.cloud.bigquery.job.QueryJob.estimated_bytes_processed

ETag for the job resource.

See more: google.cloud.bigquery.job.QueryJob.etag

See flatten_results.

See more: google.cloud.bigquery.job.QueryJob.flatten_results

str: ID of the job.

See more: google.cloud.bigquery.job.QueryJob.job_id

Type of job.

See more: google.cloud.bigquery.job.QueryJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.QueryJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.QueryJob.location

See maximum_billing_tier.

See more: google.cloud.bigquery.job.QueryJob.maximum_billing_tier

See maximum_bytes_billed.

See more: google.cloud.bigquery.job.QueryJob.maximum_bytes_billed

The number of child jobs executed.

See more: google.cloud.bigquery.job.QueryJob.num_child_jobs

Return the number of DML rows affected by the job.

See more: google.cloud.bigquery.job.QueryJob.num_dml_affected_rows

Return the ID of the parent job.

See more: google.cloud.bigquery.job.QueryJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.QueryJob.path

See priority.

See more: google.cloud.bigquery.job.QueryJob.priority

Project bound to the job.

See more: google.cloud.bigquery.job.QueryJob.project

str: The query text used in this query job.

See more: google.cloud.bigquery.job.QueryJob.query

[Preview] ID of a completed query.

See more: google.cloud.bigquery.job.QueryJob.query_id

See query_parameters.

See more: google.cloud.bigquery.job.QueryJob.query_parameters

Return query plan from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.query_plan

See range_partitioning.

See more: google.cloud.bigquery.job.QueryJob.range_partitioning

Return referenced tables from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.referenced_tables

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.QueryJob.reservation_usage

The schema of the results.

See more: google.cloud.bigquery.job.QueryJob.schema

See schema_update_options.

See more: google.cloud.bigquery.job.QueryJob.schema_update_options

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.QueryJob.script_statistics

Returns a SearchStats object.

See more: google.cloud.bigquery.job.QueryJob.search_stats

URL for the job resource.

See more: google.cloud.bigquery.job.QueryJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.QueryJob.session_info

Union[int, None]: Slot-milliseconds used by this query job.

See more: google.cloud.bigquery.job.QueryJob.slot_millis

Datetime at which the job was started.

See more: google.cloud.bigquery.job.QueryJob.started

Status of the job.

See more: google.cloud.bigquery.job.QueryJob.state

Return statement type from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.statement_type

See table_definitions.

See more: google.cloud.bigquery.job.QueryJob.table_definitions

See time_partitioning.

See more: google.cloud.bigquery.job.QueryJob.time_partitioning

List(TimelineEntry): Return the query execution timeline from job statistics.

See more: google.cloud.bigquery.job.QueryJob.timeline

Return total bytes billed from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.total_bytes_billed

Return total bytes processed from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.total_bytes_processed

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.QueryJob.transaction_info

See udf_resources.

See more: google.cloud.bigquery.job.QueryJob.udf_resources

Return undeclared query parameters from job statistics, if present.

See more: google.cloud.bigquery.job.QueryJob.undeclared_query_parameters

See use_legacy_sql.

See more: google.cloud.bigquery.job.QueryJob.use_legacy_sql

See use_query_cache.

See more: google.cloud.bigquery.job.QueryJob.use_query_cache

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.QueryJob.user_email

See write_disposition.

See more: google.cloud.bigquery.job.QueryJob.write_disposition

bool: Allow large query results tables (legacy SQL, only).

See more: google.cloud.bigquery.job.QueryJobConfig.allow_large_results

Optional[List[str]]: Fields defining clustering for the table.

See more: google.cloud.bigquery.job.QueryJobConfig.clustering_fields

Connection properties.

See more: google.cloud.bigquery.job.QueryJobConfig.connection_properties

google.cloud.bigquery.job.CreateDisposition: Specifies behavior for creating tables.

See more: google.cloud.bigquery.job.QueryJobConfig.create_disposition

[Preview] If :data:True, creates a new session, where session_info will contain a random server generated session id.

See more: google.cloud.bigquery.job.QueryJobConfig.create_session

google.cloud.bigquery.dataset.DatasetReference: the default dataset to use for unqualified table names in the query or :data:None if not set.

See more: google.cloud.bigquery.job.QueryJobConfig.default_dataset

google.cloud.bigquery.table.TableReference: table where results are written or :data:None if not set.

See more: google.cloud.bigquery.job.QueryJobConfig.destination

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the destination table.

See more: google.cloud.bigquery.job.QueryJobConfig.destination_encryption_configuration

bool: :data:True if this query should be a dry run to estimate costs.

See more: google.cloud.bigquery.job.QueryJobConfig.dry_run

bool: Flatten nested/repeated fields in results.

See more: google.cloud.bigquery.job.QueryJobConfig.flatten_results

Optional parameter.

See more: google.cloud.bigquery.job.QueryJobConfig.job_timeout_ms

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.QueryJobConfig.labels

int: Deprecated.

See more: google.cloud.bigquery.job.QueryJobConfig.maximum_billing_tier

int: Maximum bytes to be billed for this job or :data:None if not set.

See more: google.cloud.bigquery.job.QueryJobConfig.maximum_bytes_billed

google.cloud.bigquery.job.QueryPriority: Priority of the query.

See more: google.cloud.bigquery.job.QueryJobConfig.priority

List[Union[google.cloud.bigquery.query.ArrayQueryParameter, google.cloud.bigquery.query.ScalarQueryParameter, google.cloud.bigquery.query.StructQueryParameter]]: list of parameters for parameterized query (empty by default).

See more: google.cloud.bigquery.job.QueryJobConfig.query_parameters

Optional[google.cloud.bigquery.table.RangePartitioning]: Configures range-based partitioning for destination table.

See more: google.cloud.bigquery.job.QueryJobConfig.range_partitioning

List[google.cloud.bigquery.job.SchemaUpdateOption]: Specifies updates to the destination table schema to allow as a side effect of the query job.

See more: google.cloud.bigquery.job.QueryJobConfig.schema_update_options

Options controlling the execution of scripts.

See more: google.cloud.bigquery.job.QueryJobConfig.script_options

Dict[str, google.cloud.bigquery.external_config.ExternalConfig]: Definitions for external tables or :data:None if not set.

See more: google.cloud.bigquery.job.QueryJobConfig.table_definitions

Optional[google.cloud.bigquery.table.TimePartitioning]: Specifies time-based partitioning for the destination table.

See more: google.cloud.bigquery.job.QueryJobConfig.time_partitioning

List[google.cloud.bigquery.query.UDFResource]: user defined function resources (empty by default).

See more: google.cloud.bigquery.job.QueryJobConfig.udf_resources

bool: Use legacy SQL syntax.

See more: google.cloud.bigquery.job.QueryJobConfig.use_legacy_sql

bool: Look for the query result in the cache.

See more: google.cloud.bigquery.job.QueryJobConfig.use_query_cache

google.cloud.bigquery.job.WriteDisposition: Action that occurs if the destination table already exists.

See more: google.cloud.bigquery.job.QueryJobConfig.write_disposition

Optional[int]: Number of parallel input segments completed.

See more: google.cloud.bigquery.job.QueryPlanEntry.completed_parallel_inputs

Optional[int]: Milliseconds the average worker spent on CPU-bound processing.

See more: google.cloud.bigquery.job.QueryPlanEntry.compute_ms_avg

Optional[int]: Milliseconds the slowest worker spent on CPU-bound processing.

See more: google.cloud.bigquery.job.QueryPlanEntry.compute_ms_max

Optional[float]: Ratio of time the average worker spent on CPU-bound processing, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.compute_ratio_avg

Optional[float]: Ratio of time the slowest worker spent on CPU-bound processing, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.compute_ratio_max

Optional[Datetime]: Datetime when the stage ended.

See more: google.cloud.bigquery.job.QueryPlanEntry.end

Optional[str]: Unique ID for the stage within the plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.entry_id

List(int): Entry IDs for stages that were inputs for this stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.input_stages

Optional[str]: Human-readable name of the stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.name

Optional[int]: Number of parallel input segments within the stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.parallel_inputs

Optional[int]: Milliseconds the average worker spent reading input.

See more: google.cloud.bigquery.job.QueryPlanEntry.read_ms_avg

Optional[int]: Milliseconds the slowest worker spent reading input.

See more: google.cloud.bigquery.job.QueryPlanEntry.read_ms_max

Optional[float]: Ratio of time the average worker spent reading input, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.read_ratio_avg

Optional[float]: Ratio of time the slowest worker spent reading to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.read_ratio_max

Optional[int]: Number of records read by this stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.records_read

Optional[int]: Number of records written by this stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.records_written

Optional[int]: Number of bytes written by this stage to intermediate shuffle.

See more: google.cloud.bigquery.job.QueryPlanEntry.shuffle_output_bytes

Optional[int]: Number of bytes written by this stage to intermediate shuffle and spilled to disk.

See more: google.cloud.bigquery.job.QueryPlanEntry.shuffle_output_bytes_spilled

Optional[int]: Slot-milliseconds used by the stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.slot_ms

Optional[Datetime]: Datetime when the stage started.

See more: google.cloud.bigquery.job.QueryPlanEntry.start

Optional[str]: status of this stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.status

List(QueryPlanEntryStep): List of step operations performed by each worker in the stage.

See more: google.cloud.bigquery.job.QueryPlanEntry.steps

Optional[int]: Milliseconds the average worker spent waiting to be scheduled.

See more: google.cloud.bigquery.job.QueryPlanEntry.wait_ms_avg

Optional[int]: Milliseconds the slowest worker spent waiting to be scheduled.

See more: google.cloud.bigquery.job.QueryPlanEntry.wait_ms_max

Optional[float]: Ratio of time the average worker spent waiting to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.wait_ratio_avg

Optional[float]: Ratio of time the slowest worker spent waiting to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.wait_ratio_max

Optional[int]: Milliseconds the average worker spent writing output data.

See more: google.cloud.bigquery.job.QueryPlanEntry.write_ms_avg

Optional[int]: Milliseconds the slowest worker spent writing output data.

See more: google.cloud.bigquery.job.QueryPlanEntry.write_ms_max

Optional[float]: Ratio of time the average worker spent writing output data, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.write_ratio_avg

Optional[float]: Ratio of time the slowest worker spent writing output data, relative to the longest time spent by any worker in any stage of the overall plan.

See more: google.cloud.bigquery.job.QueryPlanEntry.write_ratio_max

Specifies batch priority.

See more: google.cloud.bigquery.job.QueryPriority.BATCH

Specifies interactive priority.

See more: google.cloud.bigquery.job.QueryPriority.INTERACTIVE

Reservation name or "unreserved" for on-demand resources usage.

See more: google.cloud.bigquery.job.ReservationUsage.name

Total slot milliseconds used by the reservation for a particular job.

See more: google.cloud.bigquery.job.ReservationUsage.slot_ms

Allow adding a nullable field to the schema.

See more: google.cloud.bigquery.job.SchemaUpdateOption.ALLOW_FIELD_ADDITION

Allow relaxing a required field in the original schema to nullable.

See more: google.cloud.bigquery.job.SchemaUpdateOption.ALLOW_FIELD_RELAXATION

Determines which statement in the script represents the "key result".

See more: google.cloud.bigquery.job.ScriptOptions.key_result_statement

Limit on the number of bytes billed per statement.

See more: google.cloud.bigquery.job.ScriptOptions.statement_byte_budget

Timeout period for each statement in a script.

See more: google.cloud.bigquery.job.ScriptOptions.statement_timeout_ms

int: One-based end column.

See more: google.cloud.bigquery.job.ScriptStackFrame.end_column

int: One-based end line.

See more: google.cloud.bigquery.job.ScriptStackFrame.end_line

Optional[str]: Name of the active procedure.

See more: google.cloud.bigquery.job.ScriptStackFrame.procedure_id

int: One-based start column.

See more: google.cloud.bigquery.job.ScriptStackFrame.start_column

int: One-based start line.

See more: google.cloud.bigquery.job.ScriptStackFrame.start_line

str: Text of the current statement/expression.

See more: google.cloud.bigquery.job.ScriptStackFrame.text

str: Indicates the type of child job.

See more: google.cloud.bigquery.job.ScriptStatistics.evaluation_kind

Stack trace where the current evaluation happened.

See more: google.cloud.bigquery.job.ScriptStatistics.stack_frames

Specifies Avro format.

See more: google.cloud.bigquery.job.SourceFormat.AVRO

Specifies CSV format.

See more: google.cloud.bigquery.job.SourceFormat.CSV

Specifies datastore backup format.

See more: google.cloud.bigquery.job.SourceFormat.DATASTORE_BACKUP

Specifies newline delimited JSON format.

See more: google.cloud.bigquery.job.SourceFormat.NEWLINE_DELIMITED_JSON

Specifies Orc format.

See more: google.cloud.bigquery.job.SourceFormat.ORC

Specifies Parquet format.

See more: google.cloud.bigquery.job.SourceFormat.PARQUET

Optional[int]: Current number of input units being processed by workers, reported as largest value since the last sample.

See more: google.cloud.bigquery.job.TimelineEntry.active_units

Optional[int]: Current number of input units completed by this query.

See more: google.cloud.bigquery.job.TimelineEntry.completed_units

Optional[int]: Milliseconds elapsed since start of query execution.

See more: google.cloud.bigquery.job.TimelineEntry.elapsed_ms

Optional[int]: Current number of input units remaining for query stages active at this sample time.

See more: google.cloud.bigquery.job.TimelineEntry.pending_units

Optional[int]: Cumulative slot-milliseconds consumed by this query.

See more: google.cloud.bigquery.job.TimelineEntry.slot_millis

Output only.

See more: google.cloud.bigquery.job.TransactionInfo.transaction_id

Job-type specific configurtion.

See more: google.cloud.bigquery.job.UnknownJob.configuration

Datetime at which the job was created.

See more: google.cloud.bigquery.job.UnknownJob.created

Datetime at which the job finished.

See more: google.cloud.bigquery.job.UnknownJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.UnknownJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.UnknownJob.errors

ETag for the job resource.

See more: google.cloud.bigquery.job.UnknownJob.etag

str: ID of the job.

See more: google.cloud.bigquery.job.UnknownJob.job_id

Type of job.

See more: google.cloud.bigquery.job.UnknownJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.UnknownJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.UnknownJob.location

The number of child jobs executed.

See more: google.cloud.bigquery.job.UnknownJob.num_child_jobs

Return the ID of the parent job.

See more: google.cloud.bigquery.job.UnknownJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.UnknownJob.path

Project bound to the job.

See more: google.cloud.bigquery.job.UnknownJob.project

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.UnknownJob.reservation_usage

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.UnknownJob.script_statistics

URL for the job resource.

See more: google.cloud.bigquery.job.UnknownJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.UnknownJob.session_info

Datetime at which the job was started.

See more: google.cloud.bigquery.job.UnknownJob.started

Status of the job.

See more: google.cloud.bigquery.job.UnknownJob.state

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.UnknownJob.transaction_info

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.UnknownJob.user_email

If the table already exists, BigQuery appends the data to the table.

See more: google.cloud.bigquery.job.WriteDisposition.WRITE_APPEND

If the table already exists and contains data, a 'duplicate' error is returned in the job result.

See more: google.cloud.bigquery.job.WriteDisposition.WRITE_EMPTY

If the table already exists, BigQuery overwrites the table data.

See more: google.cloud.bigquery.job.WriteDisposition.WRITE_TRUNCATE

Reservation name or "unreserved" for on-demand resources usage.

See more: google.cloud.bigquery.job.base.ReservationUsage.name

Total slot milliseconds used by the reservation for a particular job.

See more: google.cloud.bigquery.job.base.ReservationUsage.slot_ms

int: One-based end column.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.end_column

int: One-based end line.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.end_line

Optional[str]: Name of the active procedure.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.procedure_id

int: One-based start column.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.start_column

int: One-based start line.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.start_line

str: Text of the current statement/expression.

See more: google.cloud.bigquery.job.base.ScriptStackFrame.text

str: Indicates the type of child job.

See more: google.cloud.bigquery.job.base.ScriptStatistics.evaluation_kind

Stack trace where the current evaluation happened.

See more: google.cloud.bigquery.job.base.ScriptStatistics.stack_frames

The ID of the session.

See more: google.cloud.bigquery.job.base.SessionInfo.session_id

Output only.

See more: google.cloud.bigquery.job.base.TransactionInfo.transaction_id

Job-type specific configurtion.

See more: google.cloud.bigquery.job.base.UnknownJob.configuration

Datetime at which the job was created.

See more: google.cloud.bigquery.job.base.UnknownJob.created

Datetime at which the job finished.

See more: google.cloud.bigquery.job.base.UnknownJob.ended

Error information about the job as a whole.

See more: google.cloud.bigquery.job.base.UnknownJob.error_result

Information about individual errors generated by the job.

See more: google.cloud.bigquery.job.base.UnknownJob.errors

ETag for the job resource.

See more: google.cloud.bigquery.job.base.UnknownJob.etag

str: ID of the job.

See more: google.cloud.bigquery.job.base.UnknownJob.job_id

Type of job.

See more: google.cloud.bigquery.job.base.UnknownJob.job_type

Dict[str, str]: Labels for the job.

See more: google.cloud.bigquery.job.base.UnknownJob.labels

str: Location where the job runs.

See more: google.cloud.bigquery.job.base.UnknownJob.location

The number of child jobs executed.

See more: google.cloud.bigquery.job.base.UnknownJob.num_child_jobs

Return the ID of the parent job.

See more: google.cloud.bigquery.job.base.UnknownJob.parent_job_id

URL path for the job's APIs.

See more: google.cloud.bigquery.job.base.UnknownJob.path

Project bound to the job.

See more: google.cloud.bigquery.job.base.UnknownJob.project

Job resource usage breakdown by reservation.

See more: google.cloud.bigquery.job.base.UnknownJob.reservation_usage

Statistics for a child job of a script.

See more: google.cloud.bigquery.job.base.UnknownJob.script_statistics

URL for the job resource.

See more: google.cloud.bigquery.job.base.UnknownJob.self_link

[Preview] Information of the session if this job is part of one.

See more: google.cloud.bigquery.job.base.UnknownJob.session_info

Datetime at which the job was started.

See more: google.cloud.bigquery.job.base.UnknownJob.started

Status of the job.

See more: google.cloud.bigquery.job.base.UnknownJob.state

Information of the multi-statement transaction if this job is part of one.

See more: google.cloud.bigquery.job.base.UnknownJob.transaction_info

E-mail address of user who submitted the job.

See more: google.cloud.bigquery.job.base.UnknownJob.user_email

The best trial_id across all training runs.

See more: google.cloud.bigquery.model.Model.best_trial_id

Datetime at which the model was created (:data:None until set from the server).

See more: google.cloud.bigquery.model.Model.created

ID of dataset containing the model.

See more: google.cloud.bigquery.model.Model.dataset_id

Description of the model (defaults to :data:None).

See more: google.cloud.bigquery.model.Model.description

Custom encryption configuration for the model.

See more: google.cloud.bigquery.model.Model.encryption_configuration

ETag for the model resource (:data:None until set from the server).

See more: google.cloud.bigquery.model.Model.etag

The datetime when this model expires.

See more: google.cloud.bigquery.model.Model.expires

Input feature columns that were used to train this model.

See more: google.cloud.bigquery.model.Model.feature_columns

Title of the table (defaults to :data:None).

See more: google.cloud.bigquery.model.Model.friendly_name

Label columns that were used to train this model.

See more: google.cloud.bigquery.model.Model.label_columns

Labels for the table.

See more: google.cloud.bigquery.model.Model.labels

The geographic location where the model resides.

See more: google.cloud.bigquery.model.Model.location

The model ID.

See more: google.cloud.bigquery.model.Model.model_id

Type of the model resource.

See more: google.cloud.bigquery.model.Model.model_type

Datetime at which the model was last modified (:data:None until set from the server).

See more: google.cloud.bigquery.model.Model.modified

URL path for the model's APIs.

See more: google.cloud.bigquery.model.Model.path

Project bound to the model.

See more: google.cloud.bigquery.model.Model.project

A model reference pointing to this model.

See more: google.cloud.bigquery.model.Model.reference

Information for all training runs in increasing order of start time.

See more: google.cloud.bigquery.model.Model.training_runs

The input feature columns that were used to train this model.

See more: google.cloud.bigquery.model.Model.transform_columns

str: ID of dataset containing the model.

See more: google.cloud.bigquery.model.ModelReference.dataset_id

str: The model ID.

See more: google.cloud.bigquery.model.ModelReference.model_id

URL path for the model's APIs.

See more: google.cloud.bigquery.model.ModelReference.path

str: Project bound to the model.

See more: google.cloud.bigquery.model.ModelReference.project

Name of the column.

See more: google.cloud.bigquery.model.TransformColumn.name

The SQL expression used in the column transform.

See more: google.cloud.bigquery.model.TransformColumn.transform_sql

Data type of the column after the transform.

See more: google.cloud.bigquery.model.TransformColumn.type_

Name of the property.

See more: google.cloud.bigquery.query.ConnectionProperty.key

Value of the property.

See more: google.cloud.bigquery.query.ConnectionProperty.value

The determinism of the UDF is unspecified.

See more: google.cloud.bigquery.routine.DeterminismLevel.DETERMINISM_LEVEL_UNSPECIFIED

The UDF is deterministic, meaning that 2 function calls with the same inputs always produce the same result, even across 2 query runs.

See more: google.cloud.bigquery.routine.DeterminismLevel.DETERMINISTIC

The UDF is not deterministic.

See more: google.cloud.bigquery.routine.DeterminismLevel.NOT_DETERMINISTIC

string: Fully qualified name of the user-provided connection object which holds the authentication information to send requests to the remote service.

See more: google.cloud.bigquery.routine.RemoteFunctionOptions.connection

string: Endpoint of the user-provided remote service.

See more: google.cloud.bigquery.routine.RemoteFunctionOptions.endpoint

int64: Max number of rows in each batch sent to the remote service.

See more: google.cloud.bigquery.routine.RemoteFunctionOptions.max_batching_rows

Dict[str, str]: User-defined context as a set of key/value pairs, which will be sent as function invocation context together with batched arguments in the requests to the remote service.

See more: google.cloud.bigquery.routine.RemoteFunctionOptions.user_defined_context

List[google.cloud.bigquery.routine.RoutineArgument]: Input/output argument of a function or a stored procedure.

See more: google.cloud.bigquery.routine.Routine.arguments

str: The body of the routine.

See more: google.cloud.bigquery.routine.Routine.body

Optional[datetime.datetime]: Datetime at which the routine was created (:data:None until set from the server).

See more: google.cloud.bigquery.routine.Routine.created

Optional[str]: If set to DATA_MASKING, the function is validated and made available as a masking function.

See more: google.cloud.bigquery.routine.Routine.data_governance_type

str: ID of dataset containing the routine.

See more: google.cloud.bigquery.routine.Routine.dataset_id

Optional[str]: Description of the routine (defaults to :data:None).

See more: google.cloud.bigquery.routine.Routine.description

Optional[str]: (experimental) The determinism level of the JavaScript UDF if defined.

See more: google.cloud.bigquery.routine.Routine.determinism_level

str: ETag for the resource (:data:None until set from the server).

See more: google.cloud.bigquery.routine.Routine.etag

List[str]: The path of the imported JavaScript libraries.

See more: google.cloud.bigquery.routine.Routine.imported_libraries

Optional[str]: The language of the routine.

See more: google.cloud.bigquery.routine.Routine.language

Optional[datetime.datetime]: Datetime at which the routine was last modified (:data:None until set from the server).

See more: google.cloud.bigquery.routine.Routine.modified

str: URL path for the routine's APIs.

See more: google.cloud.bigquery.routine.Routine.path

str: ID of the project containing the routine.

See more: google.cloud.bigquery.routine.Routine.project

google.cloud.bigquery.routine.RoutineReference: Reference describing the ID of this routine.

See more: google.cloud.bigquery.routine.Routine.reference

Optional[google.cloud.bigquery.routine.RemoteFunctionOptions]: Configures remote function options for a routine.

See more: google.cloud.bigquery.routine.Routine.remote_function_options

The return type of a Table Valued Function (TVF) routine.

See more: google.cloud.bigquery.routine.Routine.return_table_type

google.cloud.bigquery.StandardSqlDataType: Return type of the routine.

See more: google.cloud.bigquery.routine.Routine.return_type

str: The routine ID.

See more: google.cloud.bigquery.routine.Routine.routine_id

str: The fine-grained type of the routine.

See more: google.cloud.bigquery.routine.Routine.type_

Optional[google.cloud.bigquery.StandardSqlDataType]: Type of a variable, e.g., a function argument.

See more: google.cloud.bigquery.routine.RoutineArgument.data_type

Optional[str]: The kind of argument, for example FIXED_TYPE or ANY_TYPE.

See more: google.cloud.bigquery.routine.RoutineArgument.kind

Optional[str]: The input/output mode of the argument.

See more: google.cloud.bigquery.routine.RoutineArgument.mode

Optional[str]: Name of this argument.

See more: google.cloud.bigquery.routine.RoutineArgument.name

str: ID of dataset containing the routine.

See more: google.cloud.bigquery.routine.RoutineReference.dataset_id

str: URL path for the routine's APIs.

See more: google.cloud.bigquery.routine.RoutineReference.path

str: ID of the project containing the routine.

See more: google.cloud.bigquery.routine.RoutineReference.project

str: The routine ID.

See more: google.cloud.bigquery.routine.RoutineReference.routine_id

Tuple[str]: Policy tags associated with this definition.

See more: google.cloud.bigquery.schema.PolicyTagList.names

Optional[str] default value of a field, using an SQL expression.

See more: google.cloud.bigquery.schema.SchemaField.default_value_expression

Optional[str]: description for the field.

See more: google.cloud.bigquery.schema.SchemaField.description

str: The type of the field.

See more: google.cloud.bigquery.schema.SchemaField.field_type

Optional[tuple]: Subfields contained in this field.

See more: google.cloud.bigquery.schema.SchemaField.fields

bool: whether 'mode' is 'nullable'.

See more: google.cloud.bigquery.schema.SchemaField.is_nullable

Optional[int]: Maximum length for the STRING or BYTES field.

See more: google.cloud.bigquery.schema.SchemaField.max_length

Optional[str]: The mode of the field.

See more: google.cloud.bigquery.schema.SchemaField.mode

str: The name of the field.

See more: google.cloud.bigquery.schema.SchemaField.name

Optional[google.cloud.bigquery.schema.PolicyTagList]: Policy tag list definition for this field.

See more: google.cloud.bigquery.schema.SchemaField.policy_tags

Optional[int]: Precision (number of digits) for the NUMERIC field.

See more: google.cloud.bigquery.schema.SchemaField.precision

Optional[FieldElementType]: The subtype of the RANGE, if the type of this field is RANGE.

See more: google.cloud.bigquery.schema.SchemaField.range_element_type

Optional[int]: Scale (digits after decimal) for the NUMERIC field.

See more: google.cloud.bigquery.schema.SchemaField.scale

The type of the array's elements, if type_kind is ARRAY.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.array_element_type

The type of the range's elements, if type_kind = "RANGE".

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.range_element_type

The fields of this struct, in order, if type_kind is STRUCT.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.struct_type

The top level type of this field.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.type_kind

The name of this field.

See more: google.cloud.bigquery.standard_sql.StandardSqlField.name

The type of this parameter.

See more: google.cloud.bigquery.standard_sql.StandardSqlField.type

The fields in this struct.

See more: google.cloud.bigquery.standard_sql.StandardSqlStructType.fields

The columns in this table type.

See more: google.cloud.bigquery.standard_sql.StandardSqlTableType.columns

int: The end of range partitioning, exclusive.

See more: google.cloud.bigquery.table.PartitionRange.end

int: The width of each interval.

See more: google.cloud.bigquery.table.PartitionRange.interval

int: The start of range partitioning, inclusive.

See more: google.cloud.bigquery.table.PartitionRange.start

str: The table is partitioned by this field.

See more: google.cloud.bigquery.table.RangePartitioning.field

google.cloud.bigquery.table.PartitionRange: Defines the ranges for range partitioning.

See more: google.cloud.bigquery.table.RangePartitioning.range_

The client that created this iterator.

See more: google.cloud.bigquery.table.RowIterator.client

Callable to convert an item from the type in the raw API response into the native object.

See more: google.cloud.bigquery.table.RowIterator.item_to_value

ID of the query job (if applicable).

See more: google.cloud.bigquery.table.RowIterator.job_id

Location where the query executed (if applicable).

See more: google.cloud.bigquery.table.RowIterator.location

The maximum number of results to fetch.

See more: google.cloud.bigquery.table.RowIterator.max_results

The token for the next page of results.

See more: google.cloud.bigquery.table.RowIterator.next_page_token

If this RowIterator is the result of a DML query, the number of rows that were affected.

See more: google.cloud.bigquery.table.RowIterator.num_dml_affected_rows

The total number of results fetched so far.

See more: google.cloud.bigquery.table.RowIterator.num_results

The current page of results.

See more: google.cloud.bigquery.table.RowIterator.page_number

Iterator of pages in the response.

See more: google.cloud.bigquery.table.RowIterator.pages

GCP Project ID where these rows are read from.

See more: google.cloud.bigquery.table.RowIterator.project

[Preview] ID of a completed query.

See more: google.cloud.bigquery.table.RowIterator.query_id

List[google.cloud.bigquery.schema.SchemaField]: The subset of columns to be read from the table.

See more: google.cloud.bigquery.table.RowIterator.schema

int: The total number of rows in the table or query results.

See more: google.cloud.bigquery.table.RowIterator.total_rows

Information about the clone.

See more: google.cloud.bigquery.table.Table.clone_definition

Union[List[str], None]: Fields defining clustering for the table.

See more: google.cloud.bigquery.table.Table.clustering_fields

Union[datetime.datetime, None]: Datetime at which the table was created (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.created

ID of dataset containing the table.

See more: google.cloud.bigquery.table.Table.dataset_id

Union[str, None]: Description of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.description

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration: Custom encryption configuration for the table.

See more: google.cloud.bigquery.table.Table.encryption_configuration

Union[str, None]: ETag for the table resource (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.etag

Union[datetime.datetime, None]: Datetime at which the table will be deleted.

See more: google.cloud.bigquery.table.Table.expires

Union[google.cloud.bigquery.ExternalConfig, None]: Configuration for an external data source (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.external_data_configuration

Union[str, None]: Title of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.friendly_name

Union[str, None]: ID for the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.full_table_id

Dict[str, str]: Labels for the table.

See more: google.cloud.bigquery.table.Table.labels

Union[str, None]: Location in which the table is hosted.

See more: google.cloud.bigquery.table.Table.location

Union[datetime.datetime, None]: Datetime at which the table was last modified (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.modified

Optional[bool]: Enable automatic refresh of the materialized view when the base table is updated.

See more: google.cloud.bigquery.table.Table.mview_enable_refresh

Optional[datetime.datetime]: Datetime at which the materialized view was last refreshed (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.mview_last_refresh_time

Optional[str]: SQL query defining the table as a materialized view (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.mview_query

Optional[datetime.timedelta]: The maximum frequency at which this materialized view will be refreshed.

See more: google.cloud.bigquery.table.Table.mview_refresh_interval

Union[int, None]: The size of the table in bytes (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.num_bytes

Union[int, None]: The number of rows in the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.num_rows

Union[int, None]: Expiration time in milliseconds for a partition.

See more: google.cloud.bigquery.table.Table.partition_expiration

Union[str, None]: Time partitioning of the table if it is partitioned (Defaults to :data:None).

See more: google.cloud.bigquery.table.Table.partitioning_type

URL path for the table's APIs.

See more: google.cloud.bigquery.table.Table.path

Project bound to the table.

See more: google.cloud.bigquery.table.Table.project

Optional[google.cloud.bigquery.table.RangePartitioning]: Configures range-based partitioning for a table.

See more: google.cloud.bigquery.table.Table.range_partitioning

A xref_TableReference pointing to this table.

See more: google.cloud.bigquery.table.Table.reference

bool: If set to true, queries over the partitioned table require a partition filter that can be used for partition elimination to be specified.

See more: google.cloud.bigquery.table.Table.require_partition_filter

Sequence[Union[ xref_SchemaField, Mapping[str, Any] ]]: Table's schema.

See more: google.cloud.bigquery.table.Table.schema

Union[str, None]: URL for the table resource (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.self_link

Information about the snapshot.

See more: google.cloud.bigquery.table.Table.snapshot_definition

google.cloud.bigquery.StreamingBuffer: Information about a table's streaming buffer.

See more: google.cloud.bigquery.table.Table.streaming_buffer

Tables Primary Key and Foreign Key information.

See more: google.cloud.bigquery.table.Table.table_constraints

The table ID.

See more: google.cloud.bigquery.table.Table.table_id

Union[str, None]: The type of the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.table_type

Optional[google.cloud.bigquery.table.TimePartitioning]: Configures time-based partitioning for a table.

See more: google.cloud.bigquery.table.Table.time_partitioning

Union[str, None]: SQL query defining the table as a view (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.view_query

bool: Specifies whether to execute the view with Legacy or Standard SQL.

See more: google.cloud.bigquery.table.Table.view_use_legacy_sql

Union[List[str], None]: Fields defining clustering for the table.

See more: google.cloud.bigquery.table.TableListItem.clustering_fields

Union[datetime.datetime, None]: Datetime at which the table was created (:data:None until set from the server).

See more: google.cloud.bigquery.table.TableListItem.created

ID of dataset containing the table.

See more: google.cloud.bigquery.table.TableListItem.dataset_id

Union[datetime.datetime, None]: Datetime at which the table will be deleted.

See more: google.cloud.bigquery.table.TableListItem.expires

Union[str, None]: Title of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.TableListItem.friendly_name

Union[str, None]: ID for the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.TableListItem.full_table_id

Dict[str, str]: Labels for the table.

See more: google.cloud.bigquery.table.TableListItem.labels

Union[int, None]: Expiration time in milliseconds for a partition.

See more: google.cloud.bigquery.table.TableListItem.partition_expiration

Union[str, None]: Time partitioning of the table if it is partitioned (Defaults to :data:None).

See more: google.cloud.bigquery.table.TableListItem.partitioning_type

URL path for the table's APIs.

See more: google.cloud.bigquery.table.TableListItem.path

Project bound to the table.

See more: google.cloud.bigquery.table.TableListItem.project

A xref_TableReference pointing to this table.

See more: google.cloud.bigquery.table.TableListItem.reference

The table ID.

See more: google.cloud.bigquery.table.TableListItem.table_id

Union[str, None]: The type of the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.TableListItem.table_type

google.cloud.bigquery.table.TimePartitioning: Configures time-based partitioning for a table.

See more: google.cloud.bigquery.table.TableListItem.time_partitioning

bool: Specifies whether to execute the view with Legacy or Standard SQL.

See more: google.cloud.bigquery.table.TableListItem.view_use_legacy_sql

ID of dataset containing the table.

See more: google.cloud.bigquery.table.TableReference.dataset_id

URL path for the table's APIs.

See more: google.cloud.bigquery.table.TableReference.path

Project bound to the table.

See more: google.cloud.bigquery.table.TableReference.project

The table ID.

See more: google.cloud.bigquery.table.TableReference.table_id

int: Number of milliseconds to keep the storage for a partition.

See more: google.cloud.bigquery.table.TimePartitioning.expiration_ms

str: Field in the table to use for partitioning.

See more: google.cloud.bigquery.table.TimePartitioning.field

bool: Specifies whether partition filters are required for queries.

See more: google.cloud.bigquery.table.TimePartitioning.require_partition_filter

google.cloud.bigquery.table.TimePartitioningType: The type of time partitioning to use.

See more: google.cloud.bigquery.table.TimePartitioning.type_

Generates one partition per day.

See more: google.cloud.bigquery.table.TimePartitioningType.DAY

Generates one partition per hour.

See more: google.cloud.bigquery.table.TimePartitioningType.HOUR

Generates one partition per month.

See more: google.cloud.bigquery.table.TimePartitioningType.MONTH

Generates one partition per year.

See more: google.cloud.bigquery.table.TimePartitioningType.YEAR