sql_query_save.PrestoConnection {RPresto} | R Documentation |
dbplyr SQL methods
Description
dbplyr SQL methods
Usage
## S3 method for class 'PrestoConnection'
sql_query_save(con, sql, name, temporary = TRUE, ..., with = NULL)
Arguments
con |
A database connection.
|
sql |
a character string containing SQL statement.
|
name |
The table name, passed on to dbQuoteIdentifier() . Options are:
a character string with the unquoted DBMS table name,
e.g. "table_name" ,
a call to Id() with components to the fully qualified table name,
e.g. Id(schema = "my_schema", table = "table_name")
a call to SQL() with the quoted and fully qualified table name
given verbatim, e.g. SQL('"my_schema"."table_name"')
|
temporary |
If a temporary table should be created. Default to TRUE in
the dbplyr::sql_query_save() generic. The default value generates an
error in Presto. Using temporary = FALSE to save the query in a
permanent table.
|
... |
Other arguments used by individual methods.
|
with |
An optional WITH clause for the CREATE TABLE statement.
|
[Package
RPresto version 1.4.6
Index]