Class JobStatistics2
Inheritance
Implements
Inherited Members
Namespace: Google.Apis.Bigquery.v2.Data
Assembly: Google.Apis.Bigquery.v2.dll
Syntax
public class JobStatistics2 : IDirectResponseSchema
Properties
BiEngineStatistics
BI Engine specific Statistics. [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.
Declaration
[JsonProperty("billingTier")]
public virtual int? BillingTier { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |
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 |
---|---|
System.Nullable<System.Boolean> |
DdlAffectedRowAccessPolicyCount
[Output-only] [Preview] 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 |
---|---|
System.Nullable<System.Int64> |
DdlDestinationTable
[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.
Declaration
[JsonProperty("ddlDestinationTable")]
public virtual TableReference DdlDestinationTable { get; set; }
Property Value
Type | Description |
---|---|
TableReference |
DdlOperationPerformed
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.
Declaration
[JsonProperty("ddlOperationPerformed")]
public virtual string DdlOperationPerformed { get; set; }
Property Value
Type | Description |
---|---|
System.String |
DdlTargetDataset
[Output-only] The DDL target dataset. Present only for CREATE/ALTER/DROP SCHEMA queries.
Declaration
[JsonProperty("ddlTargetDataset")]
public virtual DatasetReference DdlTargetDataset { get; set; }
Property Value
Type | Description |
---|---|
DatasetReference |
DdlTargetRoutine
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] [Preview] 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 Present only for DML statements INSERT, UPDATE, DELETE or TRUNCATE.
Declaration
[JsonProperty("dmlStats")]
public virtual DmlStatistics DmlStats { get; set; }
Property Value
Type | Description |
---|---|
DmlStatistics |
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 |
---|---|
System.Nullable<System.Int64> |
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
System.String |
ModelTraining
[Output-only, Beta] Information about create model query job progress.
Declaration
[JsonProperty("modelTraining")]
public virtual BigQueryModelTraining ModelTraining { get; set; }
Property Value
Type | Description |
---|---|
BigQueryModelTraining |
ModelTrainingCurrentIteration
[Output-only, Beta] Deprecated; do not use.
Declaration
[JsonProperty("modelTrainingCurrentIteration")]
public virtual int? ModelTrainingCurrentIteration { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |
ModelTrainingExpectedTotalIteration
[Output-only, Beta] Deprecated; do not use.
Declaration
[JsonProperty("modelTrainingExpectedTotalIteration")]
public virtual long? ModelTrainingExpectedTotalIteration { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int64> |
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 |
---|---|
System.Nullable<System.Int64> |
QueryPlan
[Output-only] Describes execution plan for the query.
Declaration
[JsonProperty("queryPlan")]
public virtual IList<ExplainQueryStage> QueryPlan { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.IList<ExplainQueryStage> |
ReferencedRoutines
[Output-only] Referenced routines (persistent user-defined functions and stored procedures) for the job.
Declaration
[JsonProperty("referencedRoutines")]
public virtual IList<RoutineReference> ReferencedRoutines { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.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 |
---|---|
System.Collections.Generic.IList<TableReference> |
ReservationUsage
[Output-only] Job resource usage breakdown by reservation.
Declaration
[JsonProperty("reservationUsage")]
public virtual IList<JobStatistics2.ReservationUsageData> ReservationUsage { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.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 |
StatementType
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.
Declaration
[JsonProperty("statementType")]
public virtual string StatementType { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Timeline
[Output-only] [Beta] Describes a timeline of job execution.
Declaration
[JsonProperty("timeline")]
public virtual IList<QueryTimelineSample> Timeline { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.IList<QueryTimelineSample> |
TotalBytesBilled
[Output-only] Total bytes billed for the job.
Declaration
[JsonProperty("totalBytesBilled")]
public virtual long? TotalBytesBilled { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int64> |
TotalBytesProcessed
[Output-only] Total bytes processed for the job.
Declaration
[JsonProperty("totalBytesProcessed")]
public virtual long? TotalBytesProcessed { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int64> |
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 |
---|---|
System.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 |
---|---|
System.Nullable<System.Int64> |
TotalSlotMs
[Output-only] Slot-milliseconds for the job.
Declaration
[JsonProperty("totalSlotMs")]
public virtual long? TotalSlotMs { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int64> |
UndeclaredQueryParameters
Standard SQL 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 |
---|---|
System.Collections.Generic.IList<QueryParameter> |