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>

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. Queries that reference more than 50 tables will not have a complete list.

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?

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