using suppress_counts_and_repeats

example 1

with data as (
  select
    suppress_and_count_repeats (
      'pipes',
      'pipes_organization_member',
      'org_handle',
      'user_handle, user_id, status',
      array['user_handle', 'user_id', 'status']
    ) as json_data
)
select
  json_data ->> 'display_partition_column' as org_handle,
  (json_data -> 'additional_columns' ->> 0) as user_handle,
  (json_data -> 'additional_columns' ->> 1) as user_id,
  (json_data -> 'additional_columns' ->> 2) as status
from
  data

example 2

with data as (
    select
        suppress_and_count_repeats(
            'pipes',
            'pipes_connection',
            'plugin',
            'identity_handle, handle',
            array['identity_handle', 'handle', 'created_by']
        ) as json_data
)
select
    json_data->>'display_partition_column' as plugin,
    concat(
      json_data->'additional_columns'->>0,
      '/',
      json_data->'additional_columns'->>1
    ) as org_workspace,
    json_data->'additional_columns'->2->>'handle' as conn_created_by
from data

judell/using_suppress_counts_and_repeats..md