# For metedata table INFORMATION\_SCHEMA.COLUMNS

**URL:** <https://community.dremio.com/t/for-metedata-table-information-schema-columns/6220>\
**Category:** Dremio University\
**Created:** [September 7, 2020, 4:15am UTC](https://community.dremio.com/t/for-metedata-table-information-schema-columns/6220 "2020-09-07T04:15:10Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [September 8, 2020, 5:36am UTC](https://community.dremio.com/t/for-metedata-table-information-schema-columns/6220/8 "2020-09-08T05:36:45Z")

</div>

@dolphinlei @fetanchaud

For non file system sources, the default is one hour where we look for new tables, open the source settings on Dremio and click on the metadata tab and then see “Dataset Discovery”

For new columns added, look just below for “Dataset Details”

Here is the full documentation on this

[http://docs.dremio.com/advanced-administration/metadata-caching.html](http://docs.dremio.com/advanced-administration/metadata-caching.html)

Once we discover a table via the light probe “Data set discovery” we would add it to information\_schema, this does not mean we collect metadata (dataset details), we only do it for objects that have atleast been queries once

---

_[View the full topic](https://community.dremio.com/t/for-metedata-table-information-schema-columns/6220)._
