sys.pdw_loader_run_stages (Transact-SQL)
Applies to: Analytics Platform System (PDW)
Contains information about ongoing and completed load operations in Analytics Platform System (PDW). 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