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.
1 | 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 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.