Hi @eriodega ,

If you want just to get a single row then do not use OVER:

%sql
WITH Blah(col1, i) AS (
    SELECT 'abc', 1
    UNION
    SELECT 'def', 2
    UNION
    SELECT 'ghi', 3
)

SELECT array_join(collect_set(col1), ',') AS concatenated_string
FROM Blah

 Results: