dbplyr-db function

dbplyr database methods

## 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_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 used. Not supported. Only FALSE is accepted.
• overwrite: If an existing table should be overwritten.
• ...: 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.
• 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").