Skip to contents

Filter fact rows based on dimension conditions in a star schema. Dimensions remain unchanged.

Usage

filter_fact_rows(st, name = NULL, ...)

# S3 method for star_schema
filter_fact_rows(st, name = NULL, ...)

Arguments

st

A star_schema object.

name

A string, name of the dimension.

...

Conditions, defined in exactly the same way as in dplyr::filter.

Value

A star_schema object.

Details

Filtered rows can be deleted using the incremental_refresh_star_schema function.

Examples


st <- st_mrs_age |>
  filter_fact_rows(name = "when", week <= "03") |>
  filter_fact_rows(name = "where", city == "Bridgeport")

st2 <- st_mrs_age |>
  incremental_refresh_star_schema(st, existing = "delete")