dplyr verbs can be chained to query a database without writing SQL queries. dplyr uses lazy evaluation, meaning that database queries are prepared and only executed when asked by a specific verb such as collect(). I was wondering if it is possible to display the SQL query generated by dplyr?
Indeed dplyr::explain() displays the SQL query generated by dplyr. I have copied a reproducible example below based on the dplyr database vignette.
Showing posts with label dplyr. Show all posts
Showing posts with label dplyr. Show all posts
Wednesday, April 29, 2015
Subscribe to:
Posts (Atom)
