Announcing NBCROW Compression in Kusto's TDS Implementation

Azure Updates

Discussionpowered by zap.ms

Published

Feb 26, 2024

Status

Launched

Timeline

  • February 2024
    General Availability

Product

Azure Data Explorer
Azure Synapse Analytics
Microsoft Fabric

Tag

Features

Category

Analytics

Description

We are excited to announce NBCROW compression as a new feature in Kusto's TDS implementation. NBCROW stands for Null Bitmap Compressed Row. It is a data type that the Tabular Data Stream (TDS) protocol supports. TDS is a binary protocol that Kusto uses to communicate with MSSQL clients and return query results. NBCROW compresses the null values in a row of data into a bitmap, where each bit represents the presence or absence of a null value. This reduces the size of null values from 1 byte to 1 bit, saving 7 bits for each null value saving network bandwidth and improving query duration.

We hope you enjoy this feature and share your feedback with us.