# Dremio not reading the latest CSV from NAS

**URL:** <https://community.dremio.com/t/dremio-not-reading-the-latest-csv-from-nas/3648>\
**Category:** Uncategorized\
**Created:** [July 3, 2019, 2:46pm UTC](https://community.dremio.com/t/dremio-not-reading-the-latest-csv-from-nas/3648 "2019-07-03T14:46:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sajjan.jindal](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@sajjan.jindal](https://community.dremio.com/u/sajjan.jindal)\
**Post date:** [July 3, 2019, 2:46pm UTC](https://community.dremio.com/t/dremio-not-reading-the-latest-csv-from-nas/3648/1 "2019-07-03T14:46:42Z")

</div>

Hi Team,

I have mapped a NAS drive on dremio and formatted the drive into tabular format to query via Dremio.  
This drive contains a csv file, which is updated every four hours(file name remains unchanged) - I was expecting that dremio would read the most latest file from the mapped drive (Containing updated CSV files).  
I see variation in count of records in dremio vs the actual updated file.

Please note I have tried with and without reflections(hoping this could be related to caching of stale data) - in both cases I see that dremio does not read the latest csv file.

Reagrds,  
Sajjan

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [July 5, 2019, 2:26pm UTC](https://community.dremio.com/t/dremio-not-reading-the-latest-csv-from-nas/3648/2 "2019-07-05T14:26:10Z")

</div>

@sajjan.jindal

Assuming you promoted a folder containing csv files, then as long as you are only changing previously existing files things should work as you expect - running a count(\*) should always return the correct result. Note that preview queries may cache results so make sure its a full run.

If you are adding new files under the folder, these new files won’t be immediately detected - sources in Dremio have a metadata policy (edit a source and click on the metadata section). The default metadata refresh is one hour.

Reflections will indeed only show data that was present when the reflection was built - so that would depend on how often your reflections are refreshed (default is again one hour).

---

<div class="post-metadata">

**Author:** ![sajjan.jindal](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@sajjan.jindal](https://community.dremio.com/u/sajjan.jindal)\
**Post date:** [July 5, 2019, 4:01pm UTC](https://community.dremio.com/t/dremio-not-reading-the-latest-csv-from-nas/3648/3 "2019-07-05T16:01:24Z")

</div>

> [@doron](#):
>
> ntaining csv files, the

we are dropping the file via script which was only changing the last update time of the file and not the directory. using a touch command we modified the last update time of the directory and it worked.