sys.pdw_health_component_status_mappings (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Defines the mapping between the Azure Synapse Analytics component statuses and the manufacturer-defined component names.

Column Name	Data Type	Description	Range
property_id	int	Unique identifier of the property. property_id, component_id, and physical_name form the key for this view.	NOT NULL
component_id	int	The ID of the component. See sys.pdw_health_components (Transact-SQL). property_id, component_id, and physical_name form the key for this view.	NOT NULL
physical_name	nvarchar(32)	Property name as defined by the manufacturer. property_id, component_id, and physical_name form the key for this view.	NOT NULL
logical_name	nvarchar(255)	Property name as defined by Azure Synapse Analytics.	NOT NULL 0 - Device instance is unique. 1 - Device instance is not unique.

See Also