GET_PROJECTION_STATUS

Returns information relevant to the status of a projection:

Use GET_PROJECTION_STATUS to monitor the progress of a projection data refresh.

Syntax

GET_PROJECTION_STATUS ( '[schema-name.]projection' );

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
projection

The projection for which to display status.

Examples

=> SELECT GET_PROJECTION_STATUS('public.customer_dimension_site01');                                     GET_PROJECTION_STATUS
-----------------------------------------------------------------------------------------------
 Current system K is 1.
# of Nodes: 4.
public.customer_dimension_site01 [Segmented: No] [Seg Cols: ] [K: 3] [public.customer_dimension_site04, public.customer_dimension_site03, 
public.customer_dimension_site02]
[Safe: Yes] [UptoDate: Yes][Stats: Yes]