Skip to contents

Collect a lazy RCDF table into a data frame

Source: R/helpers.R
collect.Rd

Materialises a lazy rcdf_tbl_db DuckDB-backed table into a regular R data frame, optionally applying the variable labels and value labels stored in the table's metadata dictionary.

Usage

collect(data, ...)

# S3 method for class 'rcdf_tbl_db'
collect(data, ...)

Arguments

data

A lazy rcdf_tbl_db object (returned by read_rcdf with lazy = TRUE), or any object supported by dplyr::collect().

...

Additional arguments passed to dplyr::collect().

Value

A tibble with all rows materialised. If the table carries a metadata dictionary, variable labels and value labels are applied via add_metadata before returning.

Examples

dir <- system.file("extdata", package = "rcdf")
rcdf_path  <- file.path(dir, "mtcars.rcdf")
prv_key    <- file.path(dir, "sample-private-key-pw.pem")

if (FALSE) { # \dontrun{
result <- read_rcdf(path = rcdf_path, decryption_key = prv_key,
                    password = "1234", lazy = TRUE)
df <- collect(result$mtcars)
class(df)  # "tbl_df"
} # }