steampipe plugin install awssteampipe plugin install aws

Table: aws_dms_replication_instance

AWS Database Migration Service (DMS) replication instance is used to connect to your source data store, read the source data, and format the data for consumption by the target data store along with loading the data into the target data store.

Examples

Basic info

select
  replication_instance_identifier,
  arn,
  engine_version,
  instance_create_time,
  kms_key_id,
  publicly_accessible,
  region
from
  aws_dms_replication_instance;

List replication instances with auto minor version upgrades disabled

select
  replication_instance_identifier,
  arn,
  engine_version,
  instance_create_time,
  auto_minor_version_upgrade,
  region
from
  aws_dms_replication_instance
where
  not auto_minor_version_upgrade;

List replication instances provisioned with undesired (for example, dms.r5.16xlarge and dms.r5.24xlarge are not desired) instance classes

select
  replication_instance_identifier,
  arn,
  engine_version,
  instance_create_time,
  replication_instance_class,
  region
from
  aws_dms_replication_instance
where
  replication_instance_class not in ('dms.r5.16xlarge', 'dms.r5.24xlarge');

List publicly accessible replication instances

select
  replication_instance_identifier,
  arn,
  publicly_accessible,
  region
from
  aws_dms_replication_instance
where
  publicly_accessible;

List replication instances not using multi-AZ deployment configurations

select
  replication_instance_identifier,
  arn,
  publicly_accessible,
  multi_az,
  region
from
  aws_dms_replication_instance
where
  not multi_az;

Query examples

Control examples

.inspect aws_dms_replication_instance

AWS DMS Replication Instance

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.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
allocated_storage	bigint	The amount of storage (in gigabytes) that is allocated for the replication instance.
arn	text	The Amazon Resource Name (ARN) of the replication instance.
auto_minor_version_upgrade	boolean	Boolean value indicating if minor version upgrades will be automatically applied to the instance.
availability_zone	text	The Availability Zone for the instance.
dns_name_servers	text	The DNS name servers supported for the replication instance to access your on-premise source or target database.
engine_version	text	The engine version number of the replication instance.
free_until	timestamp with time zone	The expiration date of the free replication instance that is part of the Free DMS program.
instance_create_time	timestamp with time zone	The time the replication instance was created.
kms_key_id	text	An AWS KMS key identifier that is used to encrypt the data on the replication instance.
multi_az	boolean	Specifies whether the replication instance is a Multi-AZ deployment.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
pending_modified_values	jsonb	The pending modification values.
preferred_maintenance_window	text	The maintenance window times for the replication instance.
publicly_accessible	boolean	Specifies the accessibility options for the replication instance.
region	text	The AWS Region in which the resource is located.
replication_instance_class	text	The compute and memory capacity of the replication instance as defined for the specified replication instance class.
replication_instance_identifier	text	The identifier of the replication instance.
replication_instance_private_ip_address	text	The private IP address of the replication instance.
replication_instance_private_ip_addresses	jsonb	One or more private IP addresses for the replication instance.
replication_instance_public_ip_address	text	The public IP address of the replication instance.
replication_instance_public_ip_addresses	jsonb	One or more public IP addresses for the replication instance.
replication_instance_status	text	The status of the replication instance.
replication_subnet_group	jsonb	The subnet group for the replication instance.
secondary_availability_zone	text	The Availability Zone of the standby replication instance in a Multi-AZ deployment.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags currently associated with the replication instance.
title	text	Title of the resource.
vpc_security_groups	jsonb	The VPC security group for the instance.

turbot/aws