CData Excel Add-In for Google BigQuery 2019 - Online Help
Questions / Feedback?

InsertJob

CData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354

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

Input

Name Type Description
Query String The query to submit to Google BigQuery.
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.

Result Set Columns

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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0