Class 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? |