View Source GoogleApi.BigQuery.V2.Model.JobStatistics2 (google_api_big_query v0.79.0)
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, withoutAS 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.
Summary
Functions
Unwrap a decoded JSON object into its complex fields.
Types
@type t() :: %GoogleApi.BigQuery.V2.Model.JobStatistics2{ biEngineStatistics: GoogleApi.BigQuery.V2.Model.BiEngineStatistics.t() | nil, billingTier: integer() | nil, cacheHit: boolean() | nil, dclTargetDataset: GoogleApi.BigQuery.V2.Model.DatasetReference.t() | nil, dclTargetTable: GoogleApi.BigQuery.V2.Model.TableReference.t() | nil, dclTargetView: GoogleApi.BigQuery.V2.Model.TableReference.t() | nil, ddlAffectedRowAccessPolicyCount: String.t() | nil, ddlDestinationTable: GoogleApi.BigQuery.V2.Model.TableReference.t() | nil, ddlOperationPerformed: String.t() | nil, ddlTargetDataset: GoogleApi.BigQuery.V2.Model.DatasetReference.t() | nil, ddlTargetRoutine: GoogleApi.BigQuery.V2.Model.RoutineReference.t() | nil, ddlTargetRowAccessPolicy: GoogleApi.BigQuery.V2.Model.RowAccessPolicyReference.t() | nil, ddlTargetTable: GoogleApi.BigQuery.V2.Model.TableReference.t() | nil, dmlStats: GoogleApi.BigQuery.V2.Model.DmlStatistics.t() | nil, estimatedBytesProcessed: String.t() | nil, exportDataStatistics: GoogleApi.BigQuery.V2.Model.ExportDataStatistics.t() | nil, externalServiceCosts: [GoogleApi.BigQuery.V2.Model.ExternalServiceCost.t()] | nil, loadQueryStatistics: GoogleApi.BigQuery.V2.Model.LoadQueryStatistics.t() | nil, materializedViewStatistics: GoogleApi.BigQuery.V2.Model.MaterializedViewStatistics.t() | nil, metadataCacheStatistics: GoogleApi.BigQuery.V2.Model.MetadataCacheStatistics.t() | nil, mlStatistics: GoogleApi.BigQuery.V2.Model.MlStatistics.t() | nil, modelTraining: GoogleApi.BigQuery.V2.Model.BigQueryModelTraining.t() | nil, modelTrainingCurrentIteration: integer() | nil, modelTrainingExpectedTotalIteration: String.t() | nil, numDmlAffectedRows: String.t() | nil, performanceInsights: GoogleApi.BigQuery.V2.Model.PerformanceInsights.t() | nil, queryInfo: GoogleApi.BigQuery.V2.Model.QueryInfo.t() | nil, queryPlan: [GoogleApi.BigQuery.V2.Model.ExplainQueryStage.t()] | nil, referencedRoutines: [GoogleApi.BigQuery.V2.Model.RoutineReference.t()] | nil, referencedTables: [GoogleApi.BigQuery.V2.Model.TableReference.t()] | nil, reservationUsage: [GoogleApi.BigQuery.V2.Model.JobStatistics2ReservationUsage.t()] | nil, schema: GoogleApi.BigQuery.V2.Model.TableSchema.t() | nil, searchStatistics: GoogleApi.BigQuery.V2.Model.SearchStatistics.t() | nil, sparkStatistics: GoogleApi.BigQuery.V2.Model.SparkStatistics.t() | nil, statementType: String.t() | nil, timeline: [GoogleApi.BigQuery.V2.Model.QueryTimelineSample.t()] | nil, totalBytesBilled: String.t() | nil, totalBytesProcessed: String.t() | nil, totalBytesProcessedAccuracy: String.t() | nil, totalPartitionsProcessed: String.t() | nil, totalSlotMs: String.t() | nil, transferredBytes: String.t() | nil, undeclaredQueryParameters: [GoogleApi.BigQuery.V2.Model.QueryParameter.t()] | nil, vectorSearchStatistics: GoogleApi.BigQuery.V2.Model.VectorSearchStatistics.t() | nil }
Functions
Unwrap a decoded JSON object into its complex fields.