Store the table in a relational database

Once all the configuration elements have been defined and the dimension table has been generated, using this function we can obtain it in table format in a Relational DBMS.

Usage

get_table_rdb(td, con, overwrite)

# S3 method for when
get_table_rdb(td, con, overwrite = FALSE)

Arguments

td

A when object.

con

A DBI::DBIConnection object.

overwrite

A boolean, allow overwriting tables in the database.

Value

Invisible NULL.

See also

Other getting results: get_table_csv(), get_table_xlsx(), get_table()

Examples

my_db <- DBI::dbConnect(RSQLite::SQLite())

when() |>
  generate_table() |>
  get_table_rdb(my_db)

DBI::dbDisconnect(my_db)