Skip to content

aws.sagemaker.list_trial_components

Example SQL Queries

SELECT * FROM
aws.sagemaker.list_trial_components;

Description

Lists the trial components in your account. You can sort the list by trial component name or creation time. You can filter the list to show only components that were created in a specific time range. You can also filter on one of the following:

  • ExperimentName

  • SourceArn

  • TrialName

Table Definition

Column NameColumn Data Type
created_after Input Column

A filter that returns only components created after the specified time.

TIMESTAMP_S
created_before Input Column

A filter that returns only components created before the specified time.

TIMESTAMP_S
experiment_name Input Column

A filter that returns only components that are part of the specified experiment. If you specify ExperimentName, you can't filter by SourceArn or TrialName.

VARCHAR
sort_by Input Column

The property used to sort results. The default value is CreationTime.

VARCHAR
sort_order Input Column

The sort order. The default value is Descending.

VARCHAR
source_arn Input Column

A filter that returns only components that have the specified source Amazon Resource Name (ARN). If you specify SourceArn, you can't filter by ExperimentName or TrialName.

VARCHAR
trial_name Input Column

A filter that returns only components that are part of the specified trial. If you specify TrialName, you can't filter by ExperimentName or SourceArn.

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.

created_by

Who created the trial component.

STRUCT(
"user_profile_arn" VARCHAR,
"user_profile_name" VARCHAR,
"domain_id" VARCHAR,
"iam_identity" STRUCT(
"arn" VARCHAR,
"principal_id" VARCHAR,
"source_identity" VARCHAR
)
)
Show child fields
created_by.domain_id

The domain associated with the user.

created_by.iam_identity

The IAM Identity details associated with the user. These details are associated with model package groups, model packages, and project entities only.

Show child fields
created_by.iam_identity.arn

The Amazon Resource Name (ARN) of the IAM identity.

created_by.iam_identity.principal_id

The ID of the principal that assumes the IAM identity.

created_by.iam_identity.source_identity

The person or application which assumes the IAM identity.

created_by.user_profile_arn

The Amazon Resource Name (ARN) of the user's profile.

created_by.user_profile_name

The name of the user's profile.

creation_time

When the component was created.

TIMESTAMP_S
display_name

The name of the component as displayed. If DisplayName isn't specified, TrialComponentName is displayed.

VARCHAR
end_time

When the component ended.

TIMESTAMP_S
last_modified_by

Who last modified the component.

STRUCT(
"user_profile_arn" VARCHAR,
"user_profile_name" VARCHAR,
"domain_id" VARCHAR,
"iam_identity" STRUCT(
"arn" VARCHAR,
"principal_id" VARCHAR,
"source_identity" VARCHAR
)
)
Show child fields
last_modified_by.domain_id

The domain associated with the user.

last_modified_by.iam_identity

The IAM Identity details associated with the user. These details are associated with model package groups, model packages, and project entities only.

Show child fields
last_modified_by.iam_identity.arn

The Amazon Resource Name (ARN) of the IAM identity.

last_modified_by.iam_identity.principal_id

The ID of the principal that assumes the IAM identity.

last_modified_by.iam_identity.source_identity

The person or application which assumes the IAM identity.

last_modified_by.user_profile_arn

The Amazon Resource Name (ARN) of the user's profile.

last_modified_by.user_profile_name

The name of the user's profile.

last_modified_time

When the component was last modified.

TIMESTAMP_S
start_time

When the component started.

TIMESTAMP_S
status

The status of the component. States include:

  • InProgress

  • Completed

  • Failed

STRUCT(
"primary_status" VARCHAR,
"message" VARCHAR
)
Show child fields
status.message

If the component failed, a message describing why.

status.primary_status

The status of the trial component.

trial_component_arn

The Amazon Resource Name (ARN) of the trial component.

VARCHAR
trial_component_name

The name of the trial component.

VARCHAR
trial_component_source

The Amazon Resource Name (ARN) and job type of the source of a trial component.

STRUCT(
"source_arn" VARCHAR,
"source_type" VARCHAR
)
Show child fields
trial_component_source.source_arn

The source Amazon Resource Name (ARN).

trial_component_source.source_type

The source job type.