steampipe plugin install aws

Table: aws_dax_parameter - Query AWS DAX Parameter Groups using SQL

AWS DAX Parameter Groups are a collection of parameters that you apply to all of the nodes in a DAX cluster. These groups make it easier to manage clusters by enabling you to customize their behavior without having to individually modify each node. They are particularly useful when you want to set consistent parameters across a large number of nodes.

Table Usage Guide

The aws_dax_parameter table in Steampipe provides you with information about Parameter Groups within AWS DynamoDB Accelerator (DAX). This table allows you, as a DevOps engineer, to query parameter group-specific details, including parameter names, types, values, and whether they are modifiable or not. You can utilize this table to gather insights on parameter groups, such as understanding the configurations that control the behavior of your DAX clusters, and to verify if the parameters are set as per your requirements. The schema outlines the various attributes of the DAX parameter group for you, including the parameter name, value, source, data type, and whether it's modifiable or not.

Examples

Basic info

Explore which parameters are in use within your AWS DAX settings to understand their values and types. This information can assist in assessing the configuration for optimal performance and security.

select
parameter_name,
parameter_group_name,
parameter_value,
data_type,
parameter_type
from
aws_dax_parameter;
select
parameter_name,
parameter_group_name,
parameter_value,
data_type,
parameter_type
from
aws_dax_parameter;

Count parameters by parameter group

Identify the distribution of parameters across different parameter groups and regions. This can help you understand how parameters are organized in your AWS DAX environment, which is useful for managing and optimizing your configurations.

select
parameter_group_name,
region,
count(parameter_name) as number_of_parameters
from
aws_dax_parameter
group by
parameter_group_name,
region;
select
parameter_group_name,
region,
count(parameter_name) as number_of_parameters
from
aws_dax_parameter
group by
parameter_group_name,
region;

List modifiable parameters

Identify instances where parameters can be modified in your AWS DAX setup. This is useful to understand which aspects of your configuration can be adjusted to optimize performance.

select
parameter_name,
parameter_group_name,
parameter_value,
data_type,
parameter_type,
is_modifiable
from
aws_dax_parameter
where
is_modifiable = 'TRUE';
select
parameter_name,
parameter_group_name,
parameter_value,
data_type,
parameter_type,
is_modifiable
from
aws_dax_parameter
where
is_modifiable = 'TRUE';

List parameters that are not user defined

Identify the parameters in your AWS DAX that are not user-defined. This can help ensure that system-defined settings are not inadvertently altered, maintaining system stability and performance.

select
parameter_name,
change_type,
parameter_group_name,
parameter_value,
data_type,
parameter_type,
source
from
aws_dax_parameter
where
source <> 'user';
select
parameter_name,
change_type,
parameter_group_name,
parameter_value,
data_type,
parameter_type,
source
from
aws_dax_parameter
where
source != 'user';

Schema for aws_dax_parameter

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
allowed_valuestextA range of values within which the parameter can be set.
change_typetextThe conditions under which changes to this parameter can be applied. Possible values are 'IMMEDIATE', 'REQUIRES_REBOOT'.
data_typetextThe data type of the parameter.
descriptiontextDescription of the parameter.
is_modifiabletextWhether the customer is allowed to modify the parameter. Possible values are 'TRUE', 'FALSE' 'CONDITIONAL'.
parameter_group_nametext=The name of the parameter group.
parameter_nametextThe name of the parameter.
parameter_typetextDetermines whether the parameter can be applied to any node or only nodes of a particular type. Possible values are 'DEFAULT', 'NODE_TYPE_SPECIFIC'.
parameter_valuetextThe value of the parameter.
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.
sourcetextHow the parameter is defined. For example, system denotes a system-defined parameter.
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_dax_parameter