qua_set_reload_mode

qua_set_reload_mode#

Sets reload mode for given view. Reload mode describes steps to be taken when refreshing the persistent cache.

Syntax#

qua_set_reload_mode 'object', 'mode' [;]

Arguments#

‘cache_mode’

Fully qualified name of view which incremental marker will be changed.

‘mode’

NVARCHAR(20) mode to be set, with one of the following values:

  • ‘full’ = cache cleaned up and reloaded every time.

  • ‘incremental’ = cache is loaded fully only on initial load, after that only new rows are inserted during reload.

Example#

Sets cache mode of view ‘’AdventureWorksDW2012_spark.dbo.DimEmployee’ to ‘incremental’

EXEC qua_set_reload_mode 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'incremental';