Run a Query on Platform

Source: R/io.R

Utility to run queries that return no output.

A default database can be set using options(civis.default_db = "my_database"). If there is only one database available, this database will automatically be used as the default.

query_civis(x, ...)

# S3 method for sql
query_civis(x, database = NULL, verbose = FALSE, ...)

# S3 method for numeric
query_civis(x, verbose = FALSE, ...)

# S3 method for character
query_civis(x, database = NULL, verbose = FALSE, ...)

Arguments

x

sql("..."), "query", or id of an existing sql script.
...

arguments passed to queries_post.
database

string, Name of database where query is run.
verbose

bool, Print detailed updates of job status.

Methods (by class)

  • sql: Run a SQL query.

  • numeric: Run a SQL query from a previous SQL query id.

  • character: Run a SQL query.

See also

read_civis for downloading results of SQL scripts from Civis Platform as a data frame.

io

Other io: download_civis(), query_civis_file(), read_civis(), write_civis_file(), write_civis()

Examples

if (FALSE) {
query_civis("GRANT ALL ON schema.my_table TO GROUP admin", "database", credential=0000)
}