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.



4741
4742
4743
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4741

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:



4555
4556
4557
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4555

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) 


4560
4561
4562
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4560

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) 


4565
4566
4567
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4565

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) 


4572
4573
4574
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4572

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:



4578
4579
4580
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4578

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) 


4589
4590
4591
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4589

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:



4595
4596
4597
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4595

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:



4601
4602
4603
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4601

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:



4607
4608
4609
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4607

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:



4613
4614
4615
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4613

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:



4619
4620
4621
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4619

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) 


4624
4625
4626
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4624

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:



4629
4630
4631
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4629

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:



4634
4635
4636
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4634

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) 


4639
4640
4641
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4639

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) 


4644
4645
4646
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4644

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) 


4650
4651
4652
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4650

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:



4655
4656
4657
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4655

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:



4661
4662
4663
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4661

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:



4667
4668
4669
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4667

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:



4672
4673
4674
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4672

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:



4678
4679
4680
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4678

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) 


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

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:



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

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


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

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) 


4713
4714
4715
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4713

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) 


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

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) 


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

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) 


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

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:



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

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4746
4747
4748
4749
4750
4751
4752
4753
4754
4755
4756
4757
4758
4759
4760
4761
4762
4763
4764
4765
4766
4767
4768
4769
4770
4771
4772
4773
4774
4775
4776
4777
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4746

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