Question's on cloud cache

Hi Dremio Team,
can we get some isight’s on cloud caching?

after enabling cloud cache,
how do i correlate cached data to a physical data/queried data?
how do i know if query is using the cache(from profile)?
how do i manually cleanup cache db and files directory?

Thanks

@smora

how do i correlate cached data to a physical data/queried data? - Do you want to compare? Then query the source data using an external tool and compare
how do i know if query is using the cache(from profile)? - Yes, from profile
how do i manually cleanup cache db and files directory? We control this by setting the percentage property - Deleting files from cache

hi @balaji.ramaswamy

  1. if i run a query select * from A from UI, will it cache all the data from A? and by going into cache directory/files folder can i see some some reference to table A
    if we know what data exactly cached, we can pre populate cache before actual user/reporting happens.

  2. which part of query profile indicates if cache is used? only messages i see from profile is something like “PERMISSION_CACHE_HIT (0 ms)”

  3. this link indicates completely wiping out cache and disabling cache on a source. can i selectively cleanup some cache folders, by manually deleting some folder from cache files directory