ARRAY_CONCAT_AGG

1
SELECT
2
  category,
3
  ARRAY_CONCAT_AGG(tags) as all_tags
4
FROM `project.dataset.products`
5
GROUP BY category;

1
SELECT
2
  user_id,
3
  ARRAY_CONCAT_AGG(daily_activities ORDER BY activity_date) as all_activities
4
FROM `project.dataset.user_logs`
5
GROUP BY user_id;

1
SELECT
2
  store_id,
3
  ARRAY_CONCAT_AGG(product_ids) as all_product_ids,
4
  ARRAY_LENGTH(ARRAY_CONCAT_AGG(product_ids)) as total_products
5
FROM `project.dataset.store_inventory`
6
GROUP BY store_id;