Table of Contents

Class AzureSynapseAnalyticsSchema.NodesPartition

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.pdw_nodes_partitions (Transact-SQL)

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

Contains a row for each partition of all the tables, and most types of indexes in a Azure Synapse Analytics database. All tables and indexes contain at least one partition, whether or not they are explicitly partitioned.


See sys.pdw_nodes_partitions.

[Table(Schema = "sys", Name = "pdw_nodes_partitions", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesPartition
Inheritance
AzureSynapseAnalyticsSchema.NodesPartition
Extension Methods

Properties

DataCompression

Indicates the state of compression for each partition:

0 = NONE

1 = ROW

2 = PAGE

3 = COLUMNSTORE

[Column("data_compression")]
[NotNull]
public int DataCompression { get; set; }

Property Value

int

DataCompressionDesc

Indicates the state of compression for each partition. Possible values are NONE, ROW, and PAGE.

[Column("data_compression_desc")]
[NotNull]
public string DataCompressionDesc { get; set; }

Property Value

string

HoBTID

ID of the data heap or B-tree (HoBT) that contains the rows for this partition.

[Column("hobt_id")]
[NotNull]
public long HoBTID { get; set; }

Property Value

long

IndexID

ID of the index within the object to which this partition belongs.

[Column("index_id")]
[NotNull]
public int IndexID { get; set; }

Property Value

int

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the object to which this partition belongs. Every table or view is composed of at least one partition.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PartitionID

ID of the partition. Is unique within a database.

[Column("partition_id")]
[NotNull]
public long PartitionID { get; set; }

Property Value

long

PartitionNumber

1-based partition number within the owning index or heap. For Azure Synapse Analytics, the value of this column is 1.

[Column("partition_number")]
[NotNull]
public int PartitionNumber { get; set; }

Property Value

int

PdwNodeID

Unique identifier of a Azure Synapse Analytics node.

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

Property Value

int

Rows

Approximate number of rows in this partition.

[Column("rows")]
[NotNull]
public long Rows { get; set; }

Property Value

long