turbot/aws_compliance

Query: es_domain_data_nodes_min_3

Usage

powerpipe query aws_compliance.query.es_domain_data_nodes_min_3

Steampipe Tables

SQL

select
arn as resource,
case
when elasticsearch_cluster_config ->> 'ZoneAwarenessEnabled' = 'false' then 'alarm'
when
elasticsearch_cluster_config ->> 'ZoneAwarenessEnabled' = 'true'
and (elasticsearch_cluster_config ->> 'InstanceCount')::integer >= 3 then 'ok'
else 'alarm'
end status,
case
when elasticsearch_cluster_config ->> 'ZoneAwarenessEnabled' = 'false' then title || ' zone awareness disabled.'
else title || ' has ' || (elasticsearch_cluster_config ->> 'InstanceCount') || ' data node(s).'
end as reason
, region, account_id
from
aws_elasticsearch_domain;

Controls

The query is being used by the following controls: