steampipe plugin install aws

Table: aws_dms_replication_instance - Query AWS Database Migration Service Replication Instances using SQL

The AWS Database Migration Service Replication Instances are fully managed, serverless instances that enable the migration of data from one type of database to another. They facilitate homogeneous or heterogeneous migrations and can handle continuous data replication with high availability and consolidated auditing. This service significantly simplifies the process of migrating existing data to AWS in a secure and efficient manner.

Table Usage Guide

The aws_dms_replication_instance table in Steampipe provides you with information about each replication instance in an AWS Database Migration Service. This table allows you, as a database administrator, to query replication-specific details, including engine version, instance class, allocated storage, and associated metadata. You can utilize this table to gather insights on replication instances, such as their current state, multi-AZ mode, publicly accessible status, and more. The schema outlines the various attributes of the replication instance, including the replication instance ARN, replication instance identifier, availability zone, and associated tags for you.

Examples

Basic info

Explore which replication instances in your AWS Database Migration Service have public accessibility. This can help identify potential security risks and ensure that your data is properly protected.

select
replication_instance_identifier,
arn,
engine_version,
instance_create_time,
kms_key_id,
publicly_accessible,
region
from
aws_dms_replication_instance;
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

Determine the areas in which replication instances have automatic minor version upgrades turned off. This is useful for identifying potential security risks or outdated systems that may require manual updates.

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;
select
replication_instance_identifier,
arn,
engine_version,
instance_create_time,
auto_minor_version_upgrade,
region
from
aws_dms_replication_instance
where
auto_minor_version_upgrade = 0;

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

Determine the areas in which replication instances are provisioned with instance classes that are not preferred, such as dms.r5.16xlarge and dms.r5.24xlarge. This enables you to identify and rectify instances that may not meet your specific requirements or standards.

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');
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

Determine the areas in which replication instances are publicly accessible. This can help enhance security by identifying potential vulnerabilities in your system.

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

List replication instances not using multi-AZ deployment configurations

Identify instances where the replication process is not utilizing multi-AZ deployment configurations. This query is beneficial for pinpointing potential areas of vulnerability in your system, as it highlights where redundancies may not be in place to prevent data loss in the event of an AZ outage.

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

Schema for aws_dms_replication_instance

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allocated_storagebigintThe amount of storage (in gigabytes) that is allocated for the replication instance.
arntext=The Amazon Resource Name (ARN) of the replication instance.
auto_minor_version_upgradebooleanBoolean value indicating if minor version upgrades will be automatically applied to the instance.
availability_zonetextThe Availability Zone for the instance.
dns_name_serverstextThe DNS name servers supported for the replication instance to access your on-premise source or target database.
engine_versiontext=The engine version number of the replication instance.
free_untiltimestamp with time zoneThe expiration date of the free replication instance that is part of the Free DMS program.
instance_create_timetimestamp with time zoneThe time the replication instance was created.
kms_key_idtextAn AWS KMS key identifier that is used to encrypt the data on the replication instance.
multi_azbooleanSpecifies whether the replication instance is a Multi-AZ deployment.
network_typetextThe type of IP address protocol used by a replication instance, such as IPv4 only or Dual-stack that supports both IPv4 and IPv6 addressing.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
pending_modified_valuesjsonbThe pending modification values.
preferred_maintenance_windowtextThe maintenance window times for the replication instance.
publicly_accessiblebooleanSpecifies the accessibility options for the replication instance.
regiontextThe AWS Region in which the resource is located.
replication_instance_classtext=The compute and memory capacity of the replication instance as defined for the specified replication instance class.
replication_instance_identifiertext=The identifier of the replication instance.
replication_instance_ipv6_addressesjsonbOne or more IPv6 addresses for the replication instance.
replication_instance_private_ip_addresstextThe private IP address of the replication instance.
replication_instance_private_ip_addressesjsonbOne or more private IP addresses for the replication instance.
replication_instance_public_ip_addresstextThe public IP address of the replication instance.
replication_instance_public_ip_addressesjsonbOne or more public IP addresses for the replication instance.
replication_instance_statustextThe status of the replication instance.
replication_subnet_groupjsonbThe subnet group for the replication instance.
secondary_availability_zonetextThe Availability Zone of the standby replication instance in a Multi-AZ deployment.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags currently associated with the replication instance.
titletextTitle of the resource.
vpc_security_groupsjsonbThe VPC security group for the instance.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_dms_replication_instance