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

Overview

Statistics for a query job.

Defined Under Namespace

Classes: ReservationUsage

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ JobStatistics2

Returns a new instance of JobStatistics2.



5888
5889
5890
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5888

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

Instance Attribute Details

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

Statistics for a BI Engine specific query. Populated as part of JobStatistics2 Corresponds to the JSON property biEngineStatistics

Returns:



5570
5571
5572
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5570

def bi_engine_statistics
  @bi_engine_statistics
end

#billing_tier ⇒ Fixnum

Output only. Billing tier for the job. This is a BigQuery-specific concept which is not related to the Google Cloud notion of "free tier". The value here is a measure of the query's resource consumption relative to the amount of data scanned. For on-demand queries, the limit is 100, and all queries within this limit are billed at the standard on-demand rates. On-demand queries that exceed this limit will fail with a billingTierLimitExceeded error. Corresponds to the JSON property billingTier

Returns:

  • (Fixnum) 


5580
5581
5582
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5580

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) 


5585
5586
5587
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5585

def cache_hit
  @cache_hit
end

#dcl_target_dataset ⇒ Google::Apis::BigqueryV2::DatasetReference

Identifier for a dataset. Corresponds to the JSON property dclTargetDataset

Returns:



5591
5592
5593
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5591

def dcl_target_dataset
  @dcl_target_dataset
end

#dcl_target_table ⇒ Google::Apis::BigqueryV2::TableReference

Output only. Referenced table for DCL statement. Corresponds to the JSON property dclTargetTable

Returns:



5596
5597
5598
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5596

def dcl_target_table
  @dcl_target_table
end

#dcl_target_view ⇒ Google::Apis::BigqueryV2::TableReference

Output only. Referenced view for DCL statement. Corresponds to the JSON property dclTargetView

Returns:



5601
5602
5603
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5601

def dcl_target_view
  @dcl_target_view
end

#ddl_affected_row_access_policy_count ⇒ Fixnum

Output only. 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) 


5607
5608
5609
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5607

def ddl_affected_row_access_policy_count
  @ddl_affected_row_access_policy_count
end

#ddl_destination_table ⇒ Google::Apis::BigqueryV2::TableReference

Output only. The table after rename. Present only for ALTER TABLE RENAME TO query. Corresponds to the JSON property ddlDestinationTable

Returns:



5613
5614
5615
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5613

def ddl_destination_table
  @ddl_destination_table
end

#ddl_operation_performed ⇒ String

Output only. The DDL operation performed, possibly dependent on the pre- existence of the DDL target. Corresponds to the JSON property ddlOperationPerformed

Returns:

  • (String) 


5619
5620
5621
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5619

def ddl_operation_performed
  @ddl_operation_performed
end

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

Identifier for a dataset. Corresponds to the JSON property ddlTargetDataset

Returns:



5624
5625
5626
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5624

def ddl_target_dataset
  @ddl_target_dataset
end

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

Id path of a routine. Corresponds to the JSON property ddlTargetRoutine

Returns:



5629
5630
5631
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5629

def ddl_target_routine
  @ddl_target_routine
end

#ddl_target_row_access_policy ⇒ Google::Apis::BigqueryV2::RowAccessPolicyReference

Id path of a row access policy. Corresponds to the JSON property ddlTargetRowAccessPolicy

Returns:



5634
5635
5636
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5634

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:



5640
5641
5642
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5640

def ddl_target_table
  @ddl_target_table
end

#dml_stats ⇒ Google::Apis::BigqueryV2::DmlStatistics

Detailed statistics for DML statements Corresponds to the JSON property dmlStats

Returns:



5645
5646
5647
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5645

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) 


5650
5651
5652
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5650

def estimated_bytes_processed
  @estimated_bytes_processed
end

#export_data_statistics ⇒ Google::Apis::BigqueryV2::ExportDataStatistics

Statistics for the EXPORT DATA statement as part of Query Job. EXTRACT JOB statistics are populated in JobStatistics4. Corresponds to the JSON property exportDataStatistics

Returns:



5656
5657
5658
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5656

def export_data_statistics
  @export_data_statistics
end

#external_service_costs ⇒ Array<Google::Apis::BigqueryV2::ExternalServiceCost>

Output only. Job cost breakdown as bigquery internal cost and external service costs. Corresponds to the JSON property externalServiceCosts

Returns:



5662
5663
5664
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5662

def external_service_costs
  @external_service_costs
end

#load_query_statistics ⇒ Google::Apis::BigqueryV2::LoadQueryStatistics

Statistics for a LOAD query. Corresponds to the JSON property loadQueryStatistics

Returns:



5667
5668
5669
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5667

def load_query_statistics
  @load_query_statistics
end

#materialized_view_statistics ⇒ Google::Apis::BigqueryV2::MaterializedViewStatistics

Statistics of materialized views considered in a query job. Corresponds to the JSON property materializedViewStatistics

Returns:



5672
5673
5674
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5672

def materialized_view_statistics
  @materialized_view_statistics
end

#metadata_cache_statistics ⇒ Google::Apis::BigqueryV2::MetadataCacheStatistics

Statistics for metadata caching in BigLake tables. Corresponds to the JSON property metadataCacheStatistics

Returns:



5677
5678
5679
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5677

def metadata_cache_statistics
  @metadata_cache_statistics
end

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

Job statistics specific to a BigQuery ML training job. Corresponds to the JSON property mlStatistics

Returns:



5682
5683
5684
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5682

def ml_statistics
  @ml_statistics
end

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

Deprecated. Corresponds to the JSON property modelTraining

Returns:



5687
5688
5689
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5687

def model_training
  @model_training
end

#model_training_current_iteration ⇒ Fixnum

Deprecated. Corresponds to the JSON property modelTrainingCurrentIteration

Returns:

  • (Fixnum) 


5692
5693
5694
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5692

def model_training_current_iteration
  @model_training_current_iteration
end

#model_training_expected_total_iteration ⇒ Fixnum

Deprecated. Corresponds to the JSON property modelTrainingExpectedTotalIteration

Returns:

  • (Fixnum) 


5697
5698
5699
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5697

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) 


5703
5704
5705
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5703

def num_dml_affected_rows
  @num_dml_affected_rows
end

#performance_insights ⇒ Google::Apis::BigqueryV2::PerformanceInsights

Performance insights for the job. Corresponds to the JSON property performanceInsights

Returns:



5708
5709
5710
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5708

def performance_insights
  @performance_insights
end

#query_info ⇒ Google::Apis::BigqueryV2::QueryInfo

Query optimization information for a QUERY job. Corresponds to the JSON property queryInfo

Returns:



5713
5714
5715
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5713

def query_info
  @query_info
end

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

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

Returns:



5718
5719
5720
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5718

def query_plan
  @query_plan
end

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

Output only. Referenced routines for the job. Corresponds to the JSON property referencedRoutines

Returns:



5723
5724
5725
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5723

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:



5729
5730
5731
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5729

def referenced_tables
  @referenced_tables
end

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

Output only. Job resource usage breakdown by reservation. This field reported misleading information and will no longer be populated. Corresponds to the JSON property reservationUsage

Returns:



5735
5736
5737
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5735

def reservation_usage
  @reservation_usage
end

#schema ⇒ Google::Apis::BigqueryV2::TableSchema

Schema of a table Corresponds to the JSON property schema

Returns:



5740
5741
5742
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5740

def schema
  @schema
end

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

Statistics for a search query. Populated as part of JobStatistics2. Corresponds to the JSON property searchStatistics

Returns:



5745
5746
5747
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5745

def search_statistics
  @search_statistics
end

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

Statistics for a BigSpark query. Populated as part of JobStatistics2 Corresponds to the JSON property sparkStatistics

Returns:



5750
5751
5752
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5750

def spark_statistics
  @spark_statistics
end

#statement_type ⇒ String

Output only. The type of query statement, if valid. Possible values: * SELECT : SELECT statement. * ASSERT: ASSERT statement. * INSERT: INSERT statement. * UPDATE: UPDATE statement. * DELETE: DELETE statement. * MERGE: MERGE statement. * CREATE_TABLE: CREATE TABLE statement, without AS SELECT. * CREATE_TABLE_AS_SELECT: CREATE TABLE AS SELECT statement. * CREATE_VIEW: CREATE VIEW statement. * CREATE_MODEL: CREATE MODEL statement. * CREATE_MATERIALIZED_VIEW: CREATE MATERIALIZED VIEW statement. * CREATE_FUNCTION: CREATE FUNCTION statement. * CREATE_TABLE_FUNCTION: CREATE TABLE FUNCTION statement. * CREATE_PROCEDURE: CREATE PROCEDURE statement. * CREATE_ROW_ACCESS_POLICY: CREATE ROW ACCESS POLICY statement. * CREATE_SCHEMA: CREATE SCHEMA statement. * CREATE_SNAPSHOT_TABLE: CREATE SNAPSHOT TABLE statement. * CREATE_SEARCH_INDEX: CREATE SEARCH INDEX statement. * DROP_TABLE: DROP TABLE statement. * DROP_EXTERNAL_TABLE: DROP EXTERNAL TABLE statement. * DROP_VIEW: DROP VIEW statement. * DROP_MODEL: DROP MODEL statement. * DROP_MATERIALIZED_VIEW: DROP MATERIALIZED VIEW statement. * DROP_FUNCTION : DROP FUNCTION statement. * DROP_TABLE_FUNCTION : DROP TABLE FUNCTION statement. * DROP_PROCEDURE: DROP PROCEDURE statement. * DROP_SEARCH_INDEX: DROP SEARCH INDEX statement. * DROP_SCHEMA: DROP SCHEMA statement. * DROP_SNAPSHOT_TABLE: DROP SNAPSHOT TABLE statement. * DROP_ROW_ACCESS_POLICY: DROP [ ALL] ROW ACCESS POLICY|POLICIES statement. * ALTER_TABLE: ALTER TABLE statement. * ALTER_VIEW: ALTER VIEW statement. * ALTER_MATERIALIZED_VIEW: ALTER MATERIALIZED VIEW statement. * ALTER_SCHEMA: ALTER SCHEMA statement. * SCRIPT: SCRIPT. * TRUNCATE_TABLE: TRUNCATE TABLE statement. * CREATE_EXTERNAL_TABLE: CREATE EXTERNAL TABLE statement. * EXPORT_DATA: EXPORT DATA statement. * EXPORT_MODEL: EXPORT MODEL statement. * LOAD_DATA: LOAD DATA statement. * CALL: CALL statement. Corresponds to the JSON property statementType

Returns:

  • (String) 


5831
5832
5833
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5831

def statement_type
  @statement_type
end

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

Output only. Describes a timeline of job execution. Corresponds to the JSON property timeline

Returns:



5836
5837
5838
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5836

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

Output only. If the project is configured to use on-demand pricing, then this field contains the total bytes billed for the job. If the project is configured to use flat-rate pricing, then you are not billed for bytes and this field is informational only. Corresponds to the JSON property totalBytesBilled

Returns:

  • (Fixnum) 


5844
5845
5846
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5844

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) 


5849
5850
5851
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5849

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) 


5858
5859
5860
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5858

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) 


5864
5865
5866
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5864

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) 


5869
5870
5871
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5869

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) 


5875
5876
5877
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5875

def transferred_bytes
  @transferred_bytes
end

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

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

Returns:



5881
5882
5883
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5881

def undeclared_query_parameters
  @undeclared_query_parameters
end

#vector_search_statistics ⇒ Google::Apis::BigqueryV2::VectorSearchStatistics

Statistics for a vector search query. Populated as part of JobStatistics2. Corresponds to the JSON property vectorSearchStatistics

Returns:



5886
5887
5888
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5886

def vector_search_statistics
  @vector_search_statistics
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



5893
5894
5895
5896
5897
5898
5899
5900
5901
5902
5903
5904
5905
5906
5907
5908
5909
5910
5911
5912
5913
5914
5915
5916
5917
5918
5919
5920
5921
5922
5923
5924
5925
5926
5927
5928
5929
5930
5931
5932
5933
5934
5935
5936
5937
5938
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5893

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)
  @dcl_target_dataset = args[:dcl_target_dataset] if args.key?(:dcl_target_dataset)
  @dcl_target_table = args[:dcl_target_table] if args.key?(:dcl_target_table)
  @dcl_target_view = args[:dcl_target_view] if args.key?(:dcl_target_view)
  @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)
  @export_data_statistics = args[:export_data_statistics] if args.key?(:export_data_statistics)
  @external_service_costs = args[:external_service_costs] if args.key?(:external_service_costs)
  @load_query_statistics = args[:load_query_statistics] if args.key?(:load_query_statistics)
  @materialized_view_statistics = args[:materialized_view_statistics] if args.key?(:materialized_view_statistics)
  @metadata_cache_statistics = args[:metadata_cache_statistics] if args.key?(:metadata_cache_statistics)
  @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)
  @performance_insights = args[:performance_insights] if args.key?(:performance_insights)
  @query_info = args[:query_info] if args.key?(:query_info)
  @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)
  @vector_search_statistics = args[:vector_search_statistics] if args.key?(:vector_search_statistics)
end