Skip to main content

Get BigQuery Job Results

Retrieves the results of a query job.

External Documentation

To learn more, visit the GCP documentation.

Basic Parameters​

ParameterDescription
Job ID[Required] Job ID of the query job.
LocationThe geographic location where the job should run. Required except for US and EU. See details at https://cloud.google.com/bigquery/docs/locations#specifyingyourlocation.
Project ID[Required] Project ID of the query job.
Return All PagesAutomatically fetch all resources, page by page.

Advanced Parameters​

ParameterDescription
FieldsSelector specifying which fields to include in a partial response.
Max ResultsMaximum number of results to read.
Start IndexZero-based index of the starting row.
Timeout MsHow long to wait for the query to complete, in milliseconds, before returning. Default is 10 seconds. If the timeout passes before the job completes, the 'jobComplete' field in the response will be false.

Example Output​

{
    "cacheHit": false,
    "errors": [
        {
            "debugInfo": "Debugging information. This property is internal to Google and should not be used.",
            "location": "Specifies where the error occurred, if present.",
            "message": "A human-readable description of the error.",
            "reason": "A short error code that summarizes the error."
        }
    ],
    "etag": "A hash of this response.",
    "jobComplete": false,
    "jobReference": {
        "jobId": "[Required] The ID of the job. The ID must contain only letters (a-z, A-Z), numbers (0-9), underscores (_), or dashes (-). The maximum length is 1,024 characters.",
        "location": "The geographic location of the job. See details at https://cloud.google.com/bigquery/docs/locations#specifying_your_location.",
        "projectId": "[Required] The ID of the project containing this job."
    },
    "kind": "bigquery#getQueryResultsResponse",
    "numDmlAffectedRows": "[Output-only] The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.",
    "pageToken": "A token used for paging results.",
    "rows": [
        {
            "f": [
                {
                    "v": ""
                }
            ]
        }
    ],
    "schema": {
        "fields": [
            {
                "categories": {
                    "names": [
                        "string"
                    ]
                },
                "collationSpec": "Optional. Collation specification of the field. It only can be set on string type field.",
                "description": "[Optional] The field description. The maximum length is 1,024 characters.",
                "fields": [
                    null
                ],
                "maxLength": "[Optional] Maximum length of values of this field for STRINGS or BYTES. If max_length is not specified, no maximum length constraint is imposed on this field. If type = \"STRING\", then max_length represents the maximum UTF-8 length of strings in this field. If type = \"BYTES\", then max_length represents the maximum number of bytes in this field. It is invalid to set this field if type ≠ \"STRING\" and ≠ \"BYTES\".",
                "mode": "[Optional] The field mode. Possible values include NULLABLE, REQUIRED and REPEATED. The default value is NULLABLE.",
                "name": "[Required] The field name. The name must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_), and must start with a letter or underscore. The maximum length is 300 characters.",
                "policyTags": {
                    "names": [
                        "string"
                    ]
                },
                "precision": "[Optional] Precision (maximum number of total digits in base 10) and scale (maximum number of digits in the fractional part in base 10) constraints for values of this field for NUMERIC or BIGNUMERIC. It is invalid to set precision or scale if type ≠ \"NUMERIC\" and ≠ \"BIGNUMERIC\". If precision and scale are not specified, no value range constraint is imposed on this field insofar as values are permitted by the type. Values of this NUMERIC or BIGNUMERIC field must be in this range when: - Precision (P) and scale (S) are specified: [-10P-S + 10-S, 10P-S - 10-S] - Precision (P) is specified but not scale (and thus scale is interpreted to be equal to zero): [-10P + 1, 10P - 1]. Acceptable values for precision and scale if both are specified: - If type = \"NUMERIC\": 1 ≤ precision - scale ≤ 29 and 0 ≤ scale ≤ 9. - If type = \"BIGNUMERIC\": 1 ≤ precision - scale ≤ 38 and 0 ≤ scale ≤ 38. Acceptable values for precision if only precision is specified but not scale (and thus scale is interpreted to be equal to zero): - If type = \"NUMERIC\": 1 ≤ precision ≤ 29. - If type = \"BIGNUMERIC\": 1 ≤ precision ≤ 38. If scale is specified but not precision, then it is invalid.",
                "scale": "[Optional] See documentation for precision.",
                "type": "[Required] The field data type. Possible values include STRING, BYTES, INTEGER, INT64 (same as INTEGER), FLOAT, FLOAT64 (same as FLOAT), NUMERIC, BIGNUMERIC, BOOLEAN, BOOL (same as BOOLEAN), TIMESTAMP, DATE, TIME, DATETIME, INTERVAL, RECORD (where RECORD indicates that the field contains a nested schema) or STRUCT (same as RECORD)."
            }
        ]
    },
    "totalBytesProcessed": "The total number of bytes processed for this query.",
    "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. Present only when the query completes successfully."
}

Workflow Library Example​

Get Bigquery Job Results with Gcp and Send Results Via Email

Workflow LibraryPreview this Workflow on desktop