SYS.REFLECTION_REFRESH_SETTINGS

Returns the refresh settings for a Reflection, including settings inherited from the datasets that the Reflection depends on.

Syntax

SELECT * FROM TABLE(sys.reflection_refresh_settings('<reflection_id>'))

Parameter

<reflection_id> String

The ID of the Reflection. If you need to find a Reflection ID, see Obtaining Reflection IDs.

Return the settings for a Reflection that depends on multiple datasets

SELECT * FROM TABLE(sys.reflection_refresh_settings('64p1a2eb-2811-3efb-805d-00c428f21079'));

Example of the query result

table_type	table_path	table_version_context	overrides_source	refresh_method	refresh_policy	refresh_period_seconds	refresh_schedule	never_expire	expire_after_seconds
DATASET	prod.data.users	empty text	false	FULL	PERIOD	21600	empty text	false	10800
DATASET	prod.data.views	{"type":"BRANCH","value":"main"}	true	AUTO	LIVE_REFRESH	-1	empty text	true	-1
DATASET	prod.data.stats	empty text	true	AUTO	SCHEDULE	-1	0 0 8 * * *	true	empty text

note

Irrelevant columns are assigned sentinel values: -1 for numbers and an empty string for text.

Column	Data Type	Description
table_type	varchar	Defines the type of table. Enum: `DATASET` or `EXTERNAL_QUERY`
table_path	varchar	Identifies the path to the dataset or external query source that the Reflection depends on.
table_version_context	varchar	Specifies the versioning context for datasets, stored in JSON format.
overrides_source	boolean	Indicates whether settings are inherited from the source (`true`) or set on the table (`false`).
refresh_method	varchar	Shows the method used for the most recent refresh of the Reflection. Enum: `FULL`, `INCREMENTAL`, `AUTO`
refresh_policy	varchar	Identifies the type of refresh policy. Enum: `PERIOD`, `SCHEDULE`, `LIVE_REFRESH`, `NEVER_REFRESH`
refresh_period_seconds	double	Specifies the time in seconds (truncated from milliseconds) between refreshes.
refresh_schedule	varchar	Provides the cron expression (UTC) that defines the refresh schedule for the Reflection.
never_expire	boolean	Indicates whether the Reflection never expires (`true`) or uses the expiration setting (`false`).
expire_after_seconds	double	Defines the expiration time in seconds (truncated from milliseconds), after which the system removes the Reflection.