This function can handle REST API connections or JDBC connections. There is a benefit to
calling this function for JDBC connections vs a straight call to dbGetQuery()
in
that the function result is a tbl_df
vs a plain data.frame
so you get better
default printing (which can be helpful if you accidentally execute a query and the result
set is huge).
drill_query(drill_con, query, uplift = TRUE, .progress = interactive())
drill_con | drill server connection object setup by |
---|---|
query | query to run |
uplift | automatically run |
.progress | if |
Other Drill direct REST API Interface:
drill_active()
,
drill_cancel()
,
drill_connection()
,
drill_functions()
,
drill_metrics()
,
drill_options()
,
drill_opts()
,
drill_profiles()
,
drill_profile()
,
drill_settings_reset()
,
drill_set()
,
drill_stats()
,
drill_status()
,
drill_storage()
,
drill_system_reset()
,
drill_threads()
,
drill_version()
try({ drill_connection() %>% drill_query("SELECT * FROM cp.`employee.json` limit 5") }, silent=TRUE)