Skip to content
AWS for Query.Farm

aws.bedrock.list_model_copy_jobs

Example SQL Queries

SELECT * FROM
aws.bedrock.list_model_copy_jobs;

Description

Returns a list of model copy jobs that you have submitted. You can filter the jobs to return based on one or more criteria. For more information, see Copy models to be used in other regions in the Amazon Bedrock User Guide.

Table Definition

Column NameColumn Data Type
creation_time_after Input Column

Filters for model copy jobs created after the specified time.

TIMESTAMP_S
creation_time_before Input Column

Filters for model copy jobs created before the specified time. 

TIMESTAMP_S
sort_by Input Column

The field to sort by in the returned list of model copy jobs.

VARCHAR
sort_order Input Column

Specifies whether to sort the results in ascending or descending order.

VARCHAR
source_account_equals Input Column

Filters for model copy jobs in which the account that the source model belongs to is equal to the value that you specify.

VARCHAR
source_model_arn_equals Input Column

Filters for model copy jobs in which the Amazon Resource Name (ARN) of the source model to is equal to the value that you specify.

VARCHAR
status_equals Input Column

Filters for model copy jobs whose status matches the value that you specify.

VARCHAR
target_model_name_contains Input Column

Filters for model copy jobs in which the name of the copied model contains the string that you specify.

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
creation_time

The time that the model copy job was created.

TIMESTAMP_S
failure_message

If a model fails to be copied, a message describing why the job failed is included here.

VARCHAR
job_arn

The Amazon Resoource Name (ARN) of the model copy job.

VARCHAR
source_account_id

The unique identifier of the account that the model being copied originated from.

VARCHAR
source_model_arn

The Amazon Resource Name (ARN) of the original model being copied.

VARCHAR
source_model_name

The name of the original model being copied.

VARCHAR
status

The status of the model copy job.

VARCHAR
target_model_arn

The Amazon Resource Name (ARN) of the copied model.

VARCHAR
target_model_kms_key_arn

The Amazon Resource Name (ARN) of the KMS key used to encrypt the copied model.

VARCHAR
target_model_name

The name of the copied model.

VARCHAR
target_model_tags

Tags associated with the copied model.

STRUCT(
    "key" VARCHAR,
    "value" VARCHAR
)[]
Show child fields
target_model_tags[]
Show child fields
target_model_tags[].key

Key for the tag.

target_model_tags[].value

Value for the tag.