lyft_full_load_view_copy

Fills a primary/secondary view copy. Insert statement is executed using 'ETL' spark scheduler pool.

Syntax

lyft_full_load_view_copy 'view_name' [;]

Arguments

'view_name'

Fully qualified name of view which data will be loaded.

'copy'

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

Example

Fills primary copy cache for AdventureWorksDW2012_spark.dbo.DimEmployee.

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