Query: opensearch_domain_data_node_fault_tolerance

select
  arn as resource,
  case
    when cluster_config ->> 'ZoneAwarenessEnabled' = 'true'
    and cluster_config ->> 'InstanceCount' > '2' then 'ok'
    else 'alarm'
  end as status,
  case
    when cluster_config ->> 'ZoneAwarenessEnabled' = 'true'
    and cluster_config ->> 'InstanceCount' > '2' then title || ' zone awareness is ' || case
      when cluster_config ->> 'ZoneAwarenessEnabled' = 'true' then 'enabled'
      else 'disabled'
    end || ' with ' || (cluster_config ->> 'InstanceCount') || ' data node(s) configued.'
    else title || ' zone awareness is ' || case
      when cluster_config ->> 'ZoneAwarenessEnabled' = 'true' then 'enabled'
      else 'disabled'
    end || ' with ' || (cluster_config ->> 'InstanceCount') || ' data node(s) configued.'
  end as reason,
  region,
  account_id
from
  aws_opensearch_domain;