Compute quantiles of specified columns (without interpolation, needs a database with window functions).

quantile_cols(
  db,
  incoming_table_name,
  ...,
  probs = seq(0, 1, 0.25),
  probs_name = "quantile_probability",
  cols = rq_colnames(db, incoming_table_name),
  qualifiers = NULL
)

Arguments

db

database connection

incoming_table_name

name of table to compute quantiles of

...

force later arguments to bind by name

probs

numeric, probabilities to compute quantiles of

probs_name

character name for probability column

cols

character, columns to compute quantiles of

qualifiers

optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Value

data.frame of quantiles

See also