make_set

Collects distinct values from a column into a dynamic (JSON) array.

Spec

make_set(arg0)

Parameters

arg0 - The column to collect distinct values from.

Return Value

A dynamic (JSON) array containing distinct non-null values.

Example

datatable(val:string)["a", "b", "a"]
| summarize unique_vals = make_set(val)

| unique_vals | | ----------- | | ["a","b"] | The query fails clearly if a group exceeds the default collection limit of 1,048,576 distinct elements. Equality is typed; string values use case-sensitive ordinal UTF-8 bytes.