Creates a primary/secondary view copy for the materialized view. Copy needs to be created before it will be loaded. Note that this procedure does not load data, it just creates a place for the cache to be loaded later.

Can be used only with views that have the persistent cache configured. Secondary cache option is available only for the persistent cache with rotated tables.


lyft_create_view_copy 'view_name', 'primarycopy' [;]



Fully qualified name of view which data is to be copied.


SYSNAME that can be one of two values: 'primary' or 'secondary'.


Creates primary copy view for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC lyft_create_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'primary';