This function will cache the resultset from a SQL query to a subdirectory of the cache root directory, the path of which will be db/schema.

cacheQuery(.data, sqlQuery, db)

Arguments

.data

dataframe to cache

sqlQuery

sql statement of length 1 that will be the sole key for cache retrieval.

db

name of database

schema

name of schema