insert_query_job: Create a new query job.

Description Usage Arguments Value See Also

View source: R/job-query.R

Description

This is a low-level function that creates a query job. To wait until it is finished and then retrieve the results, see query_exec()

Usage

1
2
3
insert_query_job(query, project, destination_table = NULL,
  default_dataset = NULL, create_disposition = "CREATE_IF_NEEDED",
  write_disposition = "WRITE_EMPTY", use_legacy_sql = TRUE, ...)

Arguments

query

SQL query string

project

The project name, a string

destination_table

(optional) destination table for large queries, either as a string in the format used by BigQuery, or as a list with project_id, dataset_id, and table_id entries

default_dataset

(optional) default dataset for any table references in query, either as a string in the format used by BigQuery or as a list with project_id and dataset_id entries

create_disposition

behavior for table creation. defaults to "CREATE_IF_NEEDED", the only other supported value is "CREATE_NEVER"; see the API documentation for more information

write_disposition

behavior for writing data. defaults to "WRITE_EMPTY", other possible values are "WRITE_TRUNCATE" and "WRITE_APPEND"; see the API documentation for more information

use_legacy_sql

(optional) set to FALSE to enable BigQuery's standard SQL.

...

Additional arguments merged into the body of the request. snake_case will automatically be converted into camelCase so you can use consistent argument names.

Value

a job resource list, as documented at https://developers.google.com/bigquery/docs/reference/v2/jobs

See Also

API documentation for insert method: https://developers.google.com/bigquery/docs/reference/v2/jobs/insert

Other jobs: get_job, insert_extract_job, insert_upload_job, wait_for


bigrquery documentation built on June 27, 2017, 1:02 a.m.