bqQuery | R Documentation |
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
bqExecuteFile(file, ...) bqExecuteQuery(query, ...) bqExecuteSql(sql, ..., use.legacy.sql = bqUseLegacySql()) bqExecuteDml(query, ..., priority = "INTERACTIVE") bqDownloadQuery(query, ...) bqDownloadQueryFile(file, ...)
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 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.