Jobs: insert

Requires authorization

Starts a new asynchronous job. Requires the Can View project role.

This method supports an /upload URI and accepts uploaded media with the following characteristics:

  • Maximum file size: For more information, see quota policy.
  • Accepted Media MIME types: */*

This method returns immediately. You include one and only one of the following child properties in your job resource. The child property that you include defines the type of job it is.

Child PropertyDescription
loadLoad data from one of several formats into a table. Specify the file location by URI. For load job configuration options, see configuration.load.
queryRun a query against BigQuery data. For query job configuration options, see configuration.query.
extractExport a BigQuery table to Google Cloud Storage. For extract job configuration options, see configuration.extract.
copyCopy an existing table to another new or existing table. For copy job configuration options, see configuration.copy.

Access control: To call this method, you must have the Can View project role, as well as additional dataset roles depending on the job type. For more information, see access control


HTTP request

This method provides media upload functionality through two separate URIs. For more details, see the document on media upload.

  • Upload URI, for media upload requests:
  • Metadata URI, for metadata-only requests:


Parameter name Value Description
Path parameters
projectId string Project ID of the project that will be billed for the job
Required query parameters
uploadType string The type of upload request to the /upload URI. Acceptable values are:
  • multipart - Multipart upload. Upload both the media and its metadata, in a single request.
  • resumable - Resumable upload. Upload the file in a resumable fashion, using a series of at least two requests where the first request includes the metadata.


This request requires authorization with at least one of the following scopes (read more about authentication and authorization).


Request body

In the request body, supply a Jobs resource as the metadata. For more information, see the document on media upload.


If successful, this method returns a Job resource in the response body.

Try it!

Note: APIs Explorer currently supports metadata requests only.

Use the APIs Explorer below to call this method on live data and see the response. Alternatively, try the standalone Explorer.

Esta página foi útil? Conte sua opinião sobre:

Enviar comentários sobre…