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 |