JobStatistics2Response

data class JobStatistics2Response(val biEngineStatistics: BiEngineStatisticsResponse, val billingTier: Int, val cacheHit: Boolean, val ddlAffectedRowAccessPolicyCount: String, val ddlDestinationTable: TableReferenceResponse, val ddlOperationPerformed: String, val ddlTargetDataset: DatasetReferenceResponse, val ddlTargetRoutine: RoutineReferenceResponse, val ddlTargetRowAccessPolicy: RowAccessPolicyReferenceResponse, val ddlTargetTable: TableReferenceResponse, val dmlStats: DmlStatisticsResponse, val estimatedBytesProcessed: String, val mlStatistics: MlStatisticsResponse, val modelTraining: BigQueryModelTrainingResponse, val modelTrainingCurrentIteration: Int, val modelTrainingExpectedTotalIteration: String, val numDmlAffectedRows: String, val queryPlan: List<ExplainQueryStageResponse>, val referencedRoutines: List<RoutineReferenceResponse>, val referencedTables: List<TableReferenceResponse>, val reservationUsage: List<JobStatistics2ReservationUsageItemResponse>, val schema: TableSchemaResponse, val searchStatistics: SearchStatisticsResponse, val sparkStatistics: SparkStatisticsResponse, val statementType: String, val timeline: List<QueryTimelineSampleResponse>, val totalBytesBilled: String, val totalBytesProcessed: String, val totalBytesProcessedAccuracy: String, val totalPartitionsProcessed: String, val totalSlotMs: String, val transferredBytes: String, val undeclaredQueryParameters: List<QueryParameterResponse>)

Constructors

Link copied to clipboard
constructor(biEngineStatistics: BiEngineStatisticsResponse, billingTier: Int, cacheHit: Boolean, ddlAffectedRowAccessPolicyCount: String, ddlDestinationTable: TableReferenceResponse, ddlOperationPerformed: String, ddlTargetDataset: DatasetReferenceResponse, ddlTargetRoutine: RoutineReferenceResponse, ddlTargetRowAccessPolicy: RowAccessPolicyReferenceResponse, ddlTargetTable: TableReferenceResponse, dmlStats: DmlStatisticsResponse, estimatedBytesProcessed: String, mlStatistics: MlStatisticsResponse, modelTraining: BigQueryModelTrainingResponse, modelTrainingCurrentIteration: Int, modelTrainingExpectedTotalIteration: String, numDmlAffectedRows: String, queryPlan: List<ExplainQueryStageResponse>, referencedRoutines: List<RoutineReferenceResponse>, referencedTables: List<TableReferenceResponse>, reservationUsage: List<JobStatistics2ReservationUsageItemResponse>, schema: TableSchemaResponse, searchStatistics: SearchStatisticsResponse, sparkStatistics: SparkStatisticsResponse, statementType: String, timeline: List<QueryTimelineSampleResponse>, totalBytesBilled: String, totalBytesProcessed: String, totalBytesProcessedAccuracy: String, totalPartitionsProcessed: String, totalSlotMs: String, transferredBytes: String, undeclaredQueryParameters: List<QueryParameterResponse>)

Types

Link copied to clipboard
object Companion

Properties

Link copied to clipboard

BI Engine specific Statistics. Output only BI Engine specific Statistics.

Link copied to clipboard

Output only Billing tier for the job.

Link copied to clipboard

Output only Whether the query result was fetched from the query cache.

Link copied to clipboard

Preview The number of row access policies affected by a DDL statement. Present only for DROP ALL ROW ACCESS POLICIES queries.

Link copied to clipboard

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.

Link copied to clipboard

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.

Link copied to clipboard

Output only The DDL target dataset. Present only for CREATE/ALTER/DROP SCHEMA queries.

Link copied to clipboard

The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries.

Link copied to clipboard

Preview The DDL target row access policy. Present only for CREATE/DROP ROW ACCESS POLICY queries.

Link copied to clipboard

Output only The DDL target table. Present only for CREATE/DROP TABLE/VIEW and DROP ALL ROW ACCESS POLICIES queries.

Link copied to clipboard

Output only Detailed statistics for DML statements Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE.

Link copied to clipboard

Output only The original estimate of bytes processed for the job.

Link copied to clipboard

Output only Statistics of a BigQuery ML training job.

Link copied to clipboard

Output only, Beta Information about create model query job progress.

Link copied to clipboard

Output only, Beta Deprecated; do not use.

Link copied to clipboard

Output only, Beta Deprecated; do not use.

Link copied to clipboard

Output only The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.

Link copied to clipboard

Output only Describes execution plan for the query.

Link copied to clipboard

Output only Referenced routines (persistent user-defined functions and stored procedures) for the job.

Link copied to clipboard

Output only Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.

Link copied to clipboard

Output only Job resource usage breakdown by reservation.

Link copied to clipboard

Output only The schema of the results. Present only for successful dry run of non-legacy SQL queries.

Link copied to clipboard

Output only Search query specific statistics.

Link copied to clipboard

Output only Statistics of a Spark procedure job.

Link copied to clipboard

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.

Link copied to clipboard

Beta Describes a timeline of job execution.

Link copied to clipboard

Output only Total bytes billed for the job.

Link copied to clipboard

Output only Total bytes processed for the job.

Link copied to clipboard

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.

Link copied to clipboard

Output only Total number of partitions processed from all partitioned tables referenced in the job.

Link copied to clipboard

Output only Slot-milliseconds for the job.

Link copied to clipboard

Total bytes transferred for cross-cloud queries such as Cross Cloud Transfer and CREATE TABLE AS SELECT (CTAS).

Link copied to clipboard

Standard SQL only: list of undeclared query parameters detected during a dry run validation.