distinct operator

Produces a table with the distinct combination of the provided columns of the input table.

T | distinct Column1, Column2

Produces a table with the distinct combination of all columns in the input table.

T | distinct *

Example

Shows the distinct combination of fruit and price.

Table | distinct fruit, price

Two tables. One has suppliers, fruit types, and prices, with some fruit-price combinations repeated. The second table lists only unique combinations.

Notes

Unlike summarize by ..., the distinct operator supports providing an asterisk (*) as the group key, making it easier to use for wide tables.
If the group by keys are of high cardinalities, using summarize by ... with the shuffle strategy could be useful.