Skip to main content

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 or Reflections that automatically refresh when Iceberg data changes according to the refresh policy.

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.