Setting the Expiration Policy for Reflections

Rather than delete a reflection manually, you can specify how long you want Dremio to retain the reflection before deleting it automatically.

note:

Dremio does not allow expiration policies to be set on external reflections.

Procedures

To set the expiration policy for all reflections derived from tables in a data source:

1. Right-click a data lake or external source.
2. Select Edit Details.
3. In the sidebar of the Edit Source window, click Reflection Refresh.
4. After making your changes, click Save. The changes take effect on the next refresh.

To set the expiration policy on reflections derived from a particular table:

note:

The table must be based on more than one file.

1. Locate a table.
2. Click the gear icon to its right.
3. In the sidebar of the Dataset Settings window, click Reflection Refresh.
4. After making your changes, click Save. The changes take effect on the next refresh.