Skip to content
AWS for Query.Farm

aws.backup.describe_copy_job

Example SQL Queries

SELECT * FROM
aws.backup.describe_copy_job
WHERE
"copy_job_id" = 'VALUE';

Description

Returns metadata associated with creating a copy of a resource.

Table Definition

Column NameColumn Data Type
copy_job_id Required Input Column

Uniquely identifies a copy job.

VARCHAR
_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
copy_job

Contains detailed information about a copy job.

STRUCT(
    "account_id" VARCHAR,
    "copy_job_id" VARCHAR,
    "source_backup_vault_arn" VARCHAR,
    "source_recovery_point_arn" VARCHAR,
    "destination_backup_vault_arn" VARCHAR,
    "destination_recovery_point_arn" VARCHAR,
    "resource_arn" VARCHAR,
    "creation_date" TIMESTAMP_S,
    "completion_date" TIMESTAMP_S,
    "state" VARCHAR,
    "status_message" VARCHAR,
    "backup_size_in_bytes" BIGINT,
    "iam_role_arn" VARCHAR,
    "created_by" STRUCT(
        "backup_plan_id" VARCHAR,
        "backup_plan_arn" VARCHAR,
        "backup_plan_version" VARCHAR,
        "backup_rule_id" VARCHAR
    ),
    "resource_type" VARCHAR,
    "parent_job_id" VARCHAR,
    "is_parent" BOOLEAN,
    "composite_member_identifier" VARCHAR,
    "number_of_child_jobs" BIGINT,
    "child_jobs_in_state" MAP(VARCHAR, BIGINT),
    "resource_name" VARCHAR,
    "message_category" VARCHAR
)
Show child fields
copy_job.account_id

The account ID that owns the copy job.

copy_job.backup_size_in_bytes

The size, in bytes, of a copy job.

copy_job.child_jobs_in_state

This returns the statistics of the included child (nested) copy jobs.

copy_job.completion_date

The date and time a copy job is completed, in Unix format and Coordinated Universal Time (UTC). The value of CompletionDate is accurate to milliseconds. For example, the value 1516925490.087 represents Friday, January 26, 2018 12:11:30.087 AM.

copy_job.composite_member_identifier

This is the identifier of a resource within a composite group, such as nested (child) recovery point belonging to a composite (parent) stack. The ID is transferred from the logical ID within a stack.

copy_job.copy_job_id

Uniquely identifies a copy job.

copy_job.created_by

Contains information about the backup plan and rule that Backup used to initiate the recovery point backup.

Show child fields
copy_job.created_by.backup_plan_arn

An Amazon Resource Name (ARN) that uniquely identifies a backup plan; for example, arn:aws:backup:us-east-1:123456789012:plan:8F81F553-3A74-4A3F-B93D-B3360DC80C50.

copy_job.created_by.backup_plan_id

Uniquely identifies a backup plan.

copy_job.created_by.backup_plan_version

Version IDs are unique, randomly generated, Unicode, UTF-8 encoded strings that are at most 1,024 bytes long. They cannot be edited.

copy_job.created_by.backup_rule_id

Uniquely identifies a rule used to schedule the backup of a selection of resources.

copy_job.creation_date

The date and time a copy job is created, in Unix format and Coordinated Universal Time (UTC). The value of CreationDate is accurate to milliseconds. For example, the value 1516925490.087 represents Friday, January 26, 2018 12:11:30.087 AM.

copy_job.destination_backup_vault_arn

An Amazon Resource Name (ARN) that uniquely identifies a destination copy vault; for example, arn:aws:backup:us-east-1:123456789012:vault:aBackupVault.

copy_job.destination_recovery_point_arn

An ARN that uniquely identifies a destination recovery point; for example, arn:aws:backup:us-east-1:123456789012:recovery-point:1EB3B5E7-9EB0-435A-A80B-108B488B0D45.

copy_job.iam_role_arn

Specifies the IAM role ARN used to copy the target recovery point; for example, arn:aws:iam::123456789012:role/S3Access.

copy_job.is_parent

This is a boolean value indicating this is a parent (composite) copy job.

copy_job.message_category

This parameter is the job count for the specified message category.

Example strings may include AccessDenied, SUCCESS, AGGREGATE_ALL, and InvalidParameters. See Monitoring for a list of MessageCategory strings.

The the value ANY returns count of all message categories.

AGGREGATE_ALL aggregates job counts for all message categories and returns the sum

copy_job.number_of_child_jobs

This is the number of child (nested) copy jobs.

copy_job.parent_job_id

This uniquely identifies a request to Backup to copy a resource. The return will be the parent (composite) job ID.

copy_job.resource_arn

The Amazon Web Services resource to be copied; for example, an Amazon Elastic Block Store (Amazon EBS) volume or an Amazon Relational Database Service (Amazon RDS) database.

copy_job.resource_name

This is the non-unique name of the resource that belongs to the specified backup.

copy_job.resource_type

The type of Amazon Web Services resource to be copied; for example, an Amazon Elastic Block Store (Amazon EBS) volume or an Amazon Relational Database Service (Amazon RDS) database.

copy_job.source_backup_vault_arn

An Amazon Resource Name (ARN) that uniquely identifies a source copy vault; for example, arn:aws:backup:us-east-1:123456789012:vault:aBackupVault.

copy_job.source_recovery_point_arn

An ARN that uniquely identifies a source recovery point; for example, arn:aws:backup:us-east-1:123456789012:recovery-point:1EB3B5E7-9EB0-435A-A80B-108B488B0D45.

copy_job.state

The current state of a copy job.

copy_job.status_message

A detailed message explaining the status of the job to copy a resource.