qua_refresh_persistent_cache

Refreshes the given materialized view using the view’s configured materialization strategy. For example, if the view uses incremental materialization, this procedure will refresh the view incrementally.

For in-memory cache mode, it throws an error.

Syntax

qua_refresh_persistent_cache 'view_name' [;]

Arguments

‘view_name’

Fully qualified name of the materialized view to refresh.

Example

Refreshes the materialized view AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_refresh_persistent_cache 'AdventureWorksDW2012_spark.dbo.DimEmployee';