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.



5028
5029
5030
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5028

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:



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

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) 


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

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) 


4836
4837
4838
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4836

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) 


4843
4844
4845
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4843

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:



4849
4850
4851
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4849

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) 


4860
4861
4862
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4860

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:



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

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:



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

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:



4878
4879
4880
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4878

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:



4884
4885
4886
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4884

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:



4890
4891
4892
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4890

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) 


4895
4896
4897
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4895

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:



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

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:



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

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) 


4910
4911
4912
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4910

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) 


4915
4916
4917
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4915

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) 


4921
4922
4923
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4921

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:



4926
4927
4928
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4926

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:



4932
4933
4934
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4932

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:



4938
4939
4940
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4938

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:



4943
4944
4945
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4943

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:



4949
4950
4951
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4949

def schema
  @schema
end

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

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

Returns:



4954
4955
4956
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4954

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:



4959
4960
4961
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4959

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) 


4979
4980
4981
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4979

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:



4984
4985
4986
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4984

def timeline
  @timeline
end

#total_bytes_billed ⇒ Fixnum

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

Returns:

  • (Fixnum) 


4989
4990
4991
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4989

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) 


4994
4995
4996
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4994

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) 


5003
5004
5005
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5003

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) 


5009
5010
5011
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5009

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) 


5014
5015
5016
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5014

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) 


5020
5021
5022
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5020

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:



5026
5027
5028
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5026

def undeclared_query_parameters
  @undeclared_query_parameters
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



5033
5034
5035
5036
5037
5038
5039
5040
5041
5042
5043
5044
5045
5046
5047
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 5033

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