enable_subquery_remove_useless_order_by (boolean) ​

Yellowbrick by default ignores ORDER BY statements in CTEs and subqueries without a LIMIT clause. This causes unordered data to be returned by users of the STRING_AGG function. This optimization can be disabled:

ALTER SYSTEM set enable_subquery_remove_useless_order_by to 'off';