Drops persistent cache and recreates it. Can be used only with views that have a persistent cache configured. Secondary cache option is available only for a persistent cache with rotated tables. Internally uses lyft_create_view_copy.
Syntax
lyft_trim_view_copy 'view_name', 'copy' [;]
Arguments
'view_name'
Fully qualified name of view which data will be affected.
'copy'
SYSNAME that can be one of two values: 'primary' or 'secondary'.
Example
Drops and recreates primary cache copy for AdventureWorksDW2012_spark.dbo.DimEmployee.
EXEC lyft_trim_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'primary';