qua_refresh_view

Very similar to qua_full_load_cached_view_copy. The only difference is that qua_refresh_view verifies that cache mode is using persistent tables. For in-memory cache mode, it just throws an error. Internally it calls qua_full_load_cached_view_copy.

Syntax

qua_refresh_view 'view_name' [;]

Arguments

‘view_name’

Fully qualified name of view which cache will be affected.

Example

Refreshes in-memory cache for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_refresh_view 'AdventureWorksDW2012_spark.dbo.DimEmployee';