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