Class QueryResponse

Inheritance
object
QueryResponse
Implements
Inherited Members
Namespace: Google.Apis.Bigquery.v2.Data
Assembly: Google.Apis.Bigquery.v2.dll
Syntax
public class QueryResponse : IDirectResponseSchema

Properties

CacheHit

Whether the query result was fetched from the query cache.

Declaration
[JsonProperty("cacheHit")]
public virtual bool? CacheHit { get; set; }
Property Value
Type Description
bool?

CreationTime

Output only. Creation time of this query, in milliseconds since the epoch. This field will be present on all queries.

Declaration
[JsonProperty("creationTime")]
public virtual long? CreationTime { get; set; }
Property Value
Type Description
long?

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

EndTime

Output only. End time of this query, in milliseconds since the epoch. This field will be present whenever a query job is in the DONE state.

Declaration
[JsonProperty("endTime")]
public virtual long? EndTime { get; set; }
Property Value
Type Description
long?

Errors

Output only. The first errors or warnings encountered during the running of the job. The final message includes the number of errors that caused the process to stop. Errors here do not necessarily mean that the job has completed or was unsuccessful. For more information about error messages, see Error messages.

Declaration
[JsonProperty("errors")]
public virtual IList<ErrorProto> Errors { get; set; }
Property Value
Type Description
IList<ErrorProto>

JobComplete

Whether the query has completed or not. If rows or totalRows are present, this will always be true. If this is false, totalRows will not be available.

Declaration
[JsonProperty("jobComplete")]
public virtual bool? JobComplete { get; set; }
Property Value
Type Description
bool?

JobCreationReason

Optional. The reason why a Job was created. Only relevant when a job_reference is present in the response. If job_reference is not present it will always be unset. Preview

Declaration
[JsonProperty("jobCreationReason")]
public virtual JobCreationReason JobCreationReason { get; set; }
Property Value
Type Description
JobCreationReason

JobReference

Reference to the Job that was created to run the query. This field will be present even if the original request timed out, in which case GetQueryResults can be used to read the results once the query has completed. Since this API only returns the first page of results, subsequent pages can be fetched via the same mechanism (GetQueryResults). If job_creation_mode was set to JOB_CREATION_OPTIONAL and the query completes without creating a job, this field will be empty.

Declaration
[JsonProperty("jobReference")]
public virtual JobReference JobReference { get; set; }
Property Value
Type Description
JobReference

Kind

The resource type.

Declaration
[JsonProperty("kind")]
public virtual string Kind { get; set; }
Property Value
Type Description
string

Location

Output only. The geographic location of the query. For more information about BigQuery locations, see: https://cloud.google.com/bigquery/docs/locations

Declaration
[JsonProperty("location")]
public virtual string Location { get; set; }
Property Value
Type Description
string

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?

PageToken

A token used for paging results. A non-empty token indicates that additional results are available. To see additional results, query the jobs.getQueryResults method. For more information, see Paging through table data.

Declaration
[JsonProperty("pageToken")]
public virtual string PageToken { get; set; }
Property Value
Type Description
string

QueryId

Auto-generated ID for the query. Preview

Declaration
[JsonProperty("queryId")]
public virtual string QueryId { get; set; }
Property Value
Type Description
string

Rows

An object with as many results as can be contained within the maximum permitted reply size. To get any additional rows, you can call GetQueryResults and specify the jobReference returned above.

Declaration
[JsonProperty("rows")]
public virtual IList<TableRow> Rows { get; set; }
Property Value
Type Description
IList<TableRow>

Schema

The schema of the results. Present only when the query completes successfully.

Declaration
[JsonProperty("schema")]
public virtual TableSchema Schema { get; set; }
Property Value
Type Description
TableSchema

SessionInfo

Output only. Information of the session if this job is part of one.

Declaration
[JsonProperty("sessionInfo")]
public virtual SessionInfo SessionInfo { get; set; }
Property Value
Type Description
SessionInfo

StartTime

Output only. Start time of this query, in milliseconds since the epoch. This field will be present when the query job transitions from the PENDING state to either RUNNING or DONE.

Declaration
[JsonProperty("startTime")]
public virtual long? StartTime { get; set; }
Property Value
Type Description
long?

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

The total number of bytes processed for this query. If this query was a dry run, this is the number of bytes that would be processed if the query were run.

Declaration
[JsonProperty("totalBytesProcessed")]
public virtual long? TotalBytesProcessed { get; set; }
Property Value
Type Description
long?

TotalRows

The total number of rows in the complete query result set, which can be more than the number of rows in this single page of results.

Declaration
[JsonProperty("totalRows")]
public virtual ulong? TotalRows { get; set; }
Property Value
Type Description
ulong?

TotalSlotMs

Output only. Number of slot ms the user is actually billed for.

Declaration
[JsonProperty("totalSlotMs")]
public virtual long? TotalSlotMs { get; set; }
Property Value
Type Description
long?

Implements