dbplyr-db: dbplyr database methods

In RPresto: DBI Connector to Presto

dbplyr database methods

Description

dbplyr database methods

Usage

## S3 method for class 'PrestoConnection'
db_list_tables(con)

## S3 method for class 'PrestoConnection'
db_has_table(con, table)

## S3 method for class 'PrestoConnection'
db_write_table(
  con,
  table,
  types,
  values,
  temporary = FALSE,
  overwrite = FALSE,
  ...,
  with = NULL
)

## S3 method for class 'PrestoConnection'
db_copy_to(
  con,
  table,
  values,
  overwrite = FALSE,
  types = NULL,
  temporary = TRUE,
  unique_indexes = NULL,
  indexes = NULL,
  analyze = TRUE,
  ...,
  in_transaction = TRUE,
  with = NULL
)

## S3 method for class 'PrestoConnection'
db_compute(
  con,
  table,
  sql,
  temporary = TRUE,
  unique_indexes = list(),
  indexes = list(),
  analyze = TRUE,
  with = NULL,
  ...
)

## S3 method for class 'PrestoConnection'
db_save_query(
  con,
  sql,
  name,
  temporary = TRUE,
  overwrite = FALSE,
  ...,
  with = NULL
)

## S3 method for class 'PrestoConnection'
db_sql_render(con, sql, ..., use_presto_cte = TRUE)

Arguments

con	A PrestoConnection as returned by dbConnect().
table	Table name
types	Column types. If not provided, column types are inferred using dbDataType.
values	A data.frame.
temporary	If a temporary table should be created. Default to TRUE in the dplyr::db_save_query() generic. The default value generates an error in Presto. Using temporary = FALSE to save the query in a permanent table.
overwrite	If an existing table should be overwritten. Default to FALSE. When TRUE, uses smart overwriting: renames the existing table, creates the new table, and drops the old table on success. If creation fails, the original table is restored.
...	Extra arguments to be passed to individual methods.
with	An optional WITH clause for the CREATE TABLE statement.
unique_indexes, indexes, analyze, in_transaction	Ignored. Included for compatibility with generics.
sql	A SQL statement.
name	The table name, passed on to DBI::dbQuoteIdentifier(). Options are: a character string with the unquoted DBMS table name, a call to DBI::Id() with components to the fully qualified table name, or a call to DBI::SQL() with the quoted and fully qualified table name given verbatim.
use_presto_cte	A logical value indicating if to use common table expressions stored in PrestoConnection when possible. Default to TRUE. See vignette("common-table-expressions").

RPresto documentation built on Dec. 2, 2025, 9:07 a.m.