dbplyr-sql: dbplyr SQL methods

sql_query_save.PrestoConnectionR 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.


prestodb/RPresto documentation built on Feb. 28, 2024, 11:13 a.m.