turbot/aws_insights

Query: elasticache_cluster_node_overview

Usage

powerpipe query aws_insights.query.elasticache_cluster_node_overview

Steampipe Tables

SQL

select
title as "Title",
auth_token_enabled as "Auth Token Enabled",
auto_minor_version_upgrade as "Auto Minor Version Upgrade",
cache_cluster_create_time as "Create Time",
cache_subnet_group_name as "Subnet Group Name",
engine as "Engine",
engine_version as "Engine Version",
preferred_availability_zone as "Preferred Availability Zone",
region as "Region",
account_id as "Account ID",
arn as "ARN"
from
aws_elasticache_cluster
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: