Starts a new asynchronous job. Requires the Can View project role.
This method waits—the workflow execution is paused—until the operation is
complete, fails, or times out. The default timeout value is 1800 seconds (30
minutes) and can be changed to a maximum value of 31536000 seconds (one year)
for long-running operations using the connector_params field. See the
Connectors reference.
The connector uses polling to monitor the long-running operation, which might generate additional billable steps. For more information about retries and long-running operations, refer to Understand connectors.
The polling policy for the long-running operation can be configured. To set the
connector-specific parameters (connector_params), refer to
Invoke a connector call.
Learn more about how to load data into BigQuery and how to use schema auto-detection.
Arguments
| Parameters | |
|---|---|
projectId |
Required. Project ID of the project that will be billed for the job |
body |
Required. |
Raised exceptions
| Exceptions | |
|---|---|
ConnectionError |
In case of a network problem (such as DNS failure or refused connection). |
HttpError |
If the response status is >= 400 (excluding 429 and 503). |
TimeoutError |
If a long-running operation takes longer to finish than the specified timeout limit. |
TypeError |
If an operation or function receives an argument of the wrong type. |
ValueError |
If an operation or function receives an argument of the right type but an inappropriate value. For example, a negative timeout. |
OperationError |
If the long-running operation finished unsuccessfully. |
ResponseTypeError |
If the long-running operation returned a response of the wrong type. |
Response
If successful, the response contains an instance of Job.
Subworkflow snippet
Some fields might be optional or required. To identify required fields, refer to the API documentation.
YAML
- insert: call: googleapis.bigquery.v2.jobs.insert args: projectId: ... body: configuration: copy: createDisposition: ... destinationEncryptionConfiguration: kmsKeyName: ... destinationExpirationTime: ... destinationTable: datasetId: ... projectId: ... tableId: ... operationType: ... sourceTable: ... sourceTables: ... writeDisposition: ... dryRun: ... extract: compression: ... destinationFormat: ... destinationUri: ... destinationUris: ... fieldDelimiter: ... printHeader: ... sourceModel: datasetId: ... modelId: ... projectId: ... sourceTable: ... useAvroLogicalTypes: ... jobTimeoutMs: ... labels: ... load: allowJaggedRows: ... allowQuotedNewlines: ... autodetect: ... clustering: fields: ... connectionProperties: ... createDisposition: ... createSession: ... decimalTargetTypes: ... destinationEncryptionConfiguration: ... destinationTable: ... destinationTableProperties: description: ... expirationTime: ... friendlyName: ... labels: ... encoding: ... fieldDelimiter: ... hivePartitioningOptions: mode: ... requirePartitionFilter: ... sourceUriPrefix: ... ignoreUnknownValues: ... jsonExtension: ... maxBadRecords: ... nullMarker: ... parquetOptions: enableListInference: ... enumAsString: ... preserveAsciiControlCharacters: ... projectionFields: ... quote: ... rangePartitioning: field: ... range: end: ... interval: ... start: ... referenceFileSchemaUri: ... schema: fields: ... schemaInline: ... schemaInlineFormat: ... schemaUpdateOptions: ... skipLeadingRows: ... sourceFormat: ... sourceUris: ... timePartitioning: expirationMs: ... field: ... requirePartitionFilter: ... type: ... useAvroLogicalTypes: ... writeDisposition: ... query: allowLargeResults: ... clustering: ... connectionProperties: ... createDisposition: ... createSession: ... defaultDataset: datasetId: ... projectId: ... destinationEncryptionConfiguration: ... destinationTable: ... flattenResults: ... maximumBillingTier: ... maximumBytesBilled: ... parameterMode: ... preserveNulls: ... priority: ... query: ... queryParameters: ... rangePartitioning: ... schemaUpdateOptions: ... tableDefinitions: ... timePartitioning: ... useLegacySql: ... useQueryCache: ... userDefinedFunctionResources: ... writeDisposition: ... jobReference: jobId: ... location: ... projectId: ... result: insertResult
JSON
[ { "insert": { "call": "googleapis.bigquery.v2.jobs.insert", "args": { "projectId": "...", "body": { "configuration": { "copy": { "createDisposition": "...", "destinationEncryptionConfiguration": { "kmsKeyName": "..." }, "destinationExpirationTime": "...", "destinationTable": { "datasetId": "...", "projectId": "...", "tableId": "..." }, "operationType": "...", "sourceTable": "...", "sourceTables": "...", "writeDisposition": "..." }, "dryRun": "...", "extract": { "compression": "...", "destinationFormat": "...", "destinationUri": "...", "destinationUris": "...", "fieldDelimiter": "...", "printHeader": "...", "sourceModel": { "datasetId": "...", "modelId": "...", "projectId": "..." }, "sourceTable": "...", "useAvroLogicalTypes": "..." }, "jobTimeoutMs": "...", "labels": "...", "load": { "allowJaggedRows": "...", "allowQuotedNewlines": "...", "autodetect": "...", "clustering": { "fields": "..." }, "connectionProperties": "...", "createDisposition": "...", "createSession": "...", "decimalTargetTypes": "...", "destinationEncryptionConfiguration": "...", "destinationTable": "...", "destinationTableProperties": { "description": "...", "expirationTime": "...", "friendlyName": "...", "labels": "..." }, "encoding": "...", "fieldDelimiter": "...", "hivePartitioningOptions": { "mode": "...", "requirePartitionFilter": "...", "sourceUriPrefix": "..." }, "ignoreUnknownValues": "...", "jsonExtension": "...", "maxBadRecords": "...", "nullMarker": "...", "parquetOptions": { "enableListInference": "...", "enumAsString": "..." }, "preserveAsciiControlCharacters": "...", "projectionFields": "...", "quote": "...", "rangePartitioning": { "field": "...", "range": { "end": "...", "interval": "...", "start": "..." } }, "referenceFileSchemaUri": "...", "schema": { "fields": "..." }, "schemaInline": "...", "schemaInlineFormat": "...", "schemaUpdateOptions": "...", "skipLeadingRows": "...", "sourceFormat": "...", "sourceUris": "...", "timePartitioning": { "expirationMs": "...", "field": "...", "requirePartitionFilter": "...", "type": "..." }, "useAvroLogicalTypes": "...", "writeDisposition": "..." }, "query": { "allowLargeResults": "...", "clustering": "...", "connectionProperties": "...", "createDisposition": "...", "createSession": "...", "defaultDataset": { "datasetId": "...", "projectId": "..." }, "destinationEncryptionConfiguration": "...", "destinationTable": "...", "flattenResults": "...", "maximumBillingTier": "...", "maximumBytesBilled": "...", "parameterMode": "...", "preserveNulls": "...", "priority": "...", "query": "...", "queryParameters": "...", "rangePartitioning": "...", "schemaUpdateOptions": "...", "tableDefinitions": "...", "timePartitioning": "...", "useLegacySql": "...", "useQueryCache": "...", "userDefinedFunctionResources": "...", "writeDisposition": "..." } }, "jobReference": { "jobId": "...", "location": "...", "projectId": "..." } } }, "result": "insertResult" } } ]