sys.pdw_nodes_column_store_dictionaries (Transact-SQL)

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

Contains a row for each dictionary used in columnstore indexes. Dictionaries are used to encode some, but not all data types, therefore not all columns in a columnstore index have dictionaries. A dictionary can exist as a primary dictionary (for all segments) and possibly for other secondary dictionaries used for a subset of the column's segments.

Column name	Data type	Description
partition_id	bigint	Indicates the partition ID. Is unique within a database.
hobt_id	bigint	ID of the heap or B-tree index (HoBT) for the table that has this columnstore index.
column_id	int	ID of the columnstore column.
dictionary_id	int	Id of the dictionary.
version	int	Version of the dictionary format.
type	int	Dictionary type: 1 - Hash dictionary containing int values 2 - Not used 3 - Hash dictionary containing string values 4 - Hash dictionary containing float values
last_id	int	The last data id in the dictionary.
entry_count	bigint	Number of entries in the dictionary.
on_disk_size	bigint	Size of dictionary in bytes.
pdw_node_id	int	Unique identifier of a Azure Synapse Analytics node.

Permissions

Requires VIEW SERVER STATE permission.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
CREATE COLUMNSTORE INDEX (Transact-SQL)
sys.pdw_nodes_column_store_segments (Transact-SQL)
sys.pdw_nodes_column_store_row_groups (Transact-SQL)