Class AzureSynapseAnalyticsSchema.Distribution

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

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.

See sys.pdw_distributions.

[Table(Schema = "sys", Name = "pdw_distributions", IsView = true)]
public class AzureSynapseAnalyticsSchema.Distribution

Inheritance

object

AzureSynapseAnalyticsSchema.Distribution

Extension Methods

Map.DeepCopy<T>(T)

Properties

DistributionID

Unique numeric id associated with the distribution.

Key for this view.
Range: 1 to the number of Compute nodes in appliance multiplied by the number of distributions per Compute node.

[Column("distribution_id")]
[NotNull]
public int DistributionID { get; set; }

Property Value

int

Name

String identifier associated with the distribution, used as a suffix on distributed tables.
Range: String composed of 'A-Z','a-z','0-9','_','-'.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PdwNodeID

ID of the node this distribution is on.
Range: See pdw_node_id in sys.dm_pdw_nodes (Transact-SQL).

[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

Position

Position of the distribution within a node respective to other distributions on that node.
Range: 1 to the number of distributions per node.

[Column("position")]
[NotNull]
public int Position { get; set; }

Property Value

int