# Non-ingestion SWF workflows for internal usage

## datadog_caching_monitor 
*Visualise and analyze cache-related Snowflake performance issues*

This workflows runs daily and populates the `CACHE_STATS_BY_QUERYID` table, which is basically returned by `SNOWFLAKE.INFORMATION_SCHEMA.QUERY_HISTORY_BY_WAREHOUSE()`, but enriched with `local_bytes` and `remote_bytes` columns. This allows to calculate percentage scanned from cache.
The main goal is to keep this [Datadog Screenboard](https://app.datadoghq.com/dashboard/pya-m3v-mvb) populated.

This workflow is scheduled to run every 15 minutes.