Hide
Google BigQuery

Jobs: insert

Requires authorization

Starts a new asynchronous job. Try it now.

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 must call jobs.get() and examine the job status to learn when the job is complete. 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

Request

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:
    POST https://www.googleapis.com/upload/bigquery/v2/projects/projectId/jobs
  • Metadata URI, for metadata-only requests:
    POST https://www.googleapis.com/bigquery/v2/projects/projectId/jobs

Parameters

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.

Authorization

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

Scope
https://www.googleapis.com/auth/bigquery
https://www.googleapis.com/auth/cloud-platform
https://www.googleapis.com/auth/devstorage.read_only
https://www.googleapis.com/auth/devstorage.read_write
https://www.googleapis.com/auth/devstorage.full_control

Request body

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

Response

If successful, this method returns a Jobs 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.