Query: s3_bucket_cross_region_replication

with bucket_with_replication as (
  select
    name,
    r ->> 'Status' as rep_status
  from
    aws_s3_bucket,
    jsonb_array_elements(replication -> 'Rules') as r
)
select
  'Cross-Region Replication' as label,
  case
    when b.name = r.name
    and r.rep_status = 'Enabled' then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when b.name = r.name
    and r.rep_status = 'Enabled' then 'ok'
    else 'alert'
  end as type
from
  aws_s3_bucket b
  left join bucket_with_replication r on b.name = r.name
where
  arn = $1;