Creates duckdb versions of Contoso datasets

Description

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"

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.

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.

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’

Examples

library("contoso")

# Create a DuckDB version of Contoso datasets stored in memory

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