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' [;]
Arguments
'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.
Example
Sets cache mode of view ''AdventureWorksDW2012_spark.dbo.DimEmployee' to 'incremental'
EXEC lyft_set_reload_mode 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'incremental';