Skip to main content

jobs_query_results

Overview

Namejobs_query_results
TypeResource
Idgoogle.bigquery.jobs_query_results

Fields

NameDatatypeDescription
cacheHitbooleanWhether the query result was fetched from the query cache.
schemaobject
numDmlAffectedRowsstring[Output-only] The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.
rowsarrayAn 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. Present only when the query completes successfully.
errorsarray[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.
kindstringThe resource type of the response.
jobCompletebooleanWhether 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.
totalBytesProcessedstringThe total number of bytes processed for this query.
totalRowsstringThe 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. Present only when the query completes successfully.
etagstringA hash of this response.
pageTokenstringA token used for paging results.
jobReferenceobject

Methods

NameAccessible byRequired Params
get_query_resultsSELECTjobId, projectId