# Question's on cloud cache
**URL:** https://community.dremio.com/t/questions-on-cloud-cache/5010
**Category:** Uncategorized
**Created:** [February 6, 2020, 10:53pm UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010 "2020-02-06T22:53:40Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@smora](https://community.dremio.com/u/smora)
#### Post date: [February 6, 2020, 10:53pm UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/1 "2020-02-06T22:53:41Z")
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
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [February 10, 2020, 7:32pm UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/2 "2020-02-10T19:32:46Z")
@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](https://docs.dremio.com/deployment/cloud-cache-config.html#best-practices)
---
### Author:  [@smora](https://community.dremio.com/u/smora)
#### Post date: [February 10, 2020, 8:15pm UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/3 "2020-02-10T20:15:50Z")
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
---
### Author:  [@lfcosio](https://community.dremio.com/u/lfcosio)
#### Post date: [February 18, 2021, 9:57am UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/4 "2021-02-18T09:57:42Z")
any update on @smora question? I am interested in cleaning up some cache folders
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [February 20, 2021, 7:14am UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/5 "2021-02-20T07:14:09Z")
#1 Yes, if you run select \* from UI (run), that should cache all rows so subsequent queries on that dataset should use C3 cache. The files are under the folder configured but not readable.
#2 Expand the Parquet\_Scan, scroll to the Operator\_metrics section and scroll to the right and you will see “NUM\_CACHE\_HITS” and “NUM\_CACHE\_MISSES”, see attached screenshot
#3 Currently this is not possible
---
### Author:  [@tid](https://community.dremio.com/u/tid)
#### Post date: [February 22, 2021, 9:28am UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/6 "2021-02-22T09:28:54Z")
Queries run via UI are truncated to roughly 1M records. Does Dremio still fetch all the data from the data lake and stores it in C3 or would it only cache the Parquet files required for the ~ 1M records?
---
### Author:  [@GrigorievNick](https://community.dremio.com/u/GrigorievNick)
#### Post date: [June 24, 2022, 9:30am UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/7 "2022-06-24T09:30:15Z")
I have exactly same question.
Plus to this, I want understand can I disable cache for only one table?
Some of my tables has very fat columns, which never used in Queries only in ETL flow.
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [July 2, 2022, 7:40am UTC](https://community.dremio.com/t/questions-on-cloud-cache/5010/8 "2022-07-02T07:40:13Z")
@GrigorievNick Dremio will not cache all records, if you do want that, best is to run via JDBC so the results are not truncated .Currently, disabling cace for a particular table is not possible