lyft_set_reload_mode

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

Syntax

lyft_set_reload_mode 'object', 'mode' [;]

'object'

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.

Sets cache mode of view ''AdventureWorksDW2012_spark.dbo.DimEmployee' to 'incremental'

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