class Google::Apis::BigqueryV2::JobStatistics2

Attributes

bi_engine_statistics[RW]

BI Engine specific Statistics. [Output-only] BI Engine specific Statistics. Corresponds to the JSON property `biEngineStatistics` @return [Google::Apis::BigqueryV2::BiEngineStatistics]

billing_tier[RW]
Output-only

Billing tier for the job.

Corresponds to the JSON property `billingTier` @return [Fixnum]

cache_hit[RW]
Output-only

Whether the query result was fetched from the query cache.

Corresponds to the JSON property `cacheHit` @return [Boolean]

cache_hit?[RW]
Output-only

Whether the query result was fetched from the query cache.

Corresponds to the JSON property `cacheHit` @return [Boolean]

ddl_affected_row_access_policy_count[RW]
Output-only
Preview

The number of row access policies affected by a DDL

statement. Present only for DROP ALL ROW ACCESS POLICIES queries. Corresponds to the JSON property `ddlAffectedRowAccessPolicyCount` @return [Fixnum]

ddl_destination_table[RW]
Output-only

The DDL destination table. Present only for ALTER TABLE RENAME

TO queries. Note that ddl_target_table is used just for its type information. Corresponds to the JSON property `ddlDestinationTable` @return [Google::Apis::BigqueryV2::TableReference]

ddl_operation_performed[RW]

The DDL operation performed, possibly dependent on the pre-existence of the DDL target. Possible values (new values might be added in the future): “CREATE” : The query created the DDL target. “SKIP”: No-op. Example cases: the query is CREATE TABLE IF NOT EXISTS while the table already exists, or the query is DROP TABLE IF EXISTS while the table does not exist. “REPLACE”: The query replaced the DDL target. Example case: the query is CREATE OR REPLACE TABLE, and the table already exists. “DROP”: The query deleted the DDL target. Corresponds to the JSON property `ddlOperationPerformed` @return [String]

ddl_target_dataset[RW]
Output-only

The DDL target dataset. Present only for CREATE/ALTER/DROP

SCHEMA queries. Corresponds to the JSON property `ddlTargetDataset` @return [Google::Apis::BigqueryV2::DatasetReference]

ddl_target_routine[RW]

The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries. Corresponds to the JSON property `ddlTargetRoutine` @return [Google::Apis::BigqueryV2::RoutineReference]

ddl_target_row_access_policy[RW]
Output-only
Preview

The DDL target row access policy. Present only for

CREATE/DROP ROW ACCESS POLICY queries. Corresponds to the JSON property `ddlTargetRowAccessPolicy` @return [Google::Apis::BigqueryV2::RowAccessPolicyReference]

ddl_target_table[RW]
Output-only

The DDL target table. Present only for CREATE/DROP TABLE/VIEW

and DROP ALL ROW ACCESS POLICIES queries. Corresponds to the JSON property `ddlTargetTable` @return [Google::Apis::BigqueryV2::TableReference]

dml_stats[RW]
Output-only

Detailed statistics for DML statements Present only for DML

statements INSERT, UPDATE, DELETE or TRUNCATE. Corresponds to the JSON property `dmlStats` @return [Google::Apis::BigqueryV2::DmlStatistics]

estimated_bytes_processed[RW]
Output-only

The original estimate of bytes processed for the job.

Corresponds to the JSON property `estimatedBytesProcessed` @return [Fixnum]

model_training[RW]
Output-only, Beta

Information about create model query job progress.

Corresponds to the JSON property `modelTraining` @return [Google::Apis::BigqueryV2::BigQueryModelTraining]

model_training_current_iteration[RW]
Output-only, Beta

Deprecated; do not use.

Corresponds to the JSON property `modelTrainingCurrentIteration` @return [Fixnum]

model_training_expected_total_iteration[RW]
Output-only, Beta

Deprecated; do not use.

Corresponds to the JSON property `modelTrainingExpectedTotalIteration` @return [Fixnum]

num_dml_affected_rows[RW]
Output-only

The number of rows affected by a DML statement. Present only for

DML statements INSERT, UPDATE or DELETE. Corresponds to the JSON property `numDmlAffectedRows` @return [Fixnum]

query_plan[RW]
Output-only

Describes execution plan for the query.

Corresponds to the JSON property `queryPlan` @return [Array<Google::Apis::BigqueryV2::ExplainQueryStage>]

referenced_routines[RW]
Output-only

Referenced routines (persistent user-defined functions and

stored procedures) for the job. Corresponds to the JSON property `referencedRoutines` @return [Array<Google::Apis::BigqueryV2::RoutineReference>]

referenced_tables[RW]
Output-only

Referenced tables for the job. Queries that reference more than

50 tables will not have a complete list. Corresponds to the JSON property `referencedTables` @return [Array<Google::Apis::BigqueryV2::TableReference>]

reservation_usage[RW]
Output-only

Job resource usage breakdown by reservation.

Corresponds to the JSON property `reservationUsage` @return [Array<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>]

schema[RW]
Output-only

The schema of the results. Present only for successful dry run

of non-legacy SQL queries. Corresponds to the JSON property `schema` @return [Google::Apis::BigqueryV2::TableSchema]

statement_type[RW]

The type of query statement, if valid. Possible values (new values might be added in the future): “SELECT”: SELECT query. “INSERT”: INSERT query; see cloud.google.com/bigquery/docs/reference/standard-sql/data- manipulation-language. “UPDATE”: UPDATE query; see cloud.google.com/ bigquery/docs/reference/standard-sql/data-manipulation-language. “DELETE”: DELETE query; see cloud.google.com/bigquery/docs/reference/standard- sql/data-manipulation-language. “MERGE”: MERGE query; see cloud.google. com/bigquery/docs/reference/standard-sql/data-manipulation-language. “ ALTER_TABLE”: ALTER TABLE query. “ALTER_VIEW”: ALTER VIEW query. “ASSERT”: ASSERT condition AS 'description'. “CREATE_FUNCTION”: CREATE FUNCTION query. “ CREATE_MODEL”: CREATE [OR REPLACE] MODEL … AS SELECT … . “CREATE_PROCEDURE” : CREATE PROCEDURE query. “CREATE_TABLE”: CREATE [OR REPLACE] TABLE without AS SELECT. “CREATE_TABLE_AS_SELECT”: CREATE [OR REPLACE] TABLE … AS SELECT … . “CREATE_VIEW”: CREATE [OR REPLACE] VIEW … AS SELECT … . “DROP_FUNCTION” : DROP FUNCTION query. “DROP_PROCEDURE”: DROP PROCEDURE query. “DROP_TABLE”: DROP TABLE query. “DROP_VIEW”: DROP VIEW query. Corresponds to the JSON property `statementType` @return [String]

timeline[RW]
Output-only
Beta

Describes a timeline of job execution.

Corresponds to the JSON property `timeline` @return [Array<Google::Apis::BigqueryV2::QueryTimelineSample>]

total_bytes_billed[RW]
Output-only

Total bytes billed for the job.

Corresponds to the JSON property `totalBytesBilled` @return [Fixnum]

total_bytes_processed[RW]
Output-only

Total bytes processed for the job.

Corresponds to the JSON property `totalBytesProcessed` @return [Fixnum]

total_bytes_processed_accuracy[RW]
Output-only

For dry-run jobs, totalBytesProcessed is an estimate and this

field specifies the accuracy of the estimate. Possible values can be: UNKNOWN: accuracy of the estimate is unknown. PRECISE: estimate is precise. LOWER_BOUND: estimate is lower bound of what the query would cost. UPPER_BOUND: estimate is upper bound of what the query would cost. Corresponds to the JSON property `totalBytesProcessedAccuracy` @return [String]

total_partitions_processed[RW]
Output-only

Total number of partitions processed from all partitioned tables

referenced in the job. Corresponds to the JSON property `totalPartitionsProcessed` @return [Fixnum]

total_slot_ms[RW]
Output-only

Slot-milliseconds for the job.

Corresponds to the JSON property `totalSlotMs` @return [Fixnum]

undeclared_query_parameters[RW]

Standard SQL only: list of undeclared query parameters detected during a dry run validation. Corresponds to the JSON property `undeclaredQueryParameters` @return [Array<Google::Apis::BigqueryV2::QueryParameter>]

Public Class Methods

new(**args) click to toggle source
# File lib/google/apis/bigquery_v2/classes.rb, line 4195
def initialize(**args)
   update!(**args)
end

Public Instance Methods

update!(**args) click to toggle source

Update properties of this object

# File lib/google/apis/bigquery_v2/classes.rb, line 4200
def update!(**args)
  @bi_engine_statistics = args[:bi_engine_statistics] if args.key?(:bi_engine_statistics)
  @billing_tier = args[:billing_tier] if args.key?(:billing_tier)
  @cache_hit = args[:cache_hit] if args.key?(:cache_hit)
  @ddl_affected_row_access_policy_count = args[:ddl_affected_row_access_policy_count] if args.key?(:ddl_affected_row_access_policy_count)
  @ddl_destination_table = args[:ddl_destination_table] if args.key?(:ddl_destination_table)
  @ddl_operation_performed = args[:ddl_operation_performed] if args.key?(:ddl_operation_performed)
  @ddl_target_dataset = args[:ddl_target_dataset] if args.key?(:ddl_target_dataset)
  @ddl_target_routine = args[:ddl_target_routine] if args.key?(:ddl_target_routine)
  @ddl_target_row_access_policy = args[:ddl_target_row_access_policy] if args.key?(:ddl_target_row_access_policy)
  @ddl_target_table = args[:ddl_target_table] if args.key?(:ddl_target_table)
  @dml_stats = args[:dml_stats] if args.key?(:dml_stats)
  @estimated_bytes_processed = args[:estimated_bytes_processed] if args.key?(:estimated_bytes_processed)
  @model_training = args[:model_training] if args.key?(:model_training)
  @model_training_current_iteration = args[:model_training_current_iteration] if args.key?(:model_training_current_iteration)
  @model_training_expected_total_iteration = args[:model_training_expected_total_iteration] if args.key?(:model_training_expected_total_iteration)
  @num_dml_affected_rows = args[:num_dml_affected_rows] if args.key?(:num_dml_affected_rows)
  @query_plan = args[:query_plan] if args.key?(:query_plan)
  @referenced_routines = args[:referenced_routines] if args.key?(:referenced_routines)
  @referenced_tables = args[:referenced_tables] if args.key?(:referenced_tables)
  @reservation_usage = args[:reservation_usage] if args.key?(:reservation_usage)
  @schema = args[:schema] if args.key?(:schema)
  @statement_type = args[:statement_type] if args.key?(:statement_type)
  @timeline = args[:timeline] if args.key?(:timeline)
  @total_bytes_billed = args[:total_bytes_billed] if args.key?(:total_bytes_billed)
  @total_bytes_processed = args[:total_bytes_processed] if args.key?(:total_bytes_processed)
  @total_bytes_processed_accuracy = args[:total_bytes_processed_accuracy] if args.key?(:total_bytes_processed_accuracy)
  @total_partitions_processed = args[:total_partitions_processed] if args.key?(:total_partitions_processed)
  @total_slot_ms = args[:total_slot_ms] if args.key?(:total_slot_ms)
  @undeclared_query_parameters = args[:undeclared_query_parameters] if args.key?(:undeclared_query_parameters)
end