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.



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

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

Instance Attribute Details

#billing_tier ⇒ Fixnum

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

Returns:

  • (Fixnum) 


3883
3884
3885
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3883

def billing_tier
  @billing_tier
end

#cache_hit ⇒ Boolean 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) 


3888
3889
3890
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3888

def cache_hit
  @cache_hit
end

#ddl_affected_row_access_policy_count ⇒ Fixnum

[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) 


3895
3896
3897
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3895

def ddl_affected_row_access_policy_count
  @ddl_affected_row_access_policy_count
end

#ddl_operation_performed ⇒ String

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) 


3906
3907
3908
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3906

def ddl_operation_performed
  @ddl_operation_performed
end

#ddl_target_dataset ⇒ Google::Apis::BigqueryV2::DatasetReference

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

Returns:



3912
3913
3914
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3912

def ddl_target_dataset
  @ddl_target_dataset
end

#ddl_target_routine ⇒ Google::Apis::BigqueryV2::RoutineReference

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

Returns:



3918
3919
3920
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3918

def ddl_target_routine
  @ddl_target_routine
end

#ddl_target_row_access_policy ⇒ Google::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

Returns:



3924
3925
3926
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3924

def ddl_target_row_access_policy
  @ddl_target_row_access_policy
end

#ddl_target_table ⇒ Google::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

Returns:



3930
3931
3932
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3930

def ddl_target_table
  @ddl_target_table
end

#estimated_bytes_processed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


3935
3936
3937
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3935

def estimated_bytes_processed
  @estimated_bytes_processed
end

#model_training ⇒ Google::Apis::BigqueryV2::BigQueryModelTraining

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

Returns:



3940
3941
3942
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3940

def model_training
  @model_training
end

#model_training_current_iteration ⇒ Fixnum

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

Returns:

  • (Fixnum) 


3945
3946
3947
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3945

def model_training_current_iteration
  @model_training_current_iteration
end

#model_training_expected_total_iteration ⇒ Fixnum

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

Returns:

  • (Fixnum) 


3950
3951
3952
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3950

def model_training_expected_total_iteration
  @model_training_expected_total_iteration
end

#num_dml_affected_rows ⇒ Fixnum

[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) 


3956
3957
3958
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3956

def num_dml_affected_rows
  @num_dml_affected_rows
end

#query_plan ⇒ Array<Google::Apis::BigqueryV2::ExplainQueryStage>

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

Returns:



3961
3962
3963
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3961

def query_plan
  @query_plan
end

#referenced_routines ⇒ Array<Google::Apis::BigqueryV2::RoutineReference>

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

Returns:



3967
3968
3969
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3967

def referenced_routines
  @referenced_routines
end

#referenced_tables ⇒ Array<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

Returns:



3973
3974
3975
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3973

def referenced_tables
  @referenced_tables
end

#reservation_usage ⇒ Array<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>

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

Returns:



3978
3979
3980
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3978

def reservation_usage
  @reservation_usage
end

#schema ⇒ Google::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

Returns:



3984
3985
3986
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3984

def schema
  @schema
end

#statement_type ⇒ String

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) 


4004
4005
4006
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4004

def statement_type
  @statement_type
end

#timeline ⇒ Array<Google::Apis::BigqueryV2::QueryTimelineSample>

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

Returns:



4009
4010
4011
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4009

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


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

def total_bytes_billed
  @total_bytes_billed
end

#total_bytes_processed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


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

def total_bytes_processed
  @total_bytes_processed
end

#total_bytes_processed_accuracy ⇒ String

[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) 


4028
4029
4030
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4028

def total_bytes_processed_accuracy
  @total_bytes_processed_accuracy
end

#total_partitions_processed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4034
4035
4036
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4034

def total_partitions_processed
  @total_partitions_processed
end

#total_slot_ms ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4039
4040
4041
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4039

def total_slot_ms
  @total_slot_ms
end

#undeclared_query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>

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

Returns:



4045
4046
4047
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4045

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4052
4053
4054
4055
4056
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071
4072
4073
4074
4075
4076
4077
4078
4079
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4052

def update!(**args)
  @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_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)
  @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