Description Usage Arguments Methods (by class) See Also Examples
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.
1 2 3 4 5 6 7 8 9 10 | query_civis(x, ...)
## S3 method for class 'sql'
query_civis(x, database = NULL, verbose = FALSE, ...)
## S3 method for class 'numeric'
query_civis(x, verbose = FALSE, ...)
## S3 method for class 'character'
query_civis(x, database = NULL, verbose = FALSE, ...)
|
x |
|
... |
arguments passed to |
database |
string, Name of database where query is run. |
verbose |
bool, Print detailed updates of job status. |
sql
: Run a SQL query.
numeric
: Run a SQL query from a previous SQL query id.
character
: Run a SQL query.
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()
1 2 3 4 | ## Not run:
query_civis("GRANT ALL ON schema.my_table TO GROUP admin", "database", credential=0000)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.