Table: aws_dax_parameter_group

Amazon DynamoDB Accelerator (DAX) Parameter Group is a named set of parameters that are applied to every node in the cluster. The parameters are the type of configuration that will be applied to the cluster during the creation.

Examples

Basic info

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

Count parameters by parameter group

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

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

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

.inspect aws_dax_parameter

AWS DAX Parameter

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
allowed_values	text	A range of values within which the parameter can be set.
change_type	text	The conditions under which changes to this parameter can be applied. Possible values are 'IMMEDIATE', 'REQUIRES_REBOOT'.
data_type	text	The data type of the parameter.
description	text	Description of the parameter.
is_modifiable	text	Whether the customer is allowed to modify the parameter. Possible values are 'TRUE', 'FALSE' 'CONDITIONAL'.
parameter_group_name	text	The name of the parameter group.
parameter_name	text	The name of the parameter.
parameter_type	text	Determines whether the parameter can be applied to any node or only nodes of a particular type. Possible values are 'DEFAULT', 'NODE_TYPE_SPECIFIC'.
parameter_value	text	The value of the parameter.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
source	text	How the parameter is defined. For example, system denotes a system-defined parameter.
title	text	Title of the resource.

turbot/aws