Class: Google::Apis::BigqueryV2::JobStatistics2
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::JobStatistics2
- 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
-
#bi_engine_statistics ⇒ Google::Apis::BigqueryV2::BiEngineStatistics
BI Engine specific Statistics.
-
#billing_tier ⇒ Fixnum
[Output-only] Billing tier for the job.
-
#cache_hit ⇒ Boolean
(also: #cache_hit?)
[Output-only] Whether the query result was fetched from the query cache.
-
#ddl_affected_row_access_policy_count ⇒ Fixnum
[Output-only] [Preview] The number of row access policies affected by a DDL statement.
-
#ddl_destination_table ⇒ Google::Apis::BigqueryV2::TableReference
[Output-only] The DDL destination table.
-
#ddl_operation_performed ⇒ String
The DDL operation performed, possibly dependent on the pre-existence of the DDL target.
-
#ddl_target_dataset ⇒ Google::Apis::BigqueryV2::DatasetReference
[Output-only] The DDL target dataset.
-
#ddl_target_routine ⇒ Google::Apis::BigqueryV2::RoutineReference
The DDL target routine.
-
#ddl_target_row_access_policy ⇒ Google::Apis::BigqueryV2::RowAccessPolicyReference
[Output-only] [Preview] The DDL target row access policy.
-
#ddl_target_table ⇒ Google::Apis::BigqueryV2::TableReference
[Output-only] The DDL target table.
-
#dml_stats ⇒ Google::Apis::BigqueryV2::DmlStatistics
[Output-only] Detailed statistics for DML statements Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE.
-
#estimated_bytes_processed ⇒ Fixnum
[Output-only] The original estimate of bytes processed for the job.
-
#model_training ⇒ Google::Apis::BigqueryV2::BigQueryModelTraining
[Output-only, Beta] Information about create model query job progress.
-
#model_training_current_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
-
#model_training_expected_total_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
-
#num_dml_affected_rows ⇒ Fixnum
[Output-only] The number of rows affected by a DML statement.
-
#query_plan ⇒ Array<Google::Apis::BigqueryV2::ExplainQueryStage>
[Output-only] Describes execution plan for the query.
-
#referenced_routines ⇒ Array<Google::Apis::BigqueryV2::RoutineReference>
[Output-only] Referenced routines (persistent user-defined functions and stored procedures) for the job.
-
#referenced_tables ⇒ Array<Google::Apis::BigqueryV2::TableReference>
[Output-only] Referenced tables for the job.
-
#reservation_usage ⇒ Array<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>
[Output-only] Job resource usage breakdown by reservation.
-
#schema ⇒ Google::Apis::BigqueryV2::TableSchema
[Output-only] The schema of the results.
-
#statement_type ⇒ String
The type of query statement, if valid.
-
#timeline ⇒ Array<Google::Apis::BigqueryV2::QueryTimelineSample>
[Output-only] [Beta] Describes a timeline of job execution.
-
#total_bytes_billed ⇒ Fixnum
[Output-only] Total bytes billed for the job.
-
#total_bytes_processed ⇒ Fixnum
[Output-only] Total bytes processed for the job.
-
#total_bytes_processed_accuracy ⇒ String
[Output-only] For dry-run jobs, totalBytesProcessed is an estimate and this field specifies the accuracy of the estimate.
-
#total_partitions_processed ⇒ Fixnum
[Output-only] Total number of partitions processed from all partitioned tables referenced in the job.
-
#total_slot_ms ⇒ Fixnum
[Output-only] Slot-milliseconds for the job.
-
#undeclared_query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>
Standard SQL only: list of undeclared query parameters detected during a dry run validation.
Instance Method Summary collapse
-
#initialize(**args) ⇒ JobStatistics2
constructor
A new instance of JobStatistics2.
-
#update!(**args) ⇒ Object
Update properties of this object.
Constructor Details
#initialize(**args) ⇒ JobStatistics2
Returns a new instance of JobStatistics2.
4195 4196 4197 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4195 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
4014 4015 4016 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4014 def bi_engine_statistics @bi_engine_statistics end |
#billing_tier ⇒ Fixnum
[Output-only] Billing tier for the job.
Corresponds to the JSON property billingTier
4019 4020 4021 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4019 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
4024 4025 4026 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4024 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
4031 4032 4033 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4031 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
4037 4038 4039 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4037 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
4048 4049 4050 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4048 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
4054 4055 4056 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4054 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
4060 4061 4062 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4060 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
4066 4067 4068 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4066 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
4072 4073 4074 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4072 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
4078 4079 4080 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4078 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
4083 4084 4085 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4083 def estimated_bytes_processed @estimated_bytes_processed end |
#model_training ⇒ Google::Apis::BigqueryV2::BigQueryModelTraining
[Output-only, Beta] Information about create model query job progress.
Corresponds to the JSON property modelTraining
4088 4089 4090 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4088 def model_training @model_training end |
#model_training_current_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
Corresponds to the JSON property modelTrainingCurrentIteration
4093 4094 4095 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4093 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
4098 4099 4100 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4098 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
4104 4105 4106 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4104 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
4109 4110 4111 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4109 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
4115 4116 4117 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4115 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
4121 4122 4123 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4121 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
4126 4127 4128 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4126 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
4132 4133 4134 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4132 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
4152 4153 4154 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4152 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
4157 4158 4159 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4157 def timeline @timeline end |
#total_bytes_billed ⇒ Fixnum
[Output-only] Total bytes billed for the job.
Corresponds to the JSON property totalBytesBilled
4162 4163 4164 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4162 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
4167 4168 4169 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4167 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
4176 4177 4178 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4176 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
4182 4183 4184 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4182 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
4187 4188 4189 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4187 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
4193 4194 4195 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4193 def undeclared_query_parameters @undeclared_query_parameters end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 4200 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) @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 |