steampipe plugin install aws

Table: aws_elasticache_parameter_group - Query AWS Elasticache Parameter Groups using SQL

The AWS ElastiCache Parameter Group is a feature of Amazon ElastiCache that allows you to manage the runtime settings for your ElastiCache instances. These groups enable you to apply identical configurations to multiple instances, enhancing the ease of setup and consistency across your cache environment. This resource is useful in both Memcached and Redis cache engines, providing control over cache security, memory usage, and other operational parameters.

Table Usage Guide

The aws_elasticache_parameter_group table in Steampipe provides you with information about Parameter Groups within AWS Elasticache. This table allows you, as a DevOps engineer, database administrator, or other technical professional, to query group-specific details, including associated parameters, parameter values, and descriptions. You can utilize this table to gather insights on parameter groups, such as their configurations, default system parameters, and user-defined parameters. The schema outlines the various attributes of the Parameter Group for you, including the group name, family, description, and associated parameters.

Examples

Basic info

Explore the characteristics of your AWS ElastiCache parameter groups to understand their configurations and global status. This can be useful in managing and optimizing your cache environments within AWS.

select
cache_parameter_group_name,
description,
cache_parameter_group_family,
description,
is_global
from
aws_elasticache_parameter_group;
select
cache_parameter_group_name,
description,
cache_parameter_group_family,
description,
is_global
from
aws_elasticache_parameter_group;

List parameter groups that are not compatible with redis 5.0 and memcached 1.5

Determine the areas in which parameter groups are incompatible with specific versions of Redis and Memcached. This can be useful to identify potential upgrade paths or to troubleshoot issues related to mismatched software versions.

select
cache_parameter_group_family,
count(*) as count
from
aws_elasticache_parameter_group
where
cache_parameter_group_family not in ('redis5.0', 'memcached1.5')
group by
cache_parameter_group_family;
select
cache_parameter_group_family,
count(*) as count
from
aws_elasticache_parameter_group
where
cache_parameter_group_family not in ('redis5.0', 'memcached1.5')
group by
cache_parameter_group_family;

Schema for aws_elasticache_parameter_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe ARN (Amazon Resource Name) of the cache parameter group.
cache_parameter_group_familytextThe name of the cache parameter group family that this cache parameter group is compatible with.
cache_parameter_group_nametext=The name of the cache parameter group.
descriptiontextThe description for the cache parameter group.
is_globalbooleanIndicates whether the parameter group is associated with a Global Datastore.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_elasticache_parameter_group