Applies to: Parallel Data Warehouse
Contains information about ongoing and completed load operations in Parallel Data Warehouse. The information persists across system restarts.
|Column Name||Data Type||Description||Range|
|run_id||int||Unique identifier of a loader run.|
|stage||nvarchar(30)||The current stage for the run.||'CREATE_STAGING', 'DMS_LOAD', 'LOAD_INSERT', 'LOAD_CLEANUP'|
|request_id||nvarchar(32)||ID of the request running this stage.|
|status||nvarchar(16)||Status of this phase.|
|start_time||datetime||Time at which the stage was started.|
|end_time||datetime||Time at which the stage ended, if any.||NULL if not started or in progress.|
|total_elapsed_time||int||Total time this stage spent (or spent so far) running.||If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow.
The maximum value in milliseconds is equivalent to 24.8 days.