InsertJob
Inserts a Google BigQuery job, which can then be selected later to retrieve the query results.
Input
| Name | Type | Description |
| Query | String | The SQL query to execute in Google BigQuery. This can be a data retrieval query or a Data Manipulation Language (DML) operation. |
| IsDML | String | If the value is 'true', the query is treated as a DML statement, such as INSERT, UPDATE, or DELETE. If the value is 'false', the query is treated as a read-only operation.
The default value is false. |
| DestinationTable | String | The fully qualified destination table for storing the query results, using the format projectId:datasetId.tableId. This field is required when using write dispositions other than 'WRITE_EMPTY'. |
| WriteDisposition | String | Specifies how the results should be written to the destination table. Possible options include truncating the existing table, appending to it, or writing only if the table is empty.
The allowed values are WRITE_TRUNCATE, WRITE_APPEND, WRITE_EMPTY. The default value is WRITE_TRUNCATE. |
| DryRun | String | If the value is 'true', BigQuery performs a dry run to validate the query without executing it. If the value is 'false', the query runs normally. |
| MaximumBytesBilled | String | Sets an upper limit for the number of bytes BigQuery is allowed to process. If the query exceeds this limit, the job is cancelled before execution. |
| Region | String | The geographic region where the job should be executed. If not provided, defaults to the region specified in the connection or job configuration. |
Result Set Columns
| Name | Type | Description |
| JobId | String | The unique identifier assigned to the newly submitted BigQuery job. |
| Region | String | The region in which the job was submitted and is being executed. |
| Configuration_query_query | String | The SQL query text used in the job execution. |
| Configuration_query_destinationTable_tableId | String | The ID of the destination table where the query results were written. |
| Configuration_query_destinationTable_projectId | String | The ID of the Google Cloud project that contains the destination table. |
| Configuration_query_destinationTable_datasetId | String | The ID of the dataset that contains the destination table. |
| Status_State | String | The current status of the job, such as PENDING, RUNNING, or DONE. |
| Status_errorResult_reason | String | A brief error code explaining why the job failed, if applicable. |
| Status_errorResult_message | String | A detailed, human-readable error message returned by BigQuery, if the job encountered an error. |