Convert a climasus_df to a DuckDB lazy tbl with embedded metadata

Copies the data to a DuckDB connection and stores sus_meta in a helper table named .__sus_meta__. This allows sus_data_aggregate() to recover the metadata automatically.

Usage

sus_as_duckdb(df, con, name = "sus_data", overwrite = TRUE)

Arguments

df

A climasus_df tibble.

con

A DuckDB DBIConnection (from duckdb::dbConnect(duckdb::duckdb())).

name

Character; name for the DuckDB table. Defaults to "sus_data".

overwrite

Logical. Overwrite existing table? Default TRUE.

Value

A tbl_dbi referencing the DuckDB table.

Examples

if (FALSE) { # \dontrun{
con      <- duckdb::dbConnect(duckdb::duckdb())
duck_tbl <- sus_data_standardize(df) |> sus_as_duckdb(con)
result   <- sus_data_aggregate(duck_tbl, time_unit = "month")
} # }