CODE EXAMPLE FOR SQL

big query get distinct array of objects

SELECT * REPLACE(
  dedup(country) AS country,
  dedup(product) AS product
)
FROM `project.dataset.table`