Package Properties and Attributes (3.20.1)

Summary of entries of Properties and Attributes for bigquery.

google.cloud.bigquery.client.Client.SCOPE

The scopes required for authenticating as a BigQuery consumer.

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

google.cloud.bigquery.client.Client.default_load_job_config

google.cloud.bigquery.client.Client.default_query_job_config

Default QueryJobConfig or None.

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

google.cloud.bigquery.client.Client.location

Default location for jobs / datasets / tables.

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

google.cloud.bigquery.dataset.AccessEntry.dataset

API resource representation of a dataset reference.

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

google.cloud.bigquery.dataset.AccessEntry.dataset_target_types

Which resources that the dataset in this entry applies to.

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

google.cloud.bigquery.dataset.AccessEntry.domain

A domain to grant access to.

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

google.cloud.bigquery.dataset.AccessEntry.entity_id

The entity_id of the entry.

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

google.cloud.bigquery.dataset.AccessEntry.entity_type

The entity_type of the entry.

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

google.cloud.bigquery.dataset.AccessEntry.group_by_email

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

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

google.cloud.bigquery.dataset.AccessEntry.role

The role of the entry.

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

google.cloud.bigquery.dataset.AccessEntry.routine

API resource representation of a routine reference.

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

google.cloud.bigquery.dataset.AccessEntry.special_group

A special group to grant access to.

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

google.cloud.bigquery.dataset.AccessEntry.user_by_email

An email address of a user to grant access to.

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

google.cloud.bigquery.dataset.AccessEntry.view

API resource representation of a view reference.

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

google.cloud.bigquery.dataset.Dataset.access_entries

google.cloud.bigquery.dataset.Dataset.created

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

google.cloud.bigquery.dataset.Dataset.dataset_id

google.cloud.bigquery.dataset.Dataset.default_encryption_configuration

google.cloud.bigquery.dataset.Dataset.default_partition_expiration_ms

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

google.cloud.bigquery.dataset.Dataset.default_rounding_mode

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

google.cloud.bigquery.dataset.Dataset.default_table_expiration_ms

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

google.cloud.bigquery.dataset.Dataset.description

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

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

google.cloud.bigquery.dataset.Dataset.etag

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

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

google.cloud.bigquery.dataset.Dataset.friendly_name

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

google.cloud.bigquery.dataset.Dataset.full_dataset_id

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

google.cloud.bigquery.dataset.Dataset.is_case_insensitive

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

google.cloud.bigquery.dataset.Dataset.labels

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

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

google.cloud.bigquery.dataset.Dataset.location

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

google.cloud.bigquery.dataset.Dataset.max_time_travel_hours

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

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

google.cloud.bigquery.dataset.Dataset.modified

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

google.cloud.bigquery.dataset.Dataset.path

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

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

google.cloud.bigquery.dataset.Dataset.project

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

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

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

google.cloud.bigquery.dataset.Dataset.storage_billing_model

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

google.cloud.bigquery.dataset.DatasetListItem.dataset_id

google.cloud.bigquery.dataset.DatasetListItem.friendly_name

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

google.cloud.bigquery.dataset.DatasetListItem.full_dataset_id

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

google.cloud.bigquery.dataset.DatasetListItem.labels

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

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

google.cloud.bigquery.dataset.DatasetListItem.project

str: Project bound to the dataset.

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

google.cloud.bigquery.dataset.DatasetListItem.reference

google.cloud.bigquery.dataset.DatasetReference.dataset_id

google.cloud.bigquery.dataset.DatasetReference.path

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

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

google.cloud.bigquery.dataset.DatasetReference.project

str: Project ID of the dataset.

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

google.cloud.bigquery.dbapi.Cursor.query_job

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

google.cloud.bigquery.encryption_configuration.EncryptionConfiguration.kms_key_name

google.cloud.bigquery.enums.Compression.DEFLATE

Specifies DEFLATE format.

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

google.cloud.bigquery.enums.Compression.GZIP

Specifies GZIP format.

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

google.cloud.bigquery.enums.Compression.NONE

Specifies no compression.

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

google.cloud.bigquery.enums.Compression.SNAPPY

Specifies SNAPPY format.

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

google.cloud.bigquery.enums.Compression.ZSTD

Specifies ZSTD format.

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

google.cloud.bigquery.enums.CreateDisposition.CREATE_IF_NEEDED

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

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

google.cloud.bigquery.enums.CreateDisposition.CREATE_NEVER

The table must already exist.

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

google.cloud.bigquery.enums.DecimalTargetType.BIGNUMERIC

Decimal values could be converted to BIGNUMERIC type.

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

google.cloud.bigquery.enums.DecimalTargetType.NUMERIC

Decimal values could be converted to NUMERIC type.

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

google.cloud.bigquery.enums.DecimalTargetType.STRING

Decimal values could be converted to STRING type.

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

google.cloud.bigquery.enums.DefaultPandasDTypes.BOOL_DTYPE

Specifies default bool dtype.

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

google.cloud.bigquery.enums.DefaultPandasDTypes.DATE_DTYPE

Specifies default date dtype.

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

google.cloud.bigquery.enums.DefaultPandasDTypes.INT_DTYPE

Specifies default integer dtype.

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

google.cloud.bigquery.enums.DefaultPandasDTypes.TIME_DTYPE

Specifies default time dtype.

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

google.cloud.bigquery.enums.DestinationFormat.AVRO

Specifies Avro format.

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

google.cloud.bigquery.enums.DestinationFormat.CSV

Specifies CSV format.

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

google.cloud.bigquery.enums.DestinationFormat.NEWLINE_DELIMITED_JSON

Specifies newline delimited JSON format.

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

google.cloud.bigquery.enums.DestinationFormat.PARQUET

Specifies Parquet format.

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

google.cloud.bigquery.enums.DeterminismLevel.DETERMINISM_LEVEL_UNSPECIFIED

The determinism of the UDF is unspecified.

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

google.cloud.bigquery.enums.DeterminismLevel.DETERMINISTIC

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

google.cloud.bigquery.enums.DeterminismLevel.NOT_DETERMINISTIC

google.cloud.bigquery.enums.Encoding.ISO_8859_1

Specifies ISO-8859-1 encoding.

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

google.cloud.bigquery.enums.Encoding.UTF_8

Specifies UTF-8 encoding.

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

google.cloud.bigquery.enums.QueryApiMethod.INSERT

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

google.cloud.bigquery.enums.QueryApiMethod.QUERY

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

google.cloud.bigquery.enums.QueryPriority.BATCH

Specifies batch priority.

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

google.cloud.bigquery.enums.QueryPriority.INTERACTIVE

Specifies interactive priority.

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

google.cloud.bigquery.enums.SchemaUpdateOption.ALLOW_FIELD_ADDITION

Allow adding a nullable field to the schema.

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

google.cloud.bigquery.enums.SchemaUpdateOption.ALLOW_FIELD_RELAXATION

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

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

google.cloud.bigquery.enums.SourceFormat.AVRO

Specifies Avro format.

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

google.cloud.bigquery.enums.SourceFormat.CSV

Specifies CSV format.

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

google.cloud.bigquery.enums.SourceFormat.DATASTORE_BACKUP

Specifies datastore backup format.

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

google.cloud.bigquery.enums.SourceFormat.NEWLINE_DELIMITED_JSON

Specifies newline delimited JSON format.

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

google.cloud.bigquery.enums.SourceFormat.ORC

Specifies Orc format.

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

google.cloud.bigquery.enums.SourceFormat.PARQUET

Specifies Parquet format.

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

google.cloud.bigquery.enums.WriteDisposition.WRITE_APPEND

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

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

google.cloud.bigquery.enums.WriteDisposition.WRITE_EMPTY

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

google.cloud.bigquery.enums.WriteDisposition.WRITE_TRUNCATE

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

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

google.cloud.bigquery.external_config.BigtableColumn.encoding

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

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

google.cloud.bigquery.external_config.BigtableColumn.field_name

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

google.cloud.bigquery.external_config.BigtableColumn.only_read_latest

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

google.cloud.bigquery.external_config.BigtableColumn.qualifier_encoded

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

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

google.cloud.bigquery.external_config.BigtableColumn.qualifier_string

str: A valid UTF-8 string qualifier.

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

google.cloud.bigquery.external_config.BigtableColumn.type_

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

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

google.cloud.bigquery.external_config.BigtableColumnFamily.columns

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

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

google.cloud.bigquery.external_config.BigtableColumnFamily.encoding

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

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

google.cloud.bigquery.external_config.BigtableColumnFamily.family_id

str: Identifier of the column family.

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

google.cloud.bigquery.external_config.BigtableColumnFamily.only_read_latest

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

google.cloud.bigquery.external_config.BigtableColumnFamily.type_

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

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

google.cloud.bigquery.external_config.BigtableOptions.column_families

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

google.cloud.bigquery.external_config.BigtableOptions.ignore_unspecified_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

google.cloud.bigquery.external_config.BigtableOptions.read_rowkey_as_string

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

google.cloud.bigquery.external_config.CSVOptions.allow_jagged_rows

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

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

google.cloud.bigquery.external_config.CSVOptions.allow_quoted_newlines

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

google.cloud.bigquery.external_config.CSVOptions.encoding

str: The character encoding of the data.

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

google.cloud.bigquery.external_config.CSVOptions.field_delimiter

str: The separator for fields in a CSV file.

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

google.cloud.bigquery.external_config.CSVOptions.preserve_ascii_control_characters

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

google.cloud.bigquery.external_config.CSVOptions.quote_character

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

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

google.cloud.bigquery.external_config.CSVOptions.skip_leading_rows

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

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

google.cloud.bigquery.external_config.ExternalConfig.autodetect

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

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

google.cloud.bigquery.external_config.ExternalConfig.avro_options

Additional properties to set if sourceFormat is set to AVRO.

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

google.cloud.bigquery.external_config.ExternalConfig.bigtable_options

Additional properties to set if sourceFormat is set to BIGTABLE.

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

google.cloud.bigquery.external_config.ExternalConfig.compression

str: The compression type of the data source.

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

google.cloud.bigquery.external_config.ExternalConfig.connection_id

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

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

google.cloud.bigquery.external_config.ExternalConfig.csv_options

Additional properties to set if sourceFormat is set to CSV.

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

google.cloud.bigquery.external_config.ExternalConfig.decimal_target_types

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

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

google.cloud.bigquery.external_config.ExternalConfig.google_sheets_options

Additional properties to set if sourceFormat is set to GOOGLE_SHEETS.

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

google.cloud.bigquery.external_config.ExternalConfig.hive_partitioning

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

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

google.cloud.bigquery.external_config.ExternalConfig.ignore_unknown_values

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

google.cloud.bigquery.external_config.ExternalConfig.max_bad_records

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

google.cloud.bigquery.external_config.ExternalConfig.options

google.cloud.bigquery.external_config.ExternalConfig.parquet_options

Additional properties to set if sourceFormat is set to PARQUET.

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

google.cloud.bigquery.external_config.ExternalConfig.reference_file_schema_uri

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

google.cloud.bigquery.external_config.ExternalConfig.schema

google.cloud.bigquery.external_config.ExternalConfig.source_format

.external_config.ExternalSourceFormat: Format of external source.

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

google.cloud.bigquery.external_config.ExternalConfig.source_uris

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

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

google.cloud.bigquery.external_config.ExternalSourceFormat.AVRO

google.cloud.bigquery.external_config.ExternalSourceFormat.BIGTABLE

google.cloud.bigquery.external_config.ExternalSourceFormat.CSV

google.cloud.bigquery.external_config.ExternalSourceFormat.DATASTORE_BACKUP

google.cloud.bigquery.external_config.ExternalSourceFormat.GOOGLE_SHEETS

google.cloud.bigquery.external_config.ExternalSourceFormat.NEWLINE_DELIMITED_JSON

google.cloud.bigquery.external_config.ExternalSourceFormat.ORC

google.cloud.bigquery.external_config.ExternalSourceFormat.PARQUET

google.cloud.bigquery.external_config.GoogleSheetsOptions.range

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

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

google.cloud.bigquery.external_config.GoogleSheetsOptions.skip_leading_rows

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

google.cloud.bigquery.external_config.HivePartitioningOptions.mode

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

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

google.cloud.bigquery.external_config.HivePartitioningOptions.require_partition_filter

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

google.cloud.bigquery.external_config.HivePartitioningOptions.source_uri_prefix

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

google.cloud.bigquery.format_options.AvroOptions.use_avro_logical_types

[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

google.cloud.bigquery.format_options.ParquetOptions.enable_list_inference

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

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

google.cloud.bigquery.format_options.ParquetOptions.enum_as_string

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

google.cloud.bigquery.job.Compression.DEFLATE

Specifies DEFLATE format.

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

google.cloud.bigquery.job.Compression.GZIP

Specifies GZIP format.

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

google.cloud.bigquery.job.Compression.NONE

Specifies no compression.

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

google.cloud.bigquery.job.Compression.SNAPPY

Specifies SNAPPY format.

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

google.cloud.bigquery.job.Compression.ZSTD

Specifies ZSTD format.

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

google.cloud.bigquery.job.CopyJob.configuration

The configuration for this copy job.

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

google.cloud.bigquery.job.CopyJob.create_disposition

google.cloud.bigquery.job.CopyJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.CopyJob.destination

google.cloud.bigquery.job.CopyJob.destination_encryption_configuration

google.cloud.bigquery.job.CopyJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.CopyJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.CopyJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.CopyJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.CopyJob.job_id

str: ID of the job.

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

google.cloud.bigquery.job.CopyJob.job_type

google.cloud.bigquery.job.CopyJob.labels

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

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

google.cloud.bigquery.job.CopyJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.CopyJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.CopyJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.CopyJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.CopyJob.project

Project bound to the job.

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

google.cloud.bigquery.job.CopyJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.CopyJob.script_statistics

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

google.cloud.bigquery.job.CopyJob.session_info

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

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

google.cloud.bigquery.job.CopyJob.sources

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

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

google.cloud.bigquery.job.CopyJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.CopyJob.state

Status of the job.

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

google.cloud.bigquery.job.CopyJob.transaction_info

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

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

google.cloud.bigquery.job.CopyJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.job.CopyJob.write_disposition

google.cloud.bigquery.job.CopyJobConfig.create_disposition

google.cloud.bigquery.job.CopyJobConfig.destination_encryption_configuration

google.cloud.bigquery.job.CopyJobConfig.destination_expiration_time

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

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

google.cloud.bigquery.job.CopyJobConfig.job_timeout_ms

google.cloud.bigquery.job.CopyJobConfig.labels

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

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

google.cloud.bigquery.job.CopyJobConfig.operation_type

The operation to perform with this copy job.

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

google.cloud.bigquery.job.CopyJobConfig.write_disposition

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

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

google.cloud.bigquery.job.CreateDisposition.CREATE_IF_NEEDED

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

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

google.cloud.bigquery.job.CreateDisposition.CREATE_NEVER

The table must already exist.

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

google.cloud.bigquery.job.DestinationFormat.AVRO

Specifies Avro format.

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

google.cloud.bigquery.job.DestinationFormat.CSV

Specifies CSV format.

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

google.cloud.bigquery.job.DestinationFormat.NEWLINE_DELIMITED_JSON

Specifies newline delimited JSON format.

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

google.cloud.bigquery.job.DestinationFormat.PARQUET

Specifies Parquet format.

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

google.cloud.bigquery.job.DmlStats.deleted_row_count

Number of deleted rows.

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

google.cloud.bigquery.job.DmlStats.inserted_row_count

Number of inserted rows.

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

google.cloud.bigquery.job.DmlStats.updated_row_count

Number of updated rows.

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

google.cloud.bigquery.job.Encoding.ISO_8859_1

Specifies ISO-8859-1 encoding.

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

google.cloud.bigquery.job.Encoding.UTF_8

Specifies UTF-8 encoding.

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

google.cloud.bigquery.job.ExtractJob.compression

google.cloud.bigquery.job.ExtractJob.configuration

The configuration for this extract job.

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

google.cloud.bigquery.job.ExtractJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.ExtractJob.destination_format

google.cloud.bigquery.job.ExtractJob.destination_uri_file_counts

Return file counts from job statistics, if present.

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

google.cloud.bigquery.job.ExtractJob.destination_uris

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

google.cloud.bigquery.job.ExtractJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.ExtractJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.ExtractJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.ExtractJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.ExtractJob.field_delimiter

google.cloud.bigquery.job.ExtractJob.job_id

str: ID of the job.

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

google.cloud.bigquery.job.ExtractJob.job_type

google.cloud.bigquery.job.ExtractJob.labels

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

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

google.cloud.bigquery.job.ExtractJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.ExtractJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.ExtractJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.ExtractJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.ExtractJob.print_header

google.cloud.bigquery.job.ExtractJob.project

Project bound to the job.

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

google.cloud.bigquery.job.ExtractJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.ExtractJob.script_statistics

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

google.cloud.bigquery.job.ExtractJob.session_info

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

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

google.cloud.bigquery.job.ExtractJob.source

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

google.cloud.bigquery.job.ExtractJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.ExtractJob.state

Status of the job.

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

google.cloud.bigquery.job.ExtractJob.transaction_info

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

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

google.cloud.bigquery.job.ExtractJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.job.ExtractJobConfig.compression

google.cloud.bigquery.job.ExtractJobConfig.destination_format

google.cloud.bigquery.job.ExtractJobConfig.field_delimiter

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

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

google.cloud.bigquery.job.ExtractJobConfig.job_timeout_ms

google.cloud.bigquery.job.ExtractJobConfig.labels

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

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

google.cloud.bigquery.job.ExtractJobConfig.print_header

bool: Print a header row in the exported data.

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

google.cloud.bigquery.job.ExtractJobConfig.use_avro_logical_types

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

google.cloud.bigquery.job.LoadJob.allow_jagged_rows

google.cloud.bigquery.job.LoadJob.allow_quoted_newlines

google.cloud.bigquery.job.LoadJob.autodetect

google.cloud.bigquery.job.LoadJob.clustering_fields

google.cloud.bigquery.job.LoadJob.configuration

The configuration for this load job.

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

google.cloud.bigquery.job.LoadJob.connection_properties

google.cloud.bigquery.job.LoadJob.create_disposition

google.cloud.bigquery.job.LoadJob.create_session

google.cloud.bigquery.job.LoadJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.LoadJob.destination

google.cloud.bigquery.job.LoadJob.destination_encryption_configuration

google.cloud.bigquery.job.LoadJob.destination_table_description

Optional[str] name given to destination table.

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

google.cloud.bigquery.job.LoadJob.destination_table_friendly_name

Optional[str] name given to destination table.

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

google.cloud.bigquery.job.LoadJob.encoding

google.cloud.bigquery.job.LoadJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.LoadJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.LoadJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.LoadJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.LoadJob.field_delimiter

google.cloud.bigquery.job.LoadJob.ignore_unknown_values

google.cloud.bigquery.job.LoadJob.input_file_bytes

Count of bytes loaded from source files.

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

google.cloud.bigquery.job.LoadJob.input_files

Count of source files.

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

google.cloud.bigquery.job.LoadJob.job_id

str: ID of the job.

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

google.cloud.bigquery.job.LoadJob.job_type

google.cloud.bigquery.job.LoadJob.labels

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

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

google.cloud.bigquery.job.LoadJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.LoadJob.max_bad_records

google.cloud.bigquery.job.LoadJob.null_marker

google.cloud.bigquery.job.LoadJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.LoadJob.output_bytes

Count of bytes saved to destination table.

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

google.cloud.bigquery.job.LoadJob.output_rows

Count of rows saved to destination table.

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

google.cloud.bigquery.job.LoadJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.LoadJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.LoadJob.project

Project bound to the job.

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

google.cloud.bigquery.job.LoadJob.quote_character

google.cloud.bigquery.job.LoadJob.range_partitioning

google.cloud.bigquery.job.LoadJob.reference_file_schema_uri

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

google.cloud.bigquery.job.LoadJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.LoadJob.schema

google.cloud.bigquery.job.LoadJob.schema_update_options

google.cloud.bigquery.job.LoadJob.script_statistics

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

google.cloud.bigquery.job.LoadJob.session_info

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

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

google.cloud.bigquery.job.LoadJob.skip_leading_rows

google.cloud.bigquery.job.LoadJob.source_format

google.cloud.bigquery.job.LoadJob.source_uris

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

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

google.cloud.bigquery.job.LoadJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.LoadJob.state

Status of the job.

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

google.cloud.bigquery.job.LoadJob.time_partitioning

google.cloud.bigquery.job.LoadJob.transaction_info

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

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

google.cloud.bigquery.job.LoadJob.use_avro_logical_types

google.cloud.bigquery.job.LoadJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.job.LoadJob.write_disposition

google.cloud.bigquery.job.LoadJobConfig.allow_jagged_rows

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

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

google.cloud.bigquery.job.LoadJobConfig.allow_quoted_newlines

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

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

google.cloud.bigquery.job.LoadJobConfig.autodetect

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

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

google.cloud.bigquery.job.LoadJobConfig.clustering_fields

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

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

google.cloud.bigquery.job.LoadJobConfig.connection_properties

google.cloud.bigquery.job.LoadJobConfig.create_disposition

google.cloud.bigquery.job.LoadJobConfig.create_session

[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

google.cloud.bigquery.job.LoadJobConfig.decimal_target_types

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

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

google.cloud.bigquery.job.LoadJobConfig.destination_encryption_configuration

google.cloud.bigquery.job.LoadJobConfig.destination_table_description

Optional[str]: Description of the destination table.

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

google.cloud.bigquery.job.LoadJobConfig.destination_table_friendly_name

Optional[str]: Name given to destination table.

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

google.cloud.bigquery.job.LoadJobConfig.encoding

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

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

google.cloud.bigquery.job.LoadJobConfig.field_delimiter

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

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

google.cloud.bigquery.job.LoadJobConfig.hive_partitioning

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

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

google.cloud.bigquery.job.LoadJobConfig.ignore_unknown_values

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

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

google.cloud.bigquery.job.LoadJobConfig.job_timeout_ms

google.cloud.bigquery.job.LoadJobConfig.json_extension

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

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

google.cloud.bigquery.job.LoadJobConfig.labels

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

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

google.cloud.bigquery.job.LoadJobConfig.max_bad_records

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

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

google.cloud.bigquery.job.LoadJobConfig.null_marker

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

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

google.cloud.bigquery.job.LoadJobConfig.parquet_options

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

google.cloud.bigquery.job.LoadJobConfig.preserve_ascii_control_characters

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

google.cloud.bigquery.job.LoadJobConfig.projection_fields

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

google.cloud.bigquery.job.LoadJobConfig.quote_character

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

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

google.cloud.bigquery.job.LoadJobConfig.range_partitioning

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

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

google.cloud.bigquery.job.LoadJobConfig.reference_file_schema_uri

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

google.cloud.bigquery.job.LoadJobConfig.schema

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

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

google.cloud.bigquery.job.LoadJobConfig.schema_update_options

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

google.cloud.bigquery.job.LoadJobConfig.skip_leading_rows

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

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

google.cloud.bigquery.job.LoadJobConfig.source_format

google.cloud.bigquery.job.LoadJobConfig.time_partitioning

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

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

google.cloud.bigquery.job.LoadJobConfig.use_avro_logical_types

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

google.cloud.bigquery.job.LoadJobConfig.write_disposition

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

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

google.cloud.bigquery.job.OperationType.CLONE

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

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

google.cloud.bigquery.job.OperationType.COPY

The source and destination table have the same table type.

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

google.cloud.bigquery.job.OperationType.OPERATION_TYPE_UNSPECIFIED

google.cloud.bigquery.job.OperationType.RESTORE

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

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

google.cloud.bigquery.job.OperationType.SNAPSHOT

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

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

google.cloud.bigquery.job.QueryJob.allow_large_results

google.cloud.bigquery.job.QueryJob.billing_tier

Return billing tier from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.cache_hit

Return whether or not query results were served from cache.

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

google.cloud.bigquery.job.QueryJob.clustering_fields

google.cloud.bigquery.job.QueryJob.configuration

The configuration for this query job.

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

google.cloud.bigquery.job.QueryJob.connection_properties

google.cloud.bigquery.job.QueryJob.create_disposition

google.cloud.bigquery.job.QueryJob.create_session

google.cloud.bigquery.job.QueryJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.QueryJob.ddl_operation_performed

Optional[str]: Return the DDL operation performed.

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

google.cloud.bigquery.job.QueryJob.ddl_target_routine

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

google.cloud.bigquery.job.QueryJob.ddl_target_table

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

google.cloud.bigquery.job.QueryJob.default_dataset

google.cloud.bigquery.job.QueryJob.destination

google.cloud.bigquery.job.QueryJob.destination_encryption_configuration

google.cloud.bigquery.job.QueryJob.dry_run

google.cloud.bigquery.job.QueryJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.QueryJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.QueryJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.QueryJob.estimated_bytes_processed

Return the estimated number of bytes processed by the query.

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

google.cloud.bigquery.job.QueryJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.QueryJob.flatten_results

google.cloud.bigquery.job.QueryJob.job_id

str: ID of the job.

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

google.cloud.bigquery.job.QueryJob.job_type

google.cloud.bigquery.job.QueryJob.labels

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

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

google.cloud.bigquery.job.QueryJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.QueryJob.maximum_billing_tier

google.cloud.bigquery.job.QueryJob.maximum_bytes_billed

google.cloud.bigquery.job.QueryJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.QueryJob.num_dml_affected_rows

Return the number of DML rows affected by the job.

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

google.cloud.bigquery.job.QueryJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.QueryJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.QueryJob.priority

google.cloud.bigquery.job.QueryJob.project

Project bound to the job.

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

google.cloud.bigquery.job.QueryJob.query

str: The query text used in this query job.

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

google.cloud.bigquery.job.QueryJob.query_id

[Preview] ID of a completed query.

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

google.cloud.bigquery.job.QueryJob.query_parameters

google.cloud.bigquery.job.QueryJob.query_plan

Return query plan from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.range_partitioning

google.cloud.bigquery.job.QueryJob.referenced_tables

Return referenced tables from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.QueryJob.schema

The schema of the results.

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

google.cloud.bigquery.job.QueryJob.schema_update_options

google.cloud.bigquery.job.QueryJob.script_statistics

Statistics for a child job of a script.

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

google.cloud.bigquery.job.QueryJob.search_stats

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

google.cloud.bigquery.job.QueryJob.session_info

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

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

google.cloud.bigquery.job.QueryJob.slot_millis

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

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

google.cloud.bigquery.job.QueryJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.QueryJob.state

Status of the job.

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

google.cloud.bigquery.job.QueryJob.statement_type

Return statement type from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.table_definitions

google.cloud.bigquery.job.QueryJob.time_partitioning

google.cloud.bigquery.job.QueryJob.timeline

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

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

google.cloud.bigquery.job.QueryJob.total_bytes_billed

Return total bytes billed from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.total_bytes_processed

Return total bytes processed from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.transaction_info

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

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

google.cloud.bigquery.job.QueryJob.udf_resources

google.cloud.bigquery.job.QueryJob.undeclared_query_parameters

Return undeclared query parameters from job statistics, if present.

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

google.cloud.bigquery.job.QueryJob.use_legacy_sql

google.cloud.bigquery.job.QueryJob.use_query_cache

google.cloud.bigquery.job.QueryJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.job.QueryJob.write_disposition

google.cloud.bigquery.job.QueryJobConfig.allow_large_results

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

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

google.cloud.bigquery.job.QueryJobConfig.clustering_fields

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

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

google.cloud.bigquery.job.QueryJobConfig.connection_properties

google.cloud.bigquery.job.QueryJobConfig.create_disposition

google.cloud.bigquery.job.QueryJobConfig.create_session

[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.job.QueryJobConfig.default_dataset

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.job.QueryJobConfig.destination

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.job.QueryJobConfig.destination_encryption_configuration

google.cloud.bigquery.job.QueryJobConfig.dry_run

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

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

google.cloud.bigquery.job.QueryJobConfig.flatten_results

bool: Flatten nested/repeated fields in results.

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

google.cloud.bigquery.job.QueryJobConfig.job_timeout_ms

google.cloud.bigquery.job.QueryJobConfig.labels

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

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

google.cloud.bigquery.job.QueryJobConfig.maximum_billing_tier

google.cloud.bigquery.job.QueryJobConfig.maximum_bytes_billed

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.QueryJobConfig.priority

google.cloud.bigquery.job.QueryJobConfig.query_parameters

google.cloud.bigquery.job.QueryJobConfig.range_partitioning

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

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

google.cloud.bigquery.job.QueryJobConfig.schema_update_options

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

google.cloud.bigquery.job.QueryJobConfig.script_options

Options controlling the execution of scripts.

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

google.cloud.bigquery.job.QueryJobConfig.table_definitions

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

google.cloud.bigquery.job.QueryJobConfig.time_partitioning

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

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

google.cloud.bigquery.job.QueryJobConfig.udf_resources

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

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

google.cloud.bigquery.job.QueryJobConfig.use_legacy_sql

bool: Use legacy SQL syntax.

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

google.cloud.bigquery.job.QueryJobConfig.use_query_cache

bool: Look for the query result in the cache.

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

google.cloud.bigquery.job.QueryJobConfig.write_disposition

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

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

google.cloud.bigquery.job.QueryPlanEntry.completed_parallel_inputs

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

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

google.cloud.bigquery.job.QueryPlanEntry.compute_ms_avg

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

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

google.cloud.bigquery.job.QueryPlanEntry.compute_ms_max

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

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

google.cloud.bigquery.job.QueryPlanEntry.compute_ratio_avg

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

google.cloud.bigquery.job.QueryPlanEntry.compute_ratio_max

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

google.cloud.bigquery.job.QueryPlanEntry.end

Optional[Datetime]: Datetime when the stage ended.

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

google.cloud.bigquery.job.QueryPlanEntry.entry_id

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

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

google.cloud.bigquery.job.QueryPlanEntry.input_stages

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

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

google.cloud.bigquery.job.QueryPlanEntry.name

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

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

google.cloud.bigquery.job.QueryPlanEntry.parallel_inputs

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

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

google.cloud.bigquery.job.QueryPlanEntry.read_ms_avg

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

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

google.cloud.bigquery.job.QueryPlanEntry.read_ms_max

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

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

google.cloud.bigquery.job.QueryPlanEntry.read_ratio_avg

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

google.cloud.bigquery.job.QueryPlanEntry.read_ratio_max

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

google.cloud.bigquery.job.QueryPlanEntry.records_read

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

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

google.cloud.bigquery.job.QueryPlanEntry.records_written

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

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

google.cloud.bigquery.job.QueryPlanEntry.shuffle_output_bytes

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

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

google.cloud.bigquery.job.QueryPlanEntry.shuffle_output_bytes_spilled

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

google.cloud.bigquery.job.QueryPlanEntry.slot_ms

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

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

google.cloud.bigquery.job.QueryPlanEntry.start

Optional[Datetime]: Datetime when the stage started.

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

google.cloud.bigquery.job.QueryPlanEntry.status

Optional[str]: status of this stage.

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

google.cloud.bigquery.job.QueryPlanEntry.steps

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

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

google.cloud.bigquery.job.QueryPlanEntry.wait_ms_avg

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

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

google.cloud.bigquery.job.QueryPlanEntry.wait_ms_max

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

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

google.cloud.bigquery.job.QueryPlanEntry.wait_ratio_avg

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

google.cloud.bigquery.job.QueryPlanEntry.wait_ratio_max

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

google.cloud.bigquery.job.QueryPlanEntry.write_ms_avg

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

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

google.cloud.bigquery.job.QueryPlanEntry.write_ms_max

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

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

google.cloud.bigquery.job.QueryPlanEntry.write_ratio_avg

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

google.cloud.bigquery.job.QueryPlanEntry.write_ratio_max

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

google.cloud.bigquery.job.QueryPriority.BATCH

Specifies batch priority.

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

google.cloud.bigquery.job.QueryPriority.INTERACTIVE

Specifies interactive priority.

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

google.cloud.bigquery.job.ReservationUsage.name

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

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

google.cloud.bigquery.job.ReservationUsage.slot_ms

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

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

google.cloud.bigquery.job.SchemaUpdateOption.ALLOW_FIELD_ADDITION

Allow adding a nullable field to the schema.

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

google.cloud.bigquery.job.SchemaUpdateOption.ALLOW_FIELD_RELAXATION

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

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

google.cloud.bigquery.job.ScriptOptions.key_result_statement

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

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

google.cloud.bigquery.job.ScriptOptions.statement_byte_budget

Limit on the number of bytes billed per statement.

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

google.cloud.bigquery.job.ScriptOptions.statement_timeout_ms

Timeout period for each statement in a script.

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

google.cloud.bigquery.job.ScriptStackFrame.end_column

int: One-based end column.

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

google.cloud.bigquery.job.ScriptStackFrame.end_line

int: One-based end line.

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

google.cloud.bigquery.job.ScriptStackFrame.procedure_id

Optional[str]: Name of the active procedure.

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

google.cloud.bigquery.job.ScriptStackFrame.start_column

int: One-based start column.

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

google.cloud.bigquery.job.ScriptStackFrame.start_line

int: One-based start line.

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

google.cloud.bigquery.job.ScriptStackFrame.text

str: Text of the current statement/expression.

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

google.cloud.bigquery.job.ScriptStatistics.evaluation_kind

str: Indicates the type of child job.

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

google.cloud.bigquery.job.ScriptStatistics.stack_frames

Stack trace where the current evaluation happened.

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

google.cloud.bigquery.job.SourceFormat.AVRO

Specifies Avro format.

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

google.cloud.bigquery.job.SourceFormat.CSV

Specifies CSV format.

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

google.cloud.bigquery.job.SourceFormat.DATASTORE_BACKUP

Specifies datastore backup format.

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

google.cloud.bigquery.job.SourceFormat.NEWLINE_DELIMITED_JSON

Specifies newline delimited JSON format.

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

google.cloud.bigquery.job.SourceFormat.ORC

Specifies Orc format.

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

google.cloud.bigquery.job.SourceFormat.PARQUET

Specifies Parquet format.

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

google.cloud.bigquery.job.TimelineEntry.active_units

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

google.cloud.bigquery.job.TimelineEntry.completed_units

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

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

google.cloud.bigquery.job.TimelineEntry.elapsed_ms

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

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

google.cloud.bigquery.job.TimelineEntry.pending_units

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

google.cloud.bigquery.job.TimelineEntry.slot_millis

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

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

google.cloud.bigquery.job.TransactionInfo.transaction_id

google.cloud.bigquery.job.UnknownJob.configuration

Job-type specific configurtion.

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

google.cloud.bigquery.job.UnknownJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.UnknownJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.UnknownJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.UnknownJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.UnknownJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.UnknownJob.job_id

str: ID of the job.

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

google.cloud.bigquery.job.UnknownJob.job_type

google.cloud.bigquery.job.UnknownJob.labels

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

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

google.cloud.bigquery.job.UnknownJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.UnknownJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.UnknownJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.UnknownJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.UnknownJob.project

Project bound to the job.

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

google.cloud.bigquery.job.UnknownJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.UnknownJob.script_statistics

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

google.cloud.bigquery.job.UnknownJob.session_info

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

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

google.cloud.bigquery.job.UnknownJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.UnknownJob.state

Status of the job.

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

google.cloud.bigquery.job.UnknownJob.transaction_info

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

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

google.cloud.bigquery.job.UnknownJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.job.WriteDisposition.WRITE_APPEND

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

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

google.cloud.bigquery.job.WriteDisposition.WRITE_EMPTY

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

google.cloud.bigquery.job.WriteDisposition.WRITE_TRUNCATE

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

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

google.cloud.bigquery.job.base.ReservationUsage.name

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

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

google.cloud.bigquery.job.base.ReservationUsage.slot_ms

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

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

google.cloud.bigquery.job.base.ScriptStackFrame.end_column

google.cloud.bigquery.job.base.ScriptStackFrame.end_line

google.cloud.bigquery.job.base.ScriptStackFrame.procedure_id

Optional[str]: Name of the active procedure.

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

google.cloud.bigquery.job.base.ScriptStackFrame.start_column

int: One-based start column.

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

google.cloud.bigquery.job.base.ScriptStackFrame.start_line

google.cloud.bigquery.job.base.ScriptStackFrame.text

str: Text of the current statement/expression.

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

google.cloud.bigquery.job.base.ScriptStatistics.evaluation_kind

str: Indicates the type of child job.

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

google.cloud.bigquery.job.base.ScriptStatistics.stack_frames

Stack trace where the current evaluation happened.

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

google.cloud.bigquery.job.base.SessionInfo.session_id

google.cloud.bigquery.job.base.TransactionInfo.transaction_id

google.cloud.bigquery.job.base.UnknownJob.configuration

Job-type specific configurtion.

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

google.cloud.bigquery.job.base.UnknownJob.created

Datetime at which the job was created.

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

google.cloud.bigquery.job.base.UnknownJob.ended

Datetime at which the job finished.

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

google.cloud.bigquery.job.base.UnknownJob.error_result

Error information about the job as a whole.

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

google.cloud.bigquery.job.base.UnknownJob.errors

Information about individual errors generated by the job.

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

google.cloud.bigquery.job.base.UnknownJob.etag

ETag for the job resource.

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

google.cloud.bigquery.job.base.UnknownJob.job_id

google.cloud.bigquery.job.base.UnknownJob.job_type

google.cloud.bigquery.job.base.UnknownJob.labels

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

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

google.cloud.bigquery.job.base.UnknownJob.location

str: Location where the job runs.

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

google.cloud.bigquery.job.base.UnknownJob.num_child_jobs

The number of child jobs executed.

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

google.cloud.bigquery.job.base.UnknownJob.parent_job_id

Return the ID of the parent job.

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

google.cloud.bigquery.job.base.UnknownJob.path

URL path for the job's APIs.

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

google.cloud.bigquery.job.base.UnknownJob.project

Project bound to the job.

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

google.cloud.bigquery.job.base.UnknownJob.reservation_usage

Job resource usage breakdown by reservation.

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

google.cloud.bigquery.job.base.UnknownJob.script_statistics

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

google.cloud.bigquery.job.base.UnknownJob.session_info

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

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

google.cloud.bigquery.job.base.UnknownJob.started

Datetime at which the job was started.

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

google.cloud.bigquery.job.base.UnknownJob.state

google.cloud.bigquery.job.base.UnknownJob.transaction_info

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

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

google.cloud.bigquery.job.base.UnknownJob.user_email

E-mail address of user who submitted the job.

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

google.cloud.bigquery.model.Model.best_trial_id

The best trial_id across all training runs.

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

google.cloud.bigquery.model.Model.created

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

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

google.cloud.bigquery.model.Model.dataset_id

ID of dataset containing the model.

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

google.cloud.bigquery.model.Model.description

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

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

google.cloud.bigquery.model.Model.encryption_configuration

Custom encryption configuration for the model.

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

google.cloud.bigquery.model.Model.etag

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

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

google.cloud.bigquery.model.Model.expires

The datetime when this model expires.

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

google.cloud.bigquery.model.Model.feature_columns

Input feature columns that were used to train this model.

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

google.cloud.bigquery.model.Model.friendly_name

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

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

google.cloud.bigquery.model.Model.label_columns

Label columns that were used to train this model.

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

google.cloud.bigquery.model.Model.labels

Labels for the table.

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

google.cloud.bigquery.model.Model.location

The geographic location where the model resides.

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

google.cloud.bigquery.model.Model.model_id

google.cloud.bigquery.model.Model.model_type

Type of the model resource.

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

google.cloud.bigquery.model.Model.modified

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

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

google.cloud.bigquery.model.Model.path

URL path for the model's APIs.

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

google.cloud.bigquery.model.Model.project

Project bound to the model.

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

google.cloud.bigquery.model.Model.reference

A model reference pointing to this model.

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

google.cloud.bigquery.model.Model.training_runs

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

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

google.cloud.bigquery.model.Model.transform_columns

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

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

google.cloud.bigquery.model.ModelReference.dataset_id

str: ID of dataset containing the model.

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

google.cloud.bigquery.model.ModelReference.model_id

google.cloud.bigquery.model.ModelReference.path

URL path for the model's APIs.

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

google.cloud.bigquery.model.ModelReference.project

str: Project bound to the model.

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

google.cloud.bigquery.model.TransformColumn.name

google.cloud.bigquery.model.TransformColumn.transform_sql

The SQL expression used in the column transform.

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

google.cloud.bigquery.model.TransformColumn.type_

Data type of the column after the transform.

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

google.cloud.bigquery.query.ConnectionProperty.key

google.cloud.bigquery.query.ConnectionProperty.value

google.cloud.bigquery.routine.DeterminismLevel.DETERMINISM_LEVEL_UNSPECIFIED

The determinism of the UDF is unspecified.

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

google.cloud.bigquery.routine.DeterminismLevel.DETERMINISTIC

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

google.cloud.bigquery.routine.DeterminismLevel.NOT_DETERMINISTIC

google.cloud.bigquery.routine.RemoteFunctionOptions.connection

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

google.cloud.bigquery.routine.RemoteFunctionOptions.endpoint

string: Endpoint of the user-provided remote service.

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

google.cloud.bigquery.routine.RemoteFunctionOptions.max_batching_rows

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

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

google.cloud.bigquery.routine.RemoteFunctionOptions.user_defined_context

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

google.cloud.bigquery.routine.Routine.arguments

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

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

google.cloud.bigquery.routine.Routine.body

str: The body of the routine.

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

google.cloud.bigquery.routine.Routine.created

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

google.cloud.bigquery.routine.Routine.data_governance_type

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

google.cloud.bigquery.routine.Routine.dataset_id

str: ID of dataset containing the routine.

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

google.cloud.bigquery.routine.Routine.description

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

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

google.cloud.bigquery.routine.Routine.determinism_level

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

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

google.cloud.bigquery.routine.Routine.etag

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

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

google.cloud.bigquery.routine.Routine.imported_libraries

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

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

google.cloud.bigquery.routine.Routine.language

Optional[str]: The language of the routine.

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

google.cloud.bigquery.routine.Routine.modified

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

google.cloud.bigquery.routine.Routine.path

str: URL path for the routine's APIs.

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

google.cloud.bigquery.routine.Routine.project

str: ID of the project containing the routine.

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

google.cloud.bigquery.routine.Routine.reference

google.cloud.bigquery.routine.Routine.remote_function_options

google.cloud.bigquery.routine.Routine.return_table_type

The return type of a Table Valued Function (TVF) routine.

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

google.cloud.bigquery.routine.Routine.return_type

google.cloud.bigquery.StandardSqlDataType: Return type of the routine.

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

google.cloud.bigquery.routine.Routine.routine_id

str: The routine ID.

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

google.cloud.bigquery.routine.Routine.type_

str: The fine-grained type of the routine.

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

google.cloud.bigquery.routine.RoutineArgument.data_type

Optional[google.cloud.bigquery.StandardSqlDataType]: Type of a variable, e.g., a function argument.

See more: google.cloud.bigquery.routine.RoutineArgument.data_type

google.cloud.bigquery.routine.RoutineArgument.kind

Optional[str]: The kind of argument, for example FIXED_TYPE or ANY_TYPE.

See more: google.cloud.bigquery.routine.RoutineArgument.kind

google.cloud.bigquery.routine.RoutineArgument.mode

Optional[str]: The input/output mode of the argument.

See more: google.cloud.bigquery.routine.RoutineArgument.mode

google.cloud.bigquery.routine.RoutineArgument.name

Optional[str]: Name of this argument.

See more: google.cloud.bigquery.routine.RoutineArgument.name

google.cloud.bigquery.routine.RoutineReference.dataset_id

str: ID of dataset containing the routine.

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

google.cloud.bigquery.routine.RoutineReference.path

str: URL path for the routine's APIs.

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

google.cloud.bigquery.routine.RoutineReference.project

str: ID of the project containing the routine.

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

google.cloud.bigquery.routine.RoutineReference.routine_id

google.cloud.bigquery.schema.PolicyTagList.names

Tuple[str]: Policy tags associated with this definition.

See more: google.cloud.bigquery.schema.PolicyTagList.names

google.cloud.bigquery.schema.SchemaField.default_value_expression

Optional[str] default value of a field, using an SQL expression.

See more: google.cloud.bigquery.schema.SchemaField.default_value_expression

google.cloud.bigquery.schema.SchemaField.description

Optional[str]: description for the field.

See more: google.cloud.bigquery.schema.SchemaField.description

google.cloud.bigquery.schema.SchemaField.field_type

str: The type of the field.

See more: google.cloud.bigquery.schema.SchemaField.field_type

google.cloud.bigquery.schema.SchemaField.fields

Optional[tuple]: Subfields contained in this field.

See more: google.cloud.bigquery.schema.SchemaField.fields

google.cloud.bigquery.schema.SchemaField.is_nullable

bool: whether 'mode' is 'nullable'.

See more: google.cloud.bigquery.schema.SchemaField.is_nullable

google.cloud.bigquery.schema.SchemaField.max_length

Optional[int]: Maximum length for the STRING or BYTES field.

See more: google.cloud.bigquery.schema.SchemaField.max_length

google.cloud.bigquery.schema.SchemaField.mode

Optional[str]: The mode of the field.

See more: google.cloud.bigquery.schema.SchemaField.mode

google.cloud.bigquery.schema.SchemaField.name

str: The name of the field.

See more: google.cloud.bigquery.schema.SchemaField.name

google.cloud.bigquery.schema.SchemaField.policy_tags

Optional[google.cloud.bigquery.schema.PolicyTagList]: Policy tag list definition for this field.

See more: google.cloud.bigquery.schema.SchemaField.policy_tags

google.cloud.bigquery.schema.SchemaField.precision

Optional[int]: Precision (number of digits) for the NUMERIC field.

See more: google.cloud.bigquery.schema.SchemaField.precision

google.cloud.bigquery.schema.SchemaField.range_element_type

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

google.cloud.bigquery.schema.SchemaField.scale

Optional[int]: Scale (digits after decimal) for the NUMERIC field.

See more: google.cloud.bigquery.schema.SchemaField.scale

google.cloud.bigquery.standard_sql.StandardSqlDataType.array_element_type

The type of the array's elements, if type_kind is ARRAY.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.array_element_type

google.cloud.bigquery.standard_sql.StandardSqlDataType.range_element_type

The type of the range's elements, if type_kind = "RANGE".

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.range_element_type

google.cloud.bigquery.standard_sql.StandardSqlDataType.struct_type

The fields of this struct, in order, if type_kind is STRUCT.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.struct_type

google.cloud.bigquery.standard_sql.StandardSqlDataType.type_kind

The top level type of this field.

See more: google.cloud.bigquery.standard_sql.StandardSqlDataType.type_kind

google.cloud.bigquery.standard_sql.StandardSqlField.name

google.cloud.bigquery.standard_sql.StandardSqlField.type

The type of this parameter.

See more: google.cloud.bigquery.standard_sql.StandardSqlField.type

google.cloud.bigquery.standard_sql.StandardSqlStructType.fields

google.cloud.bigquery.standard_sql.StandardSqlTableType.columns

The columns in this table type.

See more: google.cloud.bigquery.standard_sql.StandardSqlTableType.columns

google.cloud.bigquery.table.PartitionRange.end

int: The end of range partitioning, exclusive.

See more: google.cloud.bigquery.table.PartitionRange.end

google.cloud.bigquery.table.PartitionRange.interval

int: The width of each interval.

See more: google.cloud.bigquery.table.PartitionRange.interval

google.cloud.bigquery.table.PartitionRange.start

int: The start of range partitioning, inclusive.

See more: google.cloud.bigquery.table.PartitionRange.start

google.cloud.bigquery.table.RangePartitioning.field

str: The table is partitioned by this field.

See more: google.cloud.bigquery.table.RangePartitioning.field

google.cloud.bigquery.table.RangePartitioning.range_

google.cloud.bigquery.table.RowIterator.client

The client that created this iterator.

See more: google.cloud.bigquery.table.RowIterator.client

google.cloud.bigquery.table.RowIterator.item_to_value

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

google.cloud.bigquery.table.RowIterator.job_id

ID of the query job (if applicable).

See more: google.cloud.bigquery.table.RowIterator.job_id

google.cloud.bigquery.table.RowIterator.location

Location where the query executed (if applicable).

See more: google.cloud.bigquery.table.RowIterator.location

google.cloud.bigquery.table.RowIterator.max_results

The maximum number of results to fetch.

See more: google.cloud.bigquery.table.RowIterator.max_results

google.cloud.bigquery.table.RowIterator.next_page_token

The token for the next page of results.

See more: google.cloud.bigquery.table.RowIterator.next_page_token

google.cloud.bigquery.table.RowIterator.num_dml_affected_rows

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

google.cloud.bigquery.table.RowIterator.num_results

The total number of results fetched so far.

See more: google.cloud.bigquery.table.RowIterator.num_results

google.cloud.bigquery.table.RowIterator.page_number

The current page of results.

See more: google.cloud.bigquery.table.RowIterator.page_number

google.cloud.bigquery.table.RowIterator.pages

Iterator of pages in the response.

See more: google.cloud.bigquery.table.RowIterator.pages

google.cloud.bigquery.table.RowIterator.project

GCP Project ID where these rows are read from.

See more: google.cloud.bigquery.table.RowIterator.project

google.cloud.bigquery.table.RowIterator.query_id

[Preview] ID of a completed query.

See more: google.cloud.bigquery.table.RowIterator.query_id

google.cloud.bigquery.table.RowIterator.schema

List[google.cloud.bigquery.schema.SchemaField]: The subset of columns to be read from the table.

See more: google.cloud.bigquery.table.RowIterator.schema

google.cloud.bigquery.table.RowIterator.total_rows

int: The total number of rows in the table or query results.

See more: google.cloud.bigquery.table.RowIterator.total_rows

google.cloud.bigquery.table.Table.clone_definition

Information about the clone.

See more: google.cloud.bigquery.table.Table.clone_definition

google.cloud.bigquery.table.Table.clustering_fields

Union[List[str], None]: Fields defining clustering for the table.

See more: google.cloud.bigquery.table.Table.clustering_fields

google.cloud.bigquery.table.Table.created

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

google.cloud.bigquery.table.Table.dataset_id

ID of dataset containing the table.

See more: google.cloud.bigquery.table.Table.dataset_id

google.cloud.bigquery.table.Table.description

Union[str, None]: Description of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.description

google.cloud.bigquery.table.Table.encryption_configuration

google.cloud.bigquery.table.Table.etag

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

See more: google.cloud.bigquery.table.Table.etag

google.cloud.bigquery.table.Table.expires

Union[datetime.datetime, None]: Datetime at which the table will be deleted.

See more: google.cloud.bigquery.table.Table.expires

google.cloud.bigquery.table.Table.external_data_configuration

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

google.cloud.bigquery.table.Table.friendly_name

Union[str, None]: Title of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.friendly_name

google.cloud.bigquery.table.Table.full_table_id

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

See more: google.cloud.bigquery.table.Table.full_table_id

google.cloud.bigquery.table.Table.labels

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

See more: google.cloud.bigquery.table.Table.labels

google.cloud.bigquery.table.Table.location

Union[str, None]: Location in which the table is hosted.

See more: google.cloud.bigquery.table.Table.location

google.cloud.bigquery.table.Table.modified

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

google.cloud.bigquery.table.Table.mview_enable_refresh

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

google.cloud.bigquery.table.Table.mview_last_refresh_time

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

google.cloud.bigquery.table.Table.mview_query

Optional[str]: SQL query defining the table as a materialized view (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.mview_query

google.cloud.bigquery.table.Table.mview_refresh_interval

Optional[datetime.timedelta]: The maximum frequency at which this materialized view will be refreshed.

See more: google.cloud.bigquery.table.Table.mview_refresh_interval

google.cloud.bigquery.table.Table.num_bytes

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

google.cloud.bigquery.table.Table.num_rows

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

google.cloud.bigquery.table.Table.partition_expiration

Union[int, None]: Expiration time in milliseconds for a partition.

See more: google.cloud.bigquery.table.Table.partition_expiration

google.cloud.bigquery.table.Table.partitioning_type

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

google.cloud.bigquery.table.Table.path

URL path for the table's APIs.

See more: google.cloud.bigquery.table.Table.path

google.cloud.bigquery.table.Table.project

Project bound to the table.

See more: google.cloud.bigquery.table.Table.project

google.cloud.bigquery.table.Table.range_partitioning

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

See more: google.cloud.bigquery.table.Table.range_partitioning

google.cloud.bigquery.table.Table.reference

A xref_TableReference pointing to this table.

See more: google.cloud.bigquery.table.Table.reference

google.cloud.bigquery.table.Table.require_partition_filter

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

google.cloud.bigquery.table.Table.schema

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

google.cloud.bigquery.table.Table.snapshot_definition

Information about the snapshot.

See more: google.cloud.bigquery.table.Table.snapshot_definition

google.cloud.bigquery.table.Table.streaming_buffer

google.cloud.bigquery.StreamingBuffer: Information about a table's streaming buffer.

See more: google.cloud.bigquery.table.Table.streaming_buffer

google.cloud.bigquery.table.Table.table_constraints

Tables Primary Key and Foreign Key information.

See more: google.cloud.bigquery.table.Table.table_constraints

google.cloud.bigquery.table.Table.table_id

google.cloud.bigquery.table.Table.table_type

Union[str, None]: The type of the table (:data:None until set from the server).

See more: google.cloud.bigquery.table.Table.table_type

google.cloud.bigquery.table.Table.time_partitioning

Optional[google.cloud.bigquery.table.TimePartitioning]: Configures time-based partitioning for a table.

See more: google.cloud.bigquery.table.Table.time_partitioning

google.cloud.bigquery.table.Table.view_query

Union[str, None]: SQL query defining the table as a view (defaults to :data:None).

See more: google.cloud.bigquery.table.Table.view_query

google.cloud.bigquery.table.Table.view_use_legacy_sql

bool: Specifies whether to execute the view with Legacy or Standard SQL.

See more: google.cloud.bigquery.table.Table.view_use_legacy_sql

google.cloud.bigquery.table.TableListItem.clustering_fields

Union[List[str], None]: Fields defining clustering for the table.

See more: google.cloud.bigquery.table.TableListItem.clustering_fields

google.cloud.bigquery.table.TableListItem.created

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

google.cloud.bigquery.table.TableListItem.dataset_id

ID of dataset containing the table.

See more: google.cloud.bigquery.table.TableListItem.dataset_id

google.cloud.bigquery.table.TableListItem.expires

Union[datetime.datetime, None]: Datetime at which the table will be deleted.

See more: google.cloud.bigquery.table.TableListItem.expires

google.cloud.bigquery.table.TableListItem.friendly_name

Union[str, None]: Title of the table (defaults to :data:None).

See more: google.cloud.bigquery.table.TableListItem.friendly_name

google.cloud.bigquery.table.TableListItem.full_table_id

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

See more: google.cloud.bigquery.table.TableListItem.full_table_id

google.cloud.bigquery.table.TableListItem.labels

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

See more: google.cloud.bigquery.table.TableListItem.labels

google.cloud.bigquery.table.TableListItem.partition_expiration

Union[int, None]: Expiration time in milliseconds for a partition.

See more: google.cloud.bigquery.table.TableListItem.partition_expiration

google.cloud.bigquery.table.TableListItem.partitioning_type

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

google.cloud.bigquery.table.TableListItem.path

URL path for the table's APIs.

See more: google.cloud.bigquery.table.TableListItem.path

google.cloud.bigquery.table.TableListItem.project

Project bound to the table.

See more: google.cloud.bigquery.table.TableListItem.project

google.cloud.bigquery.table.TableListItem.reference

A xref_TableReference pointing to this table.

See more: google.cloud.bigquery.table.TableListItem.reference

google.cloud.bigquery.table.TableListItem.table_id

google.cloud.bigquery.table.TableListItem.table_type

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.TableListItem.time_partitioning

google.cloud.bigquery.table.TableListItem.view_use_legacy_sql

bool: Specifies whether to execute the view with Legacy or Standard SQL.

See more: google.cloud.bigquery.table.TableListItem.view_use_legacy_sql

google.cloud.bigquery.table.TableReference.dataset_id

ID of dataset containing the table.

See more: google.cloud.bigquery.table.TableReference.dataset_id

google.cloud.bigquery.table.TableReference.path

URL path for the table's APIs.

See more: google.cloud.bigquery.table.TableReference.path

google.cloud.bigquery.table.TableReference.project

Project bound to the table.

See more: google.cloud.bigquery.table.TableReference.project

google.cloud.bigquery.table.TableReference.table_id

google.cloud.bigquery.table.TimePartitioning.expiration_ms

int: Number of milliseconds to keep the storage for a partition.

See more: google.cloud.bigquery.table.TimePartitioning.expiration_ms

google.cloud.bigquery.table.TimePartitioning.field

str: Field in the table to use for partitioning.

See more: google.cloud.bigquery.table.TimePartitioning.field

google.cloud.bigquery.table.TimePartitioning.require_partition_filter

bool: Specifies whether partition filters are required for queries.

See more: google.cloud.bigquery.table.TimePartitioning.require_partition_filter

google.cloud.bigquery.table.TimePartitioning.type_

google.cloud.bigquery.table.TimePartitioningType.DAY

Generates one partition per day.

See more: google.cloud.bigquery.table.TimePartitioningType.DAY

google.cloud.bigquery.table.TimePartitioningType.HOUR

Generates one partition per hour.

See more: google.cloud.bigquery.table.TimePartitioningType.HOUR

google.cloud.bigquery.table.TimePartitioningType.MONTH

Generates one partition per month.

See more: google.cloud.bigquery.table.TimePartitioningType.MONTH

google.cloud.bigquery.table.TimePartitioningType.YEAR

Generates one partition per year.

See more: google.cloud.bigquery.table.TimePartitioningType.YEAR