Class JobStatistics2

Statistics for a query job.

Inheritance

object

JobStatistics2

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Bigquery.v2.Data

Assembly: Google.Apis.Bigquery.v2.dll

Syntax

public class JobStatistics2 : IDirectResponseSchema

Properties

BiEngineStatistics

Output only. BI Engine specific Statistics.

Declaration

[JsonProperty("biEngineStatistics")]
public virtual BiEngineStatistics BiEngineStatistics { get; set; }

Property Value

Type	Description
BiEngineStatistics

BillingTier

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.

Declaration

[JsonProperty("billingTier")]
public virtual int? BillingTier { get; set; }

Property Value

Type	Description
int?

CacheHit

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

Declaration

[JsonProperty("cacheHit")]
public virtual bool? CacheHit { get; set; }

Property Value

Type	Description
bool?

DclTargetDataset

Output only. Referenced dataset for DCL statement.

Declaration

[JsonProperty("dclTargetDataset")]
public virtual DatasetReference DclTargetDataset { get; set; }

Property Value

Type	Description
DatasetReference

DclTargetTable

Output only. Referenced table for DCL statement.

Declaration

[JsonProperty("dclTargetTable")]
public virtual TableReference DclTargetTable { get; set; }

Property Value

Type	Description
TableReference

DclTargetView

Output only. Referenced view for DCL statement.

Declaration

[JsonProperty("dclTargetView")]
public virtual TableReference DclTargetView { get; set; }

Property Value

Type	Description
TableReference

DdlAffectedRowAccessPolicyCount

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

Declaration

[JsonProperty("ddlAffectedRowAccessPolicyCount")]
public virtual long? DdlAffectedRowAccessPolicyCount { get; set; }

Property Value

Type	Description
long?

DdlDestinationTable

Output only. The table after rename. Present only for ALTER TABLE RENAME TO query.

Declaration

[JsonProperty("ddlDestinationTable")]
public virtual TableReference DdlDestinationTable { get; set; }

Property Value

Type	Description
TableReference

DdlOperationPerformed

Output only. The DDL operation performed, possibly dependent on the pre-existence of the DDL target.

Declaration

[JsonProperty("ddlOperationPerformed")]
public virtual string DdlOperationPerformed { get; set; }

Property Value

Type	Description
string

DdlTargetDataset

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

Declaration

[JsonProperty("ddlTargetDataset")]
public virtual DatasetReference DdlTargetDataset { get; set; }

Property Value

Type	Description
DatasetReference

DdlTargetRoutine

Output only. [Beta] The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE queries.

Declaration

[JsonProperty("ddlTargetRoutine")]
public virtual RoutineReference DdlTargetRoutine { get; set; }

Property Value

Type	Description
RoutineReference

DdlTargetRowAccessPolicy

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

Declaration

[JsonProperty("ddlTargetRowAccessPolicy")]
public virtual RowAccessPolicyReference DdlTargetRowAccessPolicy { get; set; }

Property Value

Type	Description
RowAccessPolicyReference

DdlTargetTable

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

Declaration

[JsonProperty("ddlTargetTable")]
public virtual TableReference DdlTargetTable { get; set; }

Property Value

Type	Description
TableReference

DmlStats

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

Declaration

[JsonProperty("dmlStats")]
public virtual DmlStatistics DmlStats { get; set; }

Property Value

Type	Description
DmlStatistics

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

EstimatedBytesProcessed

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

Declaration

[JsonProperty("estimatedBytesProcessed")]
public virtual long? EstimatedBytesProcessed { get; set; }

Property Value

Type	Description
long?

ExportDataStatistics

Output only. Stats for EXPORT DATA statement.

Declaration

[JsonProperty("exportDataStatistics")]
public virtual ExportDataStatistics ExportDataStatistics { get; set; }

Property Value

Type	Description
ExportDataStatistics

ExternalServiceCosts

Output only. Job cost breakdown as bigquery internal cost and external service costs.

Declaration

[JsonProperty("externalServiceCosts")]
public virtual IList<ExternalServiceCost> ExternalServiceCosts { get; set; }

Property Value

Type	Description
IList<ExternalServiceCost>

IncrementalResultStats

Output only. Statistics related to incremental query results, if enabled for the query. This feature is not yet available.

Declaration

[JsonProperty("incrementalResultStats")]
public virtual IncrementalResultStats IncrementalResultStats { get; set; }

Property Value

Type	Description
IncrementalResultStats

LoadQueryStatistics

Output only. Statistics for a LOAD query.

Declaration

[JsonProperty("loadQueryStatistics")]
public virtual LoadQueryStatistics LoadQueryStatistics { get; set; }

Property Value

Type	Description
LoadQueryStatistics

MaterializedViewStatistics

Output only. Statistics of materialized views of a query job.

Declaration

[JsonProperty("materializedViewStatistics")]
public virtual MaterializedViewStatistics MaterializedViewStatistics { get; set; }

Property Value

Type	Description
MaterializedViewStatistics

MetadataCacheStatistics

Output only. Statistics of metadata cache usage in a query for BigLake tables.

Declaration

[JsonProperty("metadataCacheStatistics")]
public virtual MetadataCacheStatistics MetadataCacheStatistics { get; set; }

Property Value

Type	Description
MetadataCacheStatistics

MlStatistics

Output only. Statistics of a BigQuery ML training job.

Declaration

[JsonProperty("mlStatistics")]
public virtual MlStatistics MlStatistics { get; set; }

Property Value

Type	Description
MlStatistics

ModelTraining

Deprecated.

Declaration

[JsonProperty("modelTraining")]
public virtual BigQueryModelTraining ModelTraining { get; set; }

Property Value

Type	Description
BigQueryModelTraining

ModelTrainingCurrentIteration

Deprecated.

Declaration

[JsonProperty("modelTrainingCurrentIteration")]
public virtual int? ModelTrainingCurrentIteration { get; set; }

Property Value

Type	Description
int?

ModelTrainingExpectedTotalIteration

Deprecated.

Declaration

[JsonProperty("modelTrainingExpectedTotalIteration")]
public virtual long? ModelTrainingExpectedTotalIteration { get; set; }

Property Value

Type	Description
long?

NumDmlAffectedRows

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

Declaration

[JsonProperty("numDmlAffectedRows")]
public virtual long? NumDmlAffectedRows { get; set; }

Property Value

Type	Description
long?

PerformanceInsights

Output only. Performance insights.

Declaration

[JsonProperty("performanceInsights")]
public virtual PerformanceInsights PerformanceInsights { get; set; }

Property Value

Type	Description
PerformanceInsights

QueryInfo

Output only. Query optimization information for a QUERY job.

Declaration

[JsonProperty("queryInfo")]
public virtual QueryInfo QueryInfo { get; set; }

Property Value

Type	Description
QueryInfo

QueryPlan

Output only. Describes execution plan for the query.

Declaration

[JsonProperty("queryPlan")]
public virtual IList<ExplainQueryStage> QueryPlan { get; set; }

Property Value

Type	Description
IList<ExplainQueryStage>

ReferencedRoutines

Output only. Referenced routines for the job.

Declaration

[JsonProperty("referencedRoutines")]
public virtual IList<RoutineReference> ReferencedRoutines { get; set; }

Property Value

Type	Description
IList<RoutineReference>

ReferencedTables

Output only. Referenced tables for the job.

Declaration

[JsonProperty("referencedTables")]
public virtual IList<TableReference> ReferencedTables { get; set; }

Property Value

Type	Description
IList<TableReference>

ReservationUsage

Output only. Job resource usage breakdown by reservation. This field reported misleading information and will no longer be populated.

Declaration

[JsonProperty("reservationUsage")]
public virtual IList<JobStatistics2.ReservationUsageData> ReservationUsage { get; set; }

Property Value

Type	Description
IList<JobStatistics2.ReservationUsageData>

Schema

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

Declaration

[JsonProperty("schema")]
public virtual TableSchema Schema { get; set; }

Property Value

Type	Description
TableSchema

SearchStatistics

Output only. Search query specific statistics.

Declaration

[JsonProperty("searchStatistics")]
public virtual SearchStatistics SearchStatistics { get; set; }

Property Value

Type	Description
SearchStatistics

SparkStatistics

Output only. Statistics of a Spark procedure job.

Declaration

[JsonProperty("sparkStatistics")]
public virtual SparkStatistics SparkStatistics { get; set; }

Property Value

Type	Description
SparkStatistics

StatementType

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.

Declaration

[JsonProperty("statementType")]
public virtual string StatementType { get; set; }

Property Value

Type	Description
string

Timeline

Output only. Describes a timeline of job execution.

Declaration

[JsonProperty("timeline")]
public virtual IList<QueryTimelineSample> Timeline { get; set; }

Property Value

Type	Description
IList<QueryTimelineSample>

TotalBytesBilled

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.

Declaration

[JsonProperty("totalBytesBilled")]
public virtual long? TotalBytesBilled { get; set; }

Property Value

Type	Description
long?

TotalBytesProcessed

Output only. Total bytes processed for the job.

Declaration

[JsonProperty("totalBytesProcessed")]
public virtual long? TotalBytesProcessed { get; set; }

Property Value

Type	Description
long?

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.

Declaration

[JsonProperty("totalBytesProcessedAccuracy")]
public virtual string TotalBytesProcessedAccuracy { get; set; }

Property Value

Type	Description
string

TotalPartitionsProcessed

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

Declaration

[JsonProperty("totalPartitionsProcessed")]
public virtual long? TotalPartitionsProcessed { get; set; }

Property Value

Type	Description
long?

TotalServicesSkuSlotMs

Output only. Total slot milliseconds for the job that ran on external services and billed on the services SKU. This field is only populated for jobs that have external service costs, and is the total of the usage for costs whose billing method is "SERVICES_SKU".

Declaration

[JsonProperty("totalServicesSkuSlotMs")]
public virtual long? TotalServicesSkuSlotMs { get; set; }

Property Value

Type	Description
long?

TotalSlotMs

Output only. Slot-milliseconds for the job.

Declaration

[JsonProperty("totalSlotMs")]
public virtual long? TotalSlotMs { get; set; }

Property Value

Type	Description
long?

TransferredBytes

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

Declaration

[JsonProperty("transferredBytes")]
public virtual long? TransferredBytes { get; set; }

Property Value

Type	Description
long?

UndeclaredQueryParameters

Output only. GoogleSQL only: list of undeclared query parameters detected during a dry run validation.

Declaration

[JsonProperty("undeclaredQueryParameters")]
public virtual IList<QueryParameter> UndeclaredQueryParameters { get; set; }

Property Value

Type	Description
IList<QueryParameter>

VectorSearchStatistics

Output only. Vector Search query specific statistics.

Declaration

[JsonProperty("vectorSearchStatistics")]
public virtual VectorSearchStatistics VectorSearchStatistics { get; set; }

Property Value

Type	Description
VectorSearchStatistics

Implements

IDirectResponseSchema