# How to check if c3 cache is used in query?
**URL:** https://community.dremio.com/t/how-to-check-if-c3-cache-is-used-in-query/11536
**Category:** Dremio University
**Created:** [February 22, 2024, 7:38am UTC](https://community.dremio.com/t/how-to-check-if-c3-cache-is-used-in-query/11536 "2024-02-22T07:38:29Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@shraddhagrawal](https://community.dremio.com/u/shraddhagrawal)
#### Post date: [February 22, 2024, 7:38am UTC](https://community.dremio.com/t/how-to-check-if-c3-cache-is-used-in-query/11536/1 "2024-02-22T07:38:29Z")
Hi,
I have enabled cache for Amazon S3 data source and kept CTAS format as ICEBERG.as mentioned in [How do we check if cache is used or not - #2 by ben](https://community.dremio.com/t/how-do-we-check-if-cache-is-used-or-not/6191/2) I am not able to see “Operator Metrics” in raw profile nor I am able to see Parquet row group scan
I am getting Operator Metrics in ICEBERG SUB Scan.Is it same?
---
### Author:  [@shraddhagrawal](https://community.dremio.com/u/shraddhagrawal)
#### Post date: [February 27, 2024, 8:53am UTC](https://community.dremio.com/t/how-to-check-if-c3-cache-is-used-in-query/11536/2 "2024-02-27T08:53:17Z")
@balaji.ramaswamy Could you please check my question?This is very crucial for us
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [March 3, 2024, 1:57am UTC](https://community.dremio.com/t/how-to-check-if-c3-cache-is-used-in-query/11536/3 "2024-03-03T01:57:41Z")
@shraddhagrawal PARQUET\_ROW\_GROUP\_SCAN is only on older versions. Now there are 3 scans
- `ICEBERG_SUB_SCAN` is scan of the MANIFEST LIST file
- `TABLE_FUNCTION` type=`SPLIT_GEN_MANIFEST_SCAN` is the MANIFEST scan
- `TABLE_FUNCTION` type=`DATA_FILE_SCAN` is the actual scan of the Parquet files
In all of the above scan you should see if C3 was used. Expand operator metrics and scroll to the right and see NUM\_CACHE\_HITS and NUM\_CACHE\_MISSES, like below
