Creates duckdb versions of Contoso datasets

Usage

create_contoso_duckdb(db_dir = c("in_memory"), size = "100K")

Arguments

db_dir: "temp" or "in_memory"
size: "100k","1M", "10M", or "100M"

Value

A list of lazy tbl objects that are references to the Contoso datasets stored in the DuckDB database. The list contains the following tables:

sales
product
customer
store
fx
store
orderrows
date

Details

The create_contonso_duckd() function registers the following Contoso datasets as DuckDB tables:

sales: Contains sales transaction data.
product: Contains details about products, including attributes like product name, manufacturer, and category.
customer: Contains customer demographic and geographic information.
store: Contains information about store locations and attributes.
fx: Contains foreign exchange rate data for currency conversion.
date: Contains various date-related information, including day, week, month, and year.
con: the duckdb connection to your database

You can choose to store the database in memory or in a temporary directory. If you choose "temp", the database will be created in a temporary file on disk. If you choose "in_memory", the database will be created entirely in memory and will be discarded after the R session ends.

Examples

# Create a DuckDB version of Contoso datasets stored in memory

if (FALSE) { # \dontrun{
 create_contoso_duckdb(db_dir = "in_memory",size="100K")
} # }