De-duplicating with ROW_NUMBER vs ARRAY_AGG

What function do you use to explicitly de-duplicate in BigQuery?I normally use ROW_NUMBER(), but I've recently encountered a really interesting blog post suggesting ARRAY_AGG might be more performant for the task. The explanation given is that the OR...