Overwrite or Append a Local Tibble to a Database Table

Takes an in-memory tibble (or data frame) and writes it to a database table using a `DBI` connection. The function supports both **overwrite** and **append** modes, automatically creates the target database and schema if they do not exist, and adds audit fields (`upload_date`, `upload_time`) to the written table.

Usage

create_table_tbl(
  .data,
  .con,
  database_name,
  schema_name,
  table_name,
  write_type = "overwrite"
)

Arguments

.data

A tibble or data frame to be written to the database.

.con

A valid `DBI` connection (e.g., DuckDB or MotherDuck).

database_name

Name of the database to create/use. If missing, the current database of the connection will be used.

schema_name

Name of the schema to create/use. If missing, the current schema of the connection will be used.

table_name

Name of the table to create or append to.

write_type

Write strategy: either `"overwrite"` (drop/create) or `"append"` (insert rows). Defaults to `"overwrite"`.

Value

Invisibly returns `NULL`. Side effect: writes the tibble to the specified database table.

Details

- If the connection is a MotherDuck connection (detected by `validate_md_connection_status()`), the function ensures the database is created and switches to it before creating the schema. - Two audit columns are added to the data before writing: `upload_date` (date of run) and `upload_time` (time and timezone of run). - Uses `DBI::Id()` to explicitly target the database/schema/table. - `write_type = "overwrite"` will drop and recreate the table. - `write_type = "append"` will insert rows into an existing table.

See also

[DBI::dbWriteTable()], [DBI::Id()]