osq_expose_tables: Expose all (or selected) local or remote osquery tables as...
In hrbrmstr/osqueryr: 'osquery' 'DBI' and 'dbplyr' Interface for R

This is intended as a shortcut for building a connection and wiring up to src_dbi(). Exposing all of the tables is not recommended unless you're performing a large number of diverse queries.

osq_expose_tables(tables = ".*", prefix = NULL, host = NULL,
  keyfile = NULL, quiet = TRUE)

osq_load_tables(tables = ".*", prefix = NULL, host = NULL,
  keyfile = NULL, quiet = TRUE)

`tables`	defaults to `.*` or all tables. Use a valid regular expression to match table names.
`prefix`	if not `NULL`, each table in `tables` will be prefixed with this string.
`host, keyfile`	same as for `dbConnect()`
`quiet`	if `TRUE`, display a message with each table being exposed to the global environment.
`tables`	defaults to `.*` or all tables. Use a valid regular expression to match table names.
`prefix`	if not `NULL`, each table in `tables` will be prefixed with this string.
`host, keyfile`	same as for `dbConnect()`
`quiet`	if `TRUE`, display a message with each table being wired up

osq_load_tables() is a tad safer than osq_expose_tables() since it does not pollute the global environment and you can use a variable name for host identification vs a prefix (though prefixes are still supported in osq_load_tables()).

hrbrmstr/osqueryr documentation built on May 31, 2019, 12:10 p.m.