| title | sys.pdw_health_components (Transact-SQL) | |
|---|---|---|
| description | See a reference for the system catalog view sys.pdw_health_components (Transact-SQL) for Analytics Platform System. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.date | 05/12/2022 | |
| ms.service | sql | |
| ms.subservice | system-objects | |
| ms.topic | reference | |
| ms.custom | kr2b-contr-experiment | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016 |
[!INCLUDE pdw]
This view stores information about all components and devices that exist in the system. These components and devices include hardware, storage devices, and network devices.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| component_id | int | Unique identifier of a component or device. Key for this view. |
NOT NULL |
| group_id | int | The logical component group to which this component belongs. See sys.pdw_health_component_groups (Parallel Data Warehouse). | NOT NULL |
| component_name | nvarchar(255) | Name of the component. | NOT NULL |
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views