dbCreateTableAs: Create a table in database using a statement

In prestodb/RPresto: DBI Connector to Presto

Create a table in database using a statement

Description

Create a table in database using a statement

Usage

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.

prestodb/RPresto documentation built on Feb. 16, 2025, 7:29 p.m.