dbCreateTableAs function

Create a table in database using a statement

dbCreateTableAs(conn, name, sql, overwrite = FALSE, with = NULL, ...)

Arguments

• conn: a PrestoConnection object, as returned by DBI::dbConnect().

• name: The table name, passed on to DBI::dbQuoteIdentifier(). Options are:

  • a character string with the unquoted DBMS table name, e.g. "table_name",
  • a call to DBI::Id() with components to the fully qualified table name, e.g. Id(schema = "my_schema", table = "table_name")
  • a call to DBI::SQL() with the quoted and fully qualified table name given verbatim, e.g. SQL('"my_schema"."table_name"')

• sql: a character string containing SQL statement.

• overwrite: A boolean indicating if an existing table should be overwritten. Default to FALSE.

• with: An optional WITH clause for the CREATE TABLE statement.

• ...: Other arguments used by individual methods.