Table: aws_dax_clusters

This table shows data for Dax Clusters.

https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_dax_Cluster.html (opens in a new tab)

The primary key for this table is arn.

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
account_idutf8
regionutf8
arn (PK)utf8
tagsjson
active_nodesint64
cluster_arnutf8
cluster_discovery_endpointjson
cluster_endpoint_encryption_typeutf8
cluster_nameutf8
descriptionutf8
iam_role_arnutf8
node_ids_to_removelist<item: utf8, nullable>
node_typeutf8
nodesjson
notification_configurationjson
parameter_groupjson
preferred_maintenance_windowutf8
sse_descriptionjson
security_groupsjson
statusutf8
subnet_grouputf8
total_nodesint64

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

DynamoDB Accelerator (DAX) clusters should be encrypted at rest

SELECT
  'DynamoDB Accelerator (DAX) clusters should be encrypted at rest' AS title,
  account_id,
  arn AS resource_id,
  CASE
  WHEN sse_description->>'Status' IS DISTINCT FROM 'ENABLED' THEN 'fail'
  ELSE 'pass'
  END
    AS status
FROM
  aws_dax_clusters;