| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.pdw_loader_run_stages (Transact-SQL) |
sys.pdw_loader_run_stages (Transact-SQL) |
WilliamDAssafMSFT |
wiassaf |
03/04/2017 |
sql |
system-objects |
reference |
|
>=aps-pdw-2016 |
[!INCLUDE pdw]
Contains information about ongoing and completed load operations in [!INCLUDEssPDW]. 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. |
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views