Submit a query and return results

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

Arguments

drill_con	drill server connection object setup by drill_connection() or drill_jdbc())
query	query to run
uplift	automatically run drill_uplift() on the result? (default: TRUE, ignored if drill_con is a JDBCConnection created by drill_jdbc())
.progress	if TRUE (default if in an interactive session) then ask httr::POST to display a progress bar

References

Drill documentation

Examples

not_run({
  drill_connection() %>%
    drill_query("SELECT * FROM cp.`employee.json` limit 5")
})