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?
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.