Cache management

Stored procedures for managing materialized (cached) views and their physical storage.

Stored procedure name	Description
qua_create_view_copy	Creates a primary/secondary view copy for the materialized view.
qua_evict_spark_inmem_cached_table	Removes data from Spark in-memory cache for given table.
qua_full_load_cached_view_copy	Loads cache for a given view.
qua_full_load_view_copy	Fills a primary/secondary view copy.
qua_incremental_insert	Inserts new rows into an incrementally cached view.
qua_incremental_load_cached_view_copy	Conducts the whole process of an incremental load of new rows.
qua_invalidate_spark_cached_table	Invalidates and then loads Spark in-memory cache for given table.
qua_populate_cached_table	Materializes a cached view.
qua_refresh_view	Refreshes the materialized view by reloading the cache.
qua_set_incremental_marker	Sets new incremental marker value for given table or view.
qua_set_incremental_marker_column	Sets incremental marker column for given table or view. The column will be later used for incremental load process.
qua_set_reload_mode	Sets reload mode for a given view.
qua_set_view_cache_mode	Sets the cache mode for a given view.
qua_set_view_copy_status	Allows setting the view cache internal status flag. Useful for manual cache management.
qua_switch_view_copy	Switches view copy between the primary and secondary table for cached views with two rotated tables.
qua_trim_view_copy	Drops persistent cache and recreates it.