steampipe plugin install aws

Table: aws_drs_job - Query AWS Data Replication Service Jobs using SQL

The AWS Data Replication Service (DRS) Jobs are part of AWS's migration tools that help you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS DRS Job is an entity that tracks the migration of data between the source and target instances.

Table Usage Guide

The aws_drs_job table in Steampipe provides you with information about jobs within AWS Data Replication Service (DRS). This table allows you, as a DevOps engineer, to query job-specific details, including job status, creation time, end time, and associated metadata. You can utilize this table to gather insights on jobs, such as job progress, replication status, verification of job parameters, and more. The schema outlines the various attributes of the DRS job for you, including the job ID, job type, creation time, end time, and associated tags.

Examples

Basic Info

Determine the status and origin of specific tasks within your AWS Data Recovery Service (DRS). This can help in monitoring ongoing jobs and identifying who initiated them, providing crucial insights for task management and accountability.

select
title,
arn,
status,
initiated_by
from
aws_drs_job;
select
title,
arn,
status,
initiated_by
from
aws_drs_job;

List jobs that are in pending state

Determine the areas in which tasks are still awaiting completion to better manage workload distribution and resource allocation.

select
title,
arn,
status,
initiated_by,
creation_date_time
from
aws_drs_job
where
status = 'PENDING';
select
title,
arn,
status,
initiated_by,
creation_date_time
from
aws_drs_job
where
status = 'PENDING';

List jobs that were started in past 30 days

Identify instances where jobs have been initiated in the past 30 days. This is useful for tracking recent activities and understanding the current workload.

select
title,
arn,
status,
initiated_by,
type,
creation_date_time,
end_date_time
from
aws_drs_job
where
creation_date_time >= now() - interval '30' day;
select
title,
arn,
status,
initiated_by,
type,
creation_date_time,
end_date_time
from
aws_drs_job
where
creation_date_time >= datetime('now', '-30 day');

Schema for aws_drs_job

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.
arntextThe ARN of a Job.
creation_date_timetimestamp with time zone>, >=, <, <=, =The date and time of when the Job was created.
end_date_timetimestamp with time zone>, >=, <, <=, =The date and time of when the Job ended.
initiated_bytextA string representing who initiated the Job.
job_idtext=The ID of the job.
participating_resourcesjsonbA list of resources that the Job is acting upon.
participating_serversjsonbA list of servers that the Job is acting upon.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe status of the Job.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the Job.

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_drs_job