Like the writeTable function, this function is a wrapper around a DatabaseConnector function rather than one where a SQL statement is rendered using the SqlRender package. This function performs the additional step of converting all inputs to the data.frame class, especially in cases where the input is a tibble.

appendTable(
  conn,
  conn_fun,
  schema,
  tableName,
  data,
  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::dbAppendTable()

See also