sys.pdw_loader_run_stages (Transact-SQL)

Applies to: yesParallel 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.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views