Cache DBH tables

dbh_cache(
  table_id,
  filters = NULL,
  group_by = NULL,
  sort_by = NULL,
  exclude = NULL,
  variables = NULL,
  api_version = 1,
  cache = TRUE,
  update_cache = FALSE,
  cache_dir = NULL,
  compress_file = TRUE
)

Arguments

table_id

The code name for the dataset

filters

A named list, where the names are the names of the variables in the dataset to be filtered, and the values contain the matching conditions.

group_by

A list of variables to include in the aggregation for aggregating tables.

sort_by

A list of variables that define the sorting order.

exclude

A named list, where the names must also occur in filters, and the values specify values to be excluded from the filter.

variables

A list of variables to include in dataset

api_version

DBH-API version

cache

a logical value whether to cache

update_cache

a logical value whether to update cache , default is without updating

cache_dir

a path to cache directory. Default value create a cache directory

compress_file

logical value whether to compress, default is to compress

Value

a tibble