bqCreateTable: Creates table using given sql

In madedotcom/retl: Support for common ETL operations and connections

Creates table using given sql

Description

Creates table using given sql

Usage

bqCreateTable(
  sql,
  table,
  ...,
  dataset = bqDefaultDataset(),
  write.disposition = "WRITE_APPEND",
  priority = "INTERACTIVE",
  use.legacy.sql = bqUseLegacySql(),
  schema.file = NULL
)

Arguments

sql	string with sql statement or query template
table	name of a table to be created
...	list of parameters for query template. With Standard sql all parameters must be named. With Legacy SQL ' sprintf()' will be applied for the query template.
dataset	name of the destination dataset
write.disposition	defines whether records will be appended
priority	sets priority of job execution to INTERACTIVE or BATCH
use.legacy.sql	sets SQL flavour
schema.file	sets path to schema file for initialisation

Value

results of the execution as returned by bigrquery::query_exec

madedotcom/retl documentation built on Sept. 19, 2022, 3:28 a.m.