sys.pdw_distributions (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) 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

SQL Data Warehouse and Parallel Data Warehouse Catalog Views