ARRAY_UNIQUE_AGG

Learn how to use the ARRAY_UNIQUE_AGG array function in PlaidCloud Lakehouse. Aggregates values into an array of distinct values - with syntax and examples.

Aggregates values into an array of distinct values.

Analyze Syntax

func.array_unique_agg(get_column(table, 'tag'))

Analyze Examples

func.array_unique_agg(get_column(table, 'tag'))

┌───────────────┐
│ ['a','b','c'] │
└───────────────┘

SQL Syntax

ARRAY_UNIQUE_AGG(<tag>)

SQL Examples

SELECT ARRAY_UNIQUE_AGG(tag) FROM tags;

┌───────────────┐
│ ["a","b","c"] │
└───────────────┘