get_tbl: Access specific table from the datawarehouse.

In karsfri/HMSr: Theme and functions for HMS

Description

Thin wrapper around tbl from dbplyr. Allows the user to use some of the common dplyr function on an object without importing it to R.

Usage

get_tbl(tbl, con = get_connection_windows(), schema = "dwh")

Arguments

tbl	Name of the table in the datawarehouse
con	Connection to the datawarehouse
schema

Value

tbl object to use with warehouse. See https://dbplyr.tidyverse.org/

Examples

visitolur <- get_tbl(Fact_Visitolur)

visitolur %>%
  filter(dim_visitolur == 3) %>%
  collect()

karsfri/HMSr documentation built on Feb. 26, 2020, 10:36 a.m.