Skip to content

aws.rds.describe_blue_green_deployments

Example SQL Queries

SELECT * FROM
aws.rds.describe_blue_green_deployments;

Description

Describes one or more blue/green deployments.

For more information, see Using Amazon RDS Blue/Green Deployments for database updates in the Amazon RDS User Guide and Using Amazon RDS Blue/Green Deployments for database updates in the Amazon Aurora User Guide.

Table Definition

Column NameColumn Data Type
blue_green_deployment_identifier Input Column

The unique identifier of the blue/green deployment.

VARCHAR
filters Input Column

A filter that specifies one or more blue/green deployments to describe.

Valid Values:

  • blue-green-deployment-identifier - Accepts system-generated identifiers for blue/green deployments. The results list only includes information about the blue/green deployments with the specified identifiers.

  • blue-green-deployment-name - Accepts user-supplied names for blue/green deployments. The results list only includes information about the blue/green deployments with the specified names.

  • source - Accepts source databases for a blue/green deployment. The results list only includes information about the blue/green deployments with the specified source databases.

  • target - Accepts target databases for a blue/green deployment. The results list only includes information about the blue/green deployments with the specified target databases.

STRUCT(
"name" VARCHAR,
"values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

The name of the filter. Filter names are case-sensitive.

filters[].values[]
_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
blue_green_deployment_name

The user-supplied name of the blue/green deployment.

VARCHAR
create_time

The time when the blue/green deployment was created, in Universal Coordinated Time (UTC).

TIMESTAMP_S
delete_time

The time when the blue/green deployment was deleted, in Universal Coordinated Time (UTC).

TIMESTAMP_S
source

The source database for the blue/green deployment.

Before switchover, the source database is the production database in the blue environment.

VARCHAR
status

The status of the blue/green deployment.

Valid Values:

  • PROVISIONING - Resources are being created in the green environment.

  • AVAILABLE - Resources are available in the green environment.

  • SWITCHOVER_IN_PROGRESS - The deployment is being switched from the blue environment to the green environment.

  • SWITCHOVER_COMPLETED - Switchover from the blue environment to the green environment is complete.

  • INVALID_CONFIGURATION - Resources in the green environment are invalid, so switchover isn't possible.

  • SWITCHOVER_FAILED - Switchover was attempted but failed.

  • DELETING - The blue/green deployment is being deleted.

VARCHAR
status_details

Additional information about the status of the blue/green deployment.

VARCHAR
switchover_details

The details about each source and target resource in the blue/green deployment.

STRUCT(
"source_member" VARCHAR,
"target_member" VARCHAR,
"status" VARCHAR
)[]
Show child fields
switchover_details[]
Show child fields
switchover_details[].source_member

The Amazon Resource Name (ARN) of a resource in the blue environment.

switchover_details[].status

The switchover status of a resource in a blue/green deployment.

Values:

  • PROVISIONING - The resource is being prepared to switch over.

  • AVAILABLE - The resource is ready to switch over.

  • SWITCHOVER_IN_PROGRESS - The resource is being switched over.

  • SWITCHOVER_COMPLETED - The resource has been switched over.

  • SWITCHOVER_FAILED - The resource attempted to switch over but failed.

  • MISSING_SOURCE - The source resource has been deleted.

  • MISSING_TARGET - The target resource has been deleted.

switchover_details[].target_member

The Amazon Resource Name (ARN) of a resource in the green environment.

tag_list

A list of tags.

For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora User Guide.

STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
Show child fields
tag_list[]
Show child fields
tag_list[].key

A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").

tag_list[].value

A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").

target

The target database for the blue/green deployment.

Before switchover, the target database is the clone database in the green environment.

VARCHAR
tasks

Either tasks to be performed or tasks that have been completed on the target database before switchover.

STRUCT(
"name" VARCHAR,
"status" VARCHAR
)[]
Show child fields
tasks[]
Show child fields
tasks[].name

The name of the blue/green deployment task.

tasks[].status

The status of the blue/green deployment task.

Valid Values:

  • PENDING - The resource is being prepared for deployment.

  • IN_PROGRESS - The resource is being deployed.

  • COMPLETED - The resource has been deployed.

  • FAILED - Deployment of the resource failed.