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.



4907
4908
4909
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4907

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:



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

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) 


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

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) 


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

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) 


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

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:



4728
4729
4730
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4728

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) 


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

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:



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

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:



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

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:



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

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:



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

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:



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

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) 


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

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:



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

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:



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

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) 


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

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) 


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

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) 


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

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:



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

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:



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

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:



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

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:



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

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:



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

def schema
  @schema
end

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

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

Returns:



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

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:



4838
4839
4840
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4838

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) 


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

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:



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

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


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

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) 


4873
4874
4875
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4873

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) 


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

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) 


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

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) 


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

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) 


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

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:



4905
4906
4907
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4905

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



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
4941
4942
4943
4944
4945
4946
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4912

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