Expose all (or selected) local or remote osquery tables as global environment dbplyr tibbles or as a named list.

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)

Arguments

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

Details

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()).