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.



4901
4902
4903
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4901

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

Instance Attribute Details

#bi_engine_statistics ⇒ Google::Apis::BigqueryV2::BiEngineStatistics

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

Returns:



4699
4700
4701
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4699

def bi_engine_statistics
  @bi_engine_statistics
end

#billing_tier ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4704
4705
4706
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4704

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) 


4709
4710
4711
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4709

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) 


4716
4717
4718
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4716

def ddl_affected_row_access_policy_count
  @ddl_affected_row_access_policy_count
end

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

Returns:



4722
4723
4724
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4722

def ddl_destination_table
  @ddl_destination_table
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) 


4733
4734
4735
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4733

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:



4739
4740
4741
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4739

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:



4745
4746
4747
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4745

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:



4751
4752
4753
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4751

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:



4757
4758
4759
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4757

def ddl_target_table
  @ddl_target_table
end

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

Returns:



4763
4764
4765
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4763

def dml_stats
  @dml_stats
end

#estimated_bytes_processed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4768
4769
4770
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4768

def estimated_bytes_processed
  @estimated_bytes_processed
end

#ml_statistics ⇒ Google::Apis::BigqueryV2::MlStatistics

[Output only] Statistics of a BigQuery ML training job. Corresponds to the JSON property mlStatistics

Returns:



4773
4774
4775
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4773

def ml_statistics
  @ml_statistics
end

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

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

Returns:



4778
4779
4780
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4778

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) 


4783
4784
4785
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4783

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) 


4788
4789
4790
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4788

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) 


4794
4795
4796
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4794

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:



4799
4800
4801
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4799

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:



4805
4806
4807
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4805

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:



4811
4812
4813
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4811

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:



4816
4817
4818
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4816

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:



4822
4823
4824
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4822

def schema
  @schema
end

#search_statistics ⇒ Google::Apis::BigqueryV2::SearchStatistics

[Output only] Search query specific statistics. Corresponds to the JSON property searchStatistics

Returns:



4827
4828
4829
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4827

def search_statistics
  @search_statistics
end

#spark_statistics ⇒ Google::Apis::BigqueryV2::SparkStatistics

[Output only] Statistics of a Spark procedure job. Corresponds to the JSON property sparkStatistics

Returns:



4832
4833
4834
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4832

def spark_statistics
  @spark_statistics
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) 


4852
4853
4854
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4852

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:



4857
4858
4859
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4857

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4862
4863
4864
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4862

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) 


4867
4868
4869
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4867

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) 


4876
4877
4878
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4876

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) 


4882
4883
4884
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4882

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) 


4887
4888
4889
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4887

def total_slot_ms
  @total_slot_ms
end

#transferred_bytes ⇒ Fixnum

[Output-only] Total bytes transferred for cross-cloud queries such as Cross Cloud Transfer and CREATE TABLE AS SELECT (CTAS). Corresponds to the JSON property transferredBytes

Returns:

  • (Fixnum) 


4893
4894
4895
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4893

def transferred_bytes
  @transferred_bytes
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:



4899
4900
4901
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4899

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
4916
4917
4918
4919
4920
4921
4922
4923
4924
4925
4926
4927
4928
4929
4930
4931
4932
4933
4934
4935
4936
4937
4938
4939
4940
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4906

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)
  @ml_statistics = args[:ml_statistics] if args.key?(:ml_statistics)
  @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)
  @search_statistics = args[:search_statistics] if args.key?(:search_statistics)
  @spark_statistics = args[:spark_statistics] if args.key?(:spark_statistics)
  @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)
  @transferred_bytes = args[:transferred_bytes] if args.key?(:transferred_bytes)
  @undeclared_query_parameters = args[:undeclared_query_parameters] if args.key?(:undeclared_query_parameters)
end