BIT_OR

1
SELECT
2
  user_group,
3
  BIT_OR(permissions) as any_permissions
4
FROM `project.dataset.user_permissions`
5
GROUP BY user_group;

1
SELECT
2
  country,
3
  BIT_OR(enabled_features) as available_features,
4
  BIN(BIT_OR(enabled_features)) as binary_view
5
FROM `project.dataset.regional_features`
6
GROUP BY country;

1
SELECT
2
  service_name,
3
  BIT_OR(error_type_flags) as error_types_seen
4
FROM `project.dataset.error_logs`
5
WHERE DATE(timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
6
GROUP BY service_name;