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

Control examples

All Controls > DRS > DRS jobs should be enabled

Schema for aws_drs_job

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
arn	text		The ARN of a Job.
creation_date_time	timestamp with time zone	>, >=, <, <=, =	The date and time of when the Job was created.
end_date_time	timestamp with time zone	>, >=, <, <=, =	The date and time of when the Job ended.
initiated_by	text		A string representing who initiated the Job.
job_id	text	=	The ID of the job.
participating_resources	jsonb		A list of resources that the Job is acting upon.
participating_servers	jsonb		A list of servers that the Job is acting upon.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the Job.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The 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