db_list_tables.PrestoConnection: dbplyr database methods

Description

dbplyr database methods

Usage

# S3 method for PrestoConnection
db_list_tables(con)
# S3 method for PrestoConnection
db_has_table(con, table)
# S3 method for PrestoConnection
db_write_table(
  con,
  table,
  types,
  values,
  temporary = FALSE,
  overwrite = FALSE,
  ...,
  with = NULL
)
# S3 method for 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 PrestoConnection
db_compute(
  con,
  table,
  sql,
  temporary = TRUE,
  unique_indexes = list(),
  indexes = list(),
  analyze = TRUE,
  with = NULL,
  ...
)
# S3 method for PrestoConnection
db_save_query(
  con,
  sql,
  name,
  temporary = TRUE,
  overwrite = FALSE,
  ...,
  with = NULL
)
# S3 method for 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").