Switches view copy between the primary and secondary table for cached views with two rotated tables.
The procedure is called internally by lyft_full_load_cached_view_copy just after the secondary copy was loaded. Note that this procedure does not execute any data load or cache eviction.
Syntax
lyft_switch_view_copy 'view_name' [;]
Arguments
'view_name'
Fully qualified name of view which status will be affected.
Example
Switches between primary and secondary cache copy for AdventureWorksDW2012_spark.dbo.DimEmployee.
EXEC lyft_switch_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee';