I'm getting the error,
ggplot2 does not know how to deal with data of class tbl_sqlite/tbl_sql/tbl_lazy/tbl. Does this mean I need to reduce the size of my data or convert it to another format before I can plot it?
dplyr holds off on actually collecting the data into r until it is explicitly told to. When using
dplyr to query a database, be sure to use
collect at the end of the chain to pull the query result into r as a data frame.