sys.pdw_distributions (Transact-SQL)

Applies to: yesAzure Synapse Analytics yesParallel 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.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views