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

object

AzureSynapseAnalyticsSchema.NodesPartition

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

DataCompression

data_compression NOT NULL int

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

data_compression_desc NOT NULL nvarchar(60)

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

hobt_id NOT NULL bigint

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

index_id NOT NULL int

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

object_id NOT NULL int

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

partition_id NOT NULL bigint

ID of the partition. Is unique within a database.

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

Property Value

long

PartitionNumber

partition_number NOT NULL int

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

pdw_node_id NOT NULL int

Unique identifier of a Azure Synapse Analytics node.

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

Property Value

int

Rows

rows NOT NULL bigint

Approximate number of rows in this partition.

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

Property Value

long