Class: Google::Apis::BigqueryV2::JobStatistics2

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/bigquery_v2/classes.rb,
lib/google/apis/bigquery_v2/representations.rb,
lib/google/apis/bigquery_v2/representations.rb

Defined Under Namespace

Classes: ReservationUsage

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ JobStatistics2

Returns a new instance of JobStatistics2.



4195
4196
4197
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4195

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#bi_engine_statisticsGoogle::Apis::BigqueryV2::BiEngineStatistics

BI Engine specific Statistics. [Output-only] BI Engine specific Statistics. Corresponds to the JSON property biEngineStatistics



4014
4015
4016
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4014

def bi_engine_statistics
  @bi_engine_statistics
end

#billing_tierFixnum

[Output-only] Billing tier for the job. Corresponds to the JSON property billingTier

Returns:

  • (Fixnum)


4019
4020
4021
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4019

def billing_tier
  @billing_tier
end

#cache_hitBoolean Also known as: cache_hit?

[Output-only] Whether the query result was fetched from the query cache. Corresponds to the JSON property cacheHit

Returns:

  • (Boolean)


4024
4025
4026
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4024

def cache_hit
  @cache_hit
end

#ddl_affected_row_access_policy_countFixnum

[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

Returns:

  • (Fixnum)


4031
4032
4033
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4031

def ddl_affected_row_access_policy_count
  @ddl_affected_row_access_policy_count
end

#ddl_destination_tableGoogle::Apis::BigqueryV2::TableReference

[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



4037
4038
4039
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4037

def ddl_destination_table
  @ddl_destination_table
end

#ddl_operation_performedString

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

Returns:

  • (String)


4048
4049
4050
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4048

def ddl_operation_performed
  @ddl_operation_performed
end

#ddl_target_datasetGoogle::Apis::BigqueryV2::DatasetReference

[Output-only] The DDL target dataset. Present only for CREATE/ALTER/DROP SCHEMA queries. Corresponds to the JSON property ddlTargetDataset



4054
4055
4056
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4054

def ddl_target_dataset
  @ddl_target_dataset
end

#ddl_target_routineGoogle::Apis::BigqueryV2::RoutineReference

The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries. Corresponds to the JSON property ddlTargetRoutine



4060
4061
4062
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4060

def ddl_target_routine
  @ddl_target_routine
end

#ddl_target_row_access_policyGoogle::Apis::BigqueryV2::RowAccessPolicyReference

[Output-only] [Preview] The DDL target row access policy. Present only for CREATE/DROP ROW ACCESS POLICY queries. Corresponds to the JSON property ddlTargetRowAccessPolicy



4066
4067
4068
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4066

def ddl_target_row_access_policy
  @ddl_target_row_access_policy
end

#ddl_target_tableGoogle::Apis::BigqueryV2::TableReference

[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



4072
4073
4074
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4072

def ddl_target_table
  @ddl_target_table
end

#dml_statsGoogle::Apis::BigqueryV2::DmlStatistics

[Output-only] Detailed statistics for DML statements Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE. Corresponds to the JSON property dmlStats



4078
4079
4080
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4078

def dml_stats
  @dml_stats
end

#estimated_bytes_processedFixnum

[Output-only] The original estimate of bytes processed for the job. Corresponds to the JSON property estimatedBytesProcessed

Returns:

  • (Fixnum)


4083
4084
4085
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4083

def estimated_bytes_processed
  @estimated_bytes_processed
end

#model_trainingGoogle::Apis::BigqueryV2::BigQueryModelTraining

[Output-only, Beta] Information about create model query job progress. Corresponds to the JSON property modelTraining



4088
4089
4090
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4088

def model_training
  @model_training
end

#model_training_current_iterationFixnum

[Output-only, Beta] Deprecated; do not use. Corresponds to the JSON property modelTrainingCurrentIteration

Returns:

  • (Fixnum)


4093
4094
4095
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4093

def model_training_current_iteration
  @model_training_current_iteration
end

#model_training_expected_total_iterationFixnum

[Output-only, Beta] Deprecated; do not use. Corresponds to the JSON property modelTrainingExpectedTotalIteration

Returns:

  • (Fixnum)


4098
4099
4100
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4098

def model_training_expected_total_iteration
  @model_training_expected_total_iteration
end

#num_dml_affected_rowsFixnum

[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

Returns:

  • (Fixnum)


4104
4105
4106
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4104

def num_dml_affected_rows
  @num_dml_affected_rows
end

#query_planArray<Google::Apis::BigqueryV2::ExplainQueryStage>

[Output-only] Describes execution plan for the query. Corresponds to the JSON property queryPlan



4109
4110
4111
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4109

def query_plan
  @query_plan
end

#referenced_routinesArray<Google::Apis::BigqueryV2::RoutineReference>

[Output-only] Referenced routines (persistent user-defined functions and stored procedures) for the job. Corresponds to the JSON property referencedRoutines



4115
4116
4117
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4115

def referenced_routines
  @referenced_routines
end

#referenced_tablesArray<Google::Apis::BigqueryV2::TableReference>

[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



4121
4122
4123
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4121

def referenced_tables
  @referenced_tables
end

#reservation_usageArray<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>

[Output-only] Job resource usage breakdown by reservation. Corresponds to the JSON property reservationUsage



4126
4127
4128
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4126

def reservation_usage
  @reservation_usage
end

#schemaGoogle::Apis::BigqueryV2::TableSchema

[Output-only] The schema of the results. Present only for successful dry run of non-legacy SQL queries. Corresponds to the JSON property schema



4132
4133
4134
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4132

def schema
  @schema
end

#statement_typeString

The type of query statement, if valid. Possible values (new values might be added in the future): "SELECT": SELECT query. "INSERT": INSERT query; see https://cloud.google.com/bigquery/docs/reference/standard-sql/data- manipulation-language. "UPDATE": UPDATE query; see https://cloud.google.com/ bigquery/docs/reference/standard-sql/data-manipulation-language. "DELETE": DELETE query; see https://cloud.google.com/bigquery/docs/reference/standard- sql/data-manipulation-language. "MERGE": MERGE query; see https://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

Returns:

  • (String)


4152
4153
4154
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4152

def statement_type
  @statement_type
end

#timelineArray<Google::Apis::BigqueryV2::QueryTimelineSample>

[Output-only] [Beta] Describes a timeline of job execution. Corresponds to the JSON property timeline



4157
4158
4159
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4157

def timeline
  @timeline
end

#total_bytes_billedFixnum

[Output-only] Total bytes billed for the job. Corresponds to the JSON property totalBytesBilled

Returns:

  • (Fixnum)


4162
4163
4164
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4162

def total_bytes_billed
  @total_bytes_billed
end

#total_bytes_processedFixnum

[Output-only] Total bytes processed for the job. Corresponds to the JSON property totalBytesProcessed

Returns:

  • (Fixnum)


4167
4168
4169
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4167

def total_bytes_processed
  @total_bytes_processed
end

#total_bytes_processed_accuracyString

[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

Returns:

  • (String)


4176
4177
4178
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4176

def total_bytes_processed_accuracy
  @total_bytes_processed_accuracy
end

#total_partitions_processedFixnum

[Output-only] Total number of partitions processed from all partitioned tables referenced in the job. Corresponds to the JSON property totalPartitionsProcessed

Returns:

  • (Fixnum)


4182
4183
4184
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4182

def total_partitions_processed
  @total_partitions_processed
end

#total_slot_msFixnum

[Output-only] Slot-milliseconds for the job. Corresponds to the JSON property totalSlotMs

Returns:

  • (Fixnum)


4187
4188
4189
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4187

def total_slot_ms
  @total_slot_ms
end

#undeclared_query_parametersArray<Google::Apis::BigqueryV2::QueryParameter>

Standard SQL only: list of undeclared query parameters detected during a dry run validation. Corresponds to the JSON property undeclaredQueryParameters



4193
4194
4195
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4193

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4200
4201
4202
4203
4204
4205
4206
4207
4208
4209
4210
4211
4212
4213
4214
4215
4216
4217
4218
4219
4220
4221
4222
4223
4224
4225
4226
4227
4228
4229
4230
# 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