Skip to content

aws.backup.get_restore_testing_selection

Example SQL Queries

SELECT * FROM
aws.backup.get_restore_testing_selection
WHERE
"restore_testing_plan_name" = 'VALUE'
AND "restore_testing_selection_name" = 'VALUE';

Description

Returns RestoreTestingSelection, which displays resources and elements of the restore testing plan.

Table Definition

Column NameColumn Data Type
restore_testing_plan_name Required Input Column

Required unique name of the restore testing plan.

VARCHAR
restore_testing_selection_name Required Input Column

Required unique name of the restore testing selection.

VARCHAR
_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
restore_testing_selection

Unique name of the restore testing selection.

STRUCT(
"creation_time" TIMESTAMP_S,
"creator_request_id" VARCHAR,
"iam_role_arn" VARCHAR,
"protected_resource_arns" VARCHAR[],
"protected_resource_conditions" STRUCT(
"string_equals" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"string_not_equals" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
),
"protected_resource_type" VARCHAR,
"restore_metadata_overrides" MAP(VARCHAR, VARCHAR),
"restore_testing_plan_name" VARCHAR,
"restore_testing_selection_name" VARCHAR,
"validation_window_hours" BIGINT
)
Show child fields
restore_testing_selection.creation_time

The date and time that a restore testing selection was created, in Unix format and Coordinated Universal Time (UTC). The value of CreationTime is accurate to milliseconds. For example, the value 1516925490.087 represents Friday, January 26, 201812:11:30.087 AM.

restore_testing_selection.creator_request_id

This identifies the request and allows failed requests to be retried without the risk of running the operation twice. If the request includes a CreatorRequestId that matches an existing backup plan, that plan is returned. This parameter is optional.

If used, this parameter must contain 1 to 50 alphanumeric or '-_.' characters.

restore_testing_selection.iam_role_arn

The Amazon Resource Name (ARN) of the IAM role that Backup uses to create the target resource; for example:arn:aws:iam::123456789012:role/S3Access.

restore_testing_selection.protected_resource_arns[]
restore_testing_selection.protected_resource_conditions

In a resource testing selection, this parameter filters by specific conditions such as StringEquals or StringNotEquals.

Show child fields
restore_testing_selection.protected_resource_conditions.string_equals[]
Show child fields
restore_testing_selection.protected_resource_conditions.string_equals[].key

The tag key (String). The key can't start with aws:.

Length Constraints: Minimum length of 1. Maximum length of 128.

Pattern: ^(?![aA]{1}[wW]{1}[sS]{1}:)([\p{L}\p{Z}\p{N}_.:/=+\-@]+)$

restore_testing_selection.protected_resource_conditions.string_equals[].value

The value of the key.

Length Constraints: Maximum length of 256.

Pattern: ^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$

restore_testing_selection.protected_resource_conditions.string_not_equals[]
Show child fields
restore_testing_selection.protected_resource_conditions.string_not_equals[].key

The tag key (String). The key can't start with aws:.

Length Constraints: Minimum length of 1. Maximum length of 128.

Pattern: ^(?![aA]{1}[wW]{1}[sS]{1}:)([\p{L}\p{Z}\p{N}_.:/=+\-@]+)$

restore_testing_selection.protected_resource_conditions.string_not_equals[].value

The value of the key.

Length Constraints: Maximum length of 256.

Pattern: ^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$

restore_testing_selection.protected_resource_type

The type of Amazon Web Services resource included in a resource testing selection; for example, an Amazon EBS volume or an Amazon RDS database.

restore_testing_selection.restore_metadata_overrides

You can override certain restore metadata keys by including the parameter RestoreMetadataOverrides in the body of RestoreTestingSelection. Key values are not case sensitive.

See the complete list of restore testing inferred metadata.

restore_testing_selection.restore_testing_plan_name

The RestoreTestingPlanName is a unique string that is the name of the restore testing plan.

restore_testing_selection.restore_testing_selection_name

This is the unique name of the restore testing selection that belongs to the related restore testing plan.

restore_testing_selection.validation_window_hours

This is amount of hours (1 to 168) available to run a validation script on the data. The data will be deleted upon the completion of the validation script or the end of the specified retention period, whichever comes first.