Connect to consumption expenditure data

Open an in-memory DuckDB connection, register all Parquet files in data_dir as views, and attach the labels database. All queries are lazy-evaluated via dplyr; call dplyr::collect() to materialise.

Usage

ics_connect(data_dir = NULL, read_only = TRUE)

Arguments

data_dir

Path to directory containing Parquet files and labels.duckdb. If NULL, uses getOption("ics.data_dir").

read_only

Logical; if TRUE (default), open labels database in read-only mode.

Value

A DBI connection object (DuckDB).

Examples

if (FALSE) { # \dontrun{
con <- ics_connect("~/data/consumption")
ics_tables(con)
ics_disconnect(con)
} # }