Applies to: Azure Synapse Analytics Parallel Data Warehouse
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.|