JobStatistics2Response class
Constructors
-
JobStatistics2Response({required Input<BiEngineStatisticsResponse> biEngineStatistics, required Input<int> billingTier, required Input<bool> cacheHit, required Input<String> ddlAffectedRowAccessPolicyCount, required Input<TableReferenceResponse> ddlDestinationTable, required Input<String> ddlOperationPerformed, required Input<DatasetReferenceResponse> ddlTargetDataset, required Input<RoutineReferenceResponse> ddlTargetRoutine, required Input<RowAccessPolicyReferenceResponse> ddlTargetRowAccessPolicy, required Input<TableReferenceResponse> ddlTargetTable, required Input<DmlStatisticsResponse> dmlStats, required Input<String> estimatedBytesProcessed, required Input<MlStatisticsResponse> mlStatistics, required Input<BigQueryModelTrainingResponse> modelTraining, required Input<int> modelTrainingCurrentIteration, required Input<String> modelTrainingExpectedTotalIteration, required Input<String> numDmlAffectedRows, required Input<List<ExplainQueryStageResponse>> queryPlan, required Input<List<RoutineReferenceResponse>> referencedRoutines, required Input<List<TableReferenceResponse>> referencedTables, required Input<List<JobStatistics2ReservationUsageItemResponse>> reservationUsage, required Input<TableSchemaResponse> schema, required Input<SearchStatisticsResponse> searchStatistics, required Input<SparkStatisticsResponse> sparkStatistics, required Input<String> statementType, required Input<List<QueryTimelineSampleResponse>> timeline, required Input<String> totalBytesBilled, required Input<String> totalBytesProcessed, required Input<String> totalBytesProcessedAccuracy, required Input<String> totalPartitionsProcessed, required Input<String> totalSlotMs, required Input<String> transferredBytes, required Input<List<QueryParameterResponse>> undeclaredQueryParameters})
-
Creates a new JobStatistics2Response.
biEngineStatistics BI Engine specific Statistics. Output only BI Engine specific Statistics.
billingTier Output only Billing tier for the job.
cacheHit Output only Whether the query result was fetched from the query cache.
ddlAffectedRowAccessPolicyCount Output only Preview The number of row access policies affected by a DDL statement. Present only for DROP ALL ROW ACCESS POLICIES queries.
ddlDestinationTable 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.
ddlOperationPerformed 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.
ddlTargetDataset Output only The DDL target dataset. Present only for CREATE/ALTER/DROP/UNDROP SCHEMA queries.
ddlTargetRoutine The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries.
ddlTargetRowAccessPolicy Output only Preview The DDL target row access policy. Present only for CREATE/DROP ROW ACCESS POLICY queries.
ddlTargetTable Output only The DDL target table. Present only for CREATE/DROP TABLE/VIEW and DROP ALL ROW ACCESS POLICIES queries.
dmlStats Output only Detailed statistics for DML statements Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE.
estimatedBytesProcessed Output only The original estimate of bytes processed for the job.
mlStatistics Output only Statistics of a BigQuery ML training job.
modelTraining Output only, Beta Information about create model query job progress.
modelTrainingCurrentIteration Output only, Beta Deprecated; do not use.
modelTrainingExpectedTotalIteration Output only, Beta Deprecated; do not use.
numDmlAffectedRows Output only The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.
queryPlan Output only Describes execution plan for the query.
referencedRoutines Output only Referenced routines (persistent user-defined functions and stored procedures) for the job.
referencedTables Output only Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.
reservationUsage Output only Job resource usage breakdown by reservation.
schema Output only The schema of the results. Present only for successful dry run of non-legacy SQL queries.
searchStatistics Output only Search query specific statistics.
sparkStatistics Output only Statistics of a Spark procedure job.
statementType 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.
timeline Output only Beta Describes a timeline of job execution.
totalBytesBilled Output only Total bytes billed for the job.
totalBytesProcessed Output only Total bytes processed for the job.
totalBytesProcessedAccuracy 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.
totalPartitionsProcessed Output only Total number of partitions processed from all partitioned tables referenced in the job.
totalSlotMs Output only Slot-milliseconds for the job.
transferredBytes Total bytes transferred for cross-cloud queries such as Cross Cloud Transfer and CREATE TABLE AS SELECT (CTAS).
undeclaredQueryParameters Standard SQL only: list of undeclared query parameters detected during a dry run validation.
const
-
JobStatistics2Response.fromMap(Map<String, dynamic> map)
-
factory
Properties
-
biEngineStatistics
→ Input<BiEngineStatisticsResponse>
-
BI Engine specific Statistics.
Output only BI Engine specific Statistics.
final
-
billingTier
→ Input<int>
-
Output only Billing tier for the job.
final
-
cacheHit
→ Input<bool>
-
Output only Whether the query result was fetched from the query cache.
final
-
ddlAffectedRowAccessPolicyCount
→ Input<String>
-
Output only Preview The number of row access policies affected by a DDL statement. Present only for DROP ALL ROW ACCESS POLICIES queries.
final
-
ddlDestinationTable
→ Input<TableReferenceResponse>
-
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.
final
-
ddlOperationPerformed
→ Input<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.
final
-
ddlTargetDataset
→ Input<DatasetReferenceResponse>
-
Output only The DDL target dataset. Present only for CREATE/ALTER/DROP/UNDROP SCHEMA queries.
final
-
ddlTargetRoutine
→ Input<RoutineReferenceResponse>
-
The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries.
final
-
ddlTargetRowAccessPolicy
→ Input<RowAccessPolicyReferenceResponse>
-
Output only Preview The DDL target row access policy. Present only for CREATE/DROP ROW ACCESS POLICY queries.
final
-
ddlTargetTable
→ Input<TableReferenceResponse>
-
Output only The DDL target table. Present only for CREATE/DROP TABLE/VIEW and DROP ALL ROW ACCESS POLICIES queries.
final
-
dmlStats
→ Input<DmlStatisticsResponse>
-
Output only Detailed statistics for DML statements Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE.
final
-
estimatedBytesProcessed
→ Input<String>
-
Output only The original estimate of bytes processed for the job.
final
-
hashCode
→ int
-
The hash code for this object.
no setterinherited
-
mlStatistics
→ Input<MlStatisticsResponse>
-
Output only Statistics of a BigQuery ML training job.
final
-
modelTraining
→ Input<BigQueryModelTrainingResponse>
-
Output only, Beta Information about create model query job progress.
final
-
modelTrainingCurrentIteration
→ Input<int>
-
Output only, Beta Deprecated; do not use.
final
-
modelTrainingExpectedTotalIteration
→ Input<String>
-
Output only, Beta Deprecated; do not use.
final
-
numDmlAffectedRows
→ Input<String>
-
Output only The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.
final
-
queryPlan
→ Input<List<ExplainQueryStageResponse>>
-
Output only Describes execution plan for the query.
final
-
referencedRoutines
→ Input<List<RoutineReferenceResponse>>
-
Output only Referenced routines (persistent user-defined functions and stored procedures) for the job.
final
-
referencedTables
→ Input<List<TableReferenceResponse>>
-
Output only Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.
final
-
reservationUsage
→ Input<List<JobStatistics2ReservationUsageItemResponse>>
-
Output only Job resource usage breakdown by reservation.
final
-
runtimeType
→ Type
-
A representation of the runtime type of the object.
no setterinherited
-
schema
→ Input<TableSchemaResponse>
-
Output only The schema of the results. Present only for successful dry run of non-legacy SQL queries.
final
-
searchStatistics
→ Input<SearchStatisticsResponse>
-
Output only Search query specific statistics.
final
-
sparkStatistics
→ Input<SparkStatisticsResponse>
-
Output only Statistics of a Spark procedure job.
final
-
statementType
→ Input<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.
final
-
timeline
→ Input<List<QueryTimelineSampleResponse>>
-
Output only Beta Describes a timeline of job execution.
final
-
totalBytesBilled
→ Input<String>
-
Output only Total bytes billed for the job.
final
-
totalBytesProcessed
→ Input<String>
-
Output only Total bytes processed for the job.
final
-
totalBytesProcessedAccuracy
→ Input<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.
final
-
totalPartitionsProcessed
→ Input<String>
-
Output only Total number of partitions processed from all partitioned tables referenced in the job.
final
-
totalSlotMs
→ Input<String>
-
Output only Slot-milliseconds for the job.
final
-
transferredBytes
→ Input<String>
-
Total bytes transferred for cross-cloud queries such as Cross Cloud Transfer and CREATE TABLE AS SELECT (CTAS).
final
-
undeclaredQueryParameters
→ Input<List<QueryParameterResponse>>
-
Standard SQL only: list of undeclared query parameters detected during a dry run validation.
final
