Statistics for a query job.

Attributes

• billingTier (type: integer(), default: nil) - 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.
• statementType (type: String.t, default: nil) - 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.
• modelTrainingCurrentIteration (type: integer(), default: nil) - Deprecated.
• dclTargetDataset (type: GoogleApi.BigQuery.V2.Model.DatasetReference.t, default: nil) - Output only. Referenced dataset for DCL statement.
• estimatedBytesProcessed (type: String.t, default: nil) - Output only. The original estimate of bytes processed for the job.
• ddlOperationPerformed (type: String.t, default: nil) - Output only. The DDL operation performed, possibly dependent on the pre-existence of the DDL target.
• sparkStatistics (type: GoogleApi.BigQuery.V2.Model.SparkStatistics.t, default: nil) - Output only. Statistics of a Spark procedure job.
• totalSlotMs (type: String.t, default: nil) - Output only. Slot-milliseconds for the job.
• exportDataStatistics (type: GoogleApi.BigQuery.V2.Model.ExportDataStatistics.t, default: nil) - Output only. Stats for EXPORT DATA statement.
• loadQueryStatistics (type: GoogleApi.BigQuery.V2.Model.LoadQueryStatistics.t, default: nil) - Output only. Statistics for a LOAD query.
• ddlTargetTable (type: GoogleApi.BigQuery.V2.Model.TableReference.t, default: nil) - Output only. The DDL target table. Present only for CREATE/DROP TABLE/VIEW and DROP ALL ROW ACCESS POLICIES queries.
• mlStatistics (type: GoogleApi.BigQuery.V2.Model.MlStatistics.t, default: nil) - Output only. Statistics of a BigQuery ML training job.
• biEngineStatistics (type: GoogleApi.BigQuery.V2.Model.BiEngineStatistics.t, default: nil) - Output only. BI Engine specific Statistics.
• totalBytesBilled (type: String.t, default: nil) - 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.
• ddlTargetRowAccessPolicy (type: GoogleApi.BigQuery.V2.Model.RowAccessPolicyReference.t, default: nil) - Output only. The DDL target row access policy. Present only for CREATE/DROP ROW ACCESS POLICY queries.
• externalServiceCosts (type: list(GoogleApi.BigQuery.V2.Model.ExternalServiceCost.t), default: nil) - Output only. Job cost breakdown as bigquery internal cost and external service costs.
• totalBytesProcessed (type: String.t, default: nil) - Output only. Total bytes processed for the job.
• totalPartitionsProcessed (type: String.t, default: nil) - Output only. Total number of partitions processed from all partitioned tables referenced in the job.
• timeline (type: list(GoogleApi.BigQuery.V2.Model.QueryTimelineSample.t), default: nil) - Output only. Describes a timeline of job execution.
• totalBytesProcessedAccuracy (type: String.t, default: nil) - 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.
• queryPlan (type: list(GoogleApi.BigQuery.V2.Model.ExplainQueryStage.t), default: nil) - Output only. Describes execution plan for the query.
• dclTargetView (type: GoogleApi.BigQuery.V2.Model.TableReference.t, default: nil) - Output only. Referenced view for DCL statement.
• modelTraining (type: GoogleApi.BigQuery.V2.Model.BigQueryModelTraining.t, default: nil) - Deprecated.
• ddlTargetDataset (type: GoogleApi.BigQuery.V2.Model.DatasetReference.t, default: nil) - Output only. The DDL target dataset. Present only for CREATE/ALTER/DROP SCHEMA(dataset) queries.
• numDmlAffectedRows (type: String.t, default: nil) - Output only. The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.
• metadataCacheStatistics (type: GoogleApi.BigQuery.V2.Model.MetadataCacheStatistics.t, default: nil) - Output only. Statistics of metadata cache usage in a query for BigLake tables.
• cacheHit (type: boolean(), default: nil) - Output only. Whether the query result was fetched from the query cache.
• schema (type: GoogleApi.BigQuery.V2.Model.TableSchema.t, default: nil) - Output only. The schema of the results. Present only for successful dry run of non-legacy SQL queries.
• dclTargetTable (type: GoogleApi.BigQuery.V2.Model.TableReference.t, default: nil) - Output only. Referenced table for DCL statement.
• materializedViewStatistics (type: GoogleApi.BigQuery.V2.Model.MaterializedViewStatistics.t, default: nil) - Output only. Statistics of materialized views of a query job.
• undeclaredQueryParameters (type: list(GoogleApi.BigQuery.V2.Model.QueryParameter.t), default: nil) - Output only. GoogleSQL only: list of undeclared query parameters detected during a dry run validation.
• ddlDestinationTable (type: GoogleApi.BigQuery.V2.Model.TableReference.t, default: nil) - Output only. The table after rename. Present only for ALTER TABLE RENAME TO query.
• queryInfo (type: GoogleApi.BigQuery.V2.Model.QueryInfo.t, default: nil) - Output only. Query optimization information for a QUERY job.
• ddlAffectedRowAccessPolicyCount (type: String.t, default: nil) - Output only. The number of row access policies affected by a DDL statement. Present only for DROP ALL ROW ACCESS POLICIES queries.
• reservationUsage (type: list(GoogleApi.BigQuery.V2.Model.JobStatistics2ReservationUsage.t), default: nil) - Output only. Job resource usage breakdown by reservation. This field reported misleading information and will no longer be populated.
• referencedRoutines (type: list(GoogleApi.BigQuery.V2.Model.RoutineReference.t), default: nil) - Output only. Referenced routines for the job.
• transferredBytes (type: String.t, default: nil) - Output only. Total bytes transferred for cross-cloud queries such as Cross Cloud Transfer and CREATE TABLE AS SELECT (CTAS).
• searchStatistics (type: GoogleApi.BigQuery.V2.Model.SearchStatistics.t, default: nil) - Output only. Search query specific statistics.
• vectorSearchStatistics (type: GoogleApi.BigQuery.V2.Model.VectorSearchStatistics.t, default: nil) - Output only. Vector Search query specific statistics.
• referencedTables (type: list(GoogleApi.BigQuery.V2.Model.TableReference.t), default: nil) - Output only. Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.
• ddlTargetRoutine (type: GoogleApi.BigQuery.V2.Model.RoutineReference.t, default: nil) - Output only. [Beta] The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries.
• modelTrainingExpectedTotalIteration (type: String.t, default: nil) - Deprecated.
• performanceInsights (type: GoogleApi.BigQuery.V2.Model.PerformanceInsights.t, default: nil) - Output only. Performance insights.
• dmlStats (type: GoogleApi.BigQuery.V2.Model.DmlStatistics.t, default: nil) - Output only. Detailed statistics for DML statements INSERT, UPDATE, DELETE, MERGE or TRUNCATE.