InsertJob

Inserts a Google BigQuery job, which can then be selected later to retrieve the query results.


Name	Type	Description
Query	String	The query to submit to Google BigQuery.
IsDML	String	Should be true if the query is a DML statement and false otherwise. The default value is false.
DestinationTable	String	The destination table for the query, in the format DestProjectId:DestDatasetId.DestTable
WriteDisposition	String	How to write data to the destination table, such as truncate existing results, appending existing results, or writing only when the table is empty. The allowed values are WRITE_TRUNCATE, WRITE_APPEND, WRITE_EMPTY. The default value is WRITE_TRUNCATE.
DryRun	String	Whether or not this is a dry run of the job.
MaximumBytesBilled	String	If provided, BigQuery will cancel the job if it attempts to process more than this many bytes.
Region	String	The region to start executing the job in.


Name	Type	Description
JobId	String	The JobId of the newly insert Job.
Region	String	The region where the job is executing.
Configuration_query_query	String	The query of the newly inserted Job.
Configuration_query_destinationTable_tableId	String	The destination table tableId of the newly inserted Job.
Configuration_query_destinationTable_projectId	String	The destination table projectId of the newly inserted Job.
Configuration_query_destinationTable_datasetId	String	The destination table datasetId of the newly inserted Job.
Status_State	String	Running state of the job.
Status_errorResult_reason	String	A short error code that summarizes the error.
Status_errorResult_message	String	A human-readable description of the error.

ODBC Driver for Google BigQuery