GetJob
Retrieves the configuration information and execution state for an existing job.
Input
| Name | Type | Description |
| JobId | String | Specifies the unique identifier of the BigQuery job to retrieve. This is typically assigned when the job is created. |
| Region | String | Identifies the geographic location where the job is executing. This value is required for non-US and non-EU regions. |
Result Set Columns
| Name | Type | Description |
| JobId | String | Returns the unique identifier of the retrieved job. Matches the job ID specified in the input. |
| Region | String | Returns the region where the job is or was executing. Useful for region-specific configurations and troubleshooting. |
| Configuration_query_query | String | Returns the full SQL query string that was executed by the job. |
| Configuration_query_destinationTable_tableId | String | Returns the table ID where the query results were stored, if applicable. |
| Configuration_query_destinationTable_projectId | String | Returns the project ID that contains the destination table for the job results. |
| Configuration_query_destinationTable_datasetId | String | Returns the dataset ID that contains the destination table for the job results. |
| Status_State | String | Indicates the current lifecycle state of the job. Possible values include 'PENDING', 'RUNNING', and 'DONE'. |
| Status_errorResult_reason | String | Provides a concise error code representing the reason for job failure, if an error occurred. |
| Status_errorResult_message | String | Provides a detailed message describing the error encountered during job execution, if applicable. |