experimental.db.sketch.attribute: Multiselect for given attribute

In cezden/rpostgrexplorer: Simplification of analysis in PostgreSQL and Redshift DBs

Description

Function performs a multiple selects from tables (in metadata.inf) containing the attribute attribute.name:

• counts all records of attribute attribute.name with value attribute.value

• selects a sample of at most results.limit rows

Usage

experimental.db.sketch.attribute(db.connection, metadata.inf, attribute.name,
  attribute.value, results.limit = 10)

Arguments

db.connection	object of S3 class db.connection
metadata.inf	object of S3 class metadata.info
attribute.name	(character) the name of the attribute
attribute.value	(character) a value of the attribute
results.limit	(integer) a maximal number of returned rows; if NULL all results will be fetched

cezden/rpostgrexplorer documentation built on May 13, 2019, 3:08 p.m.