turbot/aws_compliance

Query: opensearch_domain_data_node_fault_tolerance

Usage

powerpipe query aws_compliance.query.opensearch_domain_data_node_fault_tolerance

Steampipe Tables

SQL

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;

Controls

The query is being used by the following controls: