Skip to content

aws.elasticache.describe_update_actions

Example SQL Queries

SELECT * FROM
aws.elasticache.describe_update_actions;

Description

Returns details of the update actions

Table Definition

Column NameColumn Data Type
cache_cluster_ids Input Column

The cache cluster IDs

VARCHAR[]
Show child fields
cache_cluster_ids[]
engine Input Column

The Elasticache engine to which the update applies. Either Redis OSS or Memcached.

VARCHAR
replication_group_ids Input Column

The replication group IDs

VARCHAR[]
Show child fields
replication_group_ids[]
service_update_name Input Column

The unique ID of the service update

VARCHAR
service_update_time_range Input Column

The range of time specified to search for service updates that are in available status

STRUCT(
"start_time" TIMESTAMP_S,
"end_time" TIMESTAMP_S
)
Show child fields
service_update_time_range.end_time

The end time of the time range filter

service_update_time_range.start_time

The start time of the time range filter

show_node_level_update_status Input Column

Dictates whether to include node level update status in the response

BOOLEAN
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
_input_service_update_status Input Column
VARCHAR[]
Show child fields
_input_service_update_status[]
_input_update_action_status Input Column
VARCHAR[]
Show child fields
_input_update_action_status[]
cache_cluster_id

The ID of the cache cluster

VARCHAR
cache_node_update_status

The status of the service update on the cache node

STRUCT(
"cache_node_id" VARCHAR,
"node_update_status" VARCHAR,
"node_deletion_date" TIMESTAMP_S,
"node_update_start_date" TIMESTAMP_S,
"node_update_end_date" TIMESTAMP_S,
"node_update_initiated_by" VARCHAR,
"node_update_initiated_date" TIMESTAMP_S,
"node_update_status_modified_date" TIMESTAMP_S
)[]
Show child fields
cache_node_update_status[]
Show child fields
cache_node_update_status[].cache_node_id

The node ID of the cache cluster

cache_node_update_status[].node_deletion_date

The deletion date of the node

cache_node_update_status[].node_update_end_date

The end date of the update for a node

cache_node_update_status[].node_update_initiated_by

Reflects whether the update was initiated by the customer or automatically applied

cache_node_update_status[].node_update_initiated_date

The date when the update is triggered

cache_node_update_status[].node_update_start_date

The start date of the update for a node

cache_node_update_status[].node_update_status

The update status of the node

cache_node_update_status[].node_update_status_modified_date

The date when the NodeUpdateStatus was last modified>

estimated_update_time

The estimated length of time for the update to complete

VARCHAR
node_group_update_status

The status of the service update on the node group

STRUCT(
"node_group_id" VARCHAR,
"node_group_member_update_status" STRUCT(
"cache_cluster_id" VARCHAR,
"cache_node_id" VARCHAR,
"node_update_status" VARCHAR,
"node_deletion_date" TIMESTAMP_S,
"node_update_start_date" TIMESTAMP_S,
"node_update_end_date" TIMESTAMP_S,
"node_update_initiated_by" VARCHAR,
"node_update_initiated_date" TIMESTAMP_S,
"node_update_status_modified_date" TIMESTAMP_S
)[]
)[]
Show child fields
node_group_update_status[]
Show child fields
node_group_update_status[].node_group_id

The ID of the node group

node_group_update_status[].node_group_member_update_status[]
Show child fields
node_group_update_status[].node_group_member_update_status[].cache_cluster_id

The cache cluster ID

node_group_update_status[].node_group_member_update_status[].cache_node_id

The node ID of the cache cluster

node_group_update_status[].node_group_member_update_status[].node_deletion_date

The deletion date of the node

node_group_update_status[].node_group_member_update_status[].node_update_end_date

The end date of the update for a node

node_group_update_status[].node_group_member_update_status[].node_update_initiated_by

Reflects whether the update was initiated by the customer or automatically applied

node_group_update_status[].node_group_member_update_status[].node_update_initiated_date

The date when the update is triggered

node_group_update_status[].node_group_member_update_status[].node_update_start_date

The start date of the update for a node

node_group_update_status[].node_group_member_update_status[].node_update_status

The update status of the node

node_group_update_status[].node_group_member_update_status[].node_update_status_modified_date

The date when the NodeUpdateStatus was last modified

nodes_updated

The progress of the service update on the replication group

VARCHAR
replication_group_id

The ID of the replication group

VARCHAR
service_update_recommended_apply_by_date

The recommended date to apply the service update to ensure compliance. For information on compliance, see Self-Service Security Updates for Compliance.

TIMESTAMP_S
service_update_release_date

The date the update is first available

TIMESTAMP_S
service_update_severity

The severity of the service update

VARCHAR
service_update_status

The status of the service update

VARCHAR
service_update_type

Reflects the nature of the service update

VARCHAR
sla_met

If yes, all nodes in the replication group have been updated by the recommended apply-by date. If no, at least one node in the replication group have not been updated by the recommended apply-by date. If N/A, the replication group was created after the recommended apply-by date.

VARCHAR
update_action_available_date

The date that the service update is available to a replication group

TIMESTAMP_S
update_action_status

The status of the update action

VARCHAR
update_action_status_modified_date

The date when the UpdateActionStatus was last modified

TIMESTAMP_S