sys.pdw_distributions (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Holds information about the distributions on the appliance. It lists one row per appliance distribution.

Column Name	Data Type	Description	Range
distribution_id	int	Unique numeric id associated with the distribution. Key for this view.	1 to the number of Compute nodes in appliance multiplied by the number of distributions per Compute node.
pdw_node_id	int	ID of the node this distribution is on.	See pdw_node_id in sys.dm_pdw_nodes (Transact-SQL).
name	nvarchar(32)	String identifier associated with the distribution, used as a suffix on distributed tables.	String composed of 'A-Z','a-z','0-9','_','-'.
position	int	Position of the distribution within a node respective to other distributions on that node.	1 to the number of distributions per node.

See Also