bqQuery: Functions that execute query against BigQuery database

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

Functions that execute query against BigQuery database

Description

Execute templated query given as string or file. Placeholders in template are replaced with values provided in ellipsis parameter with sprintf

'bqExecuteDml()' - Executes DML query without loading results

'bqDownloadQuery()' Only works with Standard SQL

Usage

bqExecuteFile(file, ...)

bqExecuteQuery(query, ...)

bqExecuteSql(sql, ..., use.legacy.sql = bqUseLegacySql())

bqExecuteDml(query, ..., priority = "INTERACTIVE")

bqDownloadQuery(query, ...)

bqDownloadQueryFile(file, ...)

Arguments

file	file with sql statement
...	any parameters that will be used to replace placeholders in the query template
query	template of the sql statement
sql	string with sql statement or query template
use.legacy.sql	switches SQL dialect. Defaults to value set in 'BIGQUERY_LEGACY_SQL' env.
priority	sets priority of job execution to INTERACTIVE or BATCH

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