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: See Quota Policy for file sizes.
  • 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 that this is.

Child PropertyDescription
loadLoad data from an uncompressed or gzipped CSV or JSON file into a table. Specify the file location by URI. See Importing Data to a Table in the developer's guide to learn more.
queryA query job; see Running Queries in the developer's guide to learn how to run a query job.
extractExport a BigQuery table to Google Cloud Storage as a CSV or JSON file. See Exporting Tables in the developer's guide to learn more.
copyCopy an existing table to another new or existing table. See Copying an Existing Table in the developer's guide to learn more.

Required ACLs: To call this method, you must have one of the following sets of rights:

  • Project READ/WRITE/OWNER on the project to which the job is assigned AND appropriate dataset rights to read from or write to the appropriate tables.

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:
  • media - Simple upload. Upload the media only, without any metadata.
  • 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.

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.