Write a Table

Unlike the dropTable and renameTable functions, this function is a wrapper around the DatabaseConnector::dbWriteTable() function rather than one where a SQL statement is rendered using the SqlRender package. This function that converts all inputs to a dataframe, especially in cases where the input is a tibble, in which case an error would be thrown when writing.

writeTable(
  conn,
  conn_fun,
  schema,
  tableName,
  data,
  drop_existing = FALSE,
  verbose = TRUE,
  render_sql = TRUE,
  ...
)

Arguments

conn	Connection object
schema	The target schema for the operation.
tableName	The target table in the schema for an operation or for writing functions, the name of the table that will be created.
data	A dataframe or tibble.
verbose	If TRUE, details on the activity are returned in the console, such as when the querying starting and was completed.
render_sql	If TRUE, the SQL statement for the operation is returned in the console.
...	Additional arguments passed to DatabaseConnector::dbWriteTable()