Reflection refreshing hourly?

I’m running Dremio 3.1.1 (Community Edition) and it looks like our Reflections are automatically refreshing hourly. At least that’s what I’m seeing in the jobs history. How can I change this schedule to be once daily?

Hi @summersmd,

The reflections refresh interval can be set at the source level or the individual physical dataset level. See: https://docs.dremio.com/acceleration/updating-reflections.html#refresh-policy-refresh-interval-and-expiration

You can select a source you’ve configured (like Elasticsearch or HDFS for example), or a specific dataset, and then click on the cog wheel icon to edit these settings from the UI:

These will refresh the downstream reflections based on these sources or tables. The refresh intervals set on individual tables/datasets within a source, will override those set at the source level.

1 Like