Skip to content

aws.sagemaker.describe_pipeline_execution

Example SQL Queries

SELECT * FROM
aws.sagemaker.describe_pipeline_execution
WHERE
"pipeline_execution_arn" = 'VALUE';

Description

Describes the details of a pipeline execution.

Table Definition

Column NameColumn Data Type
pipeline_execution_arn Required Input Column

The Amazon Resource Name (ARN) of the pipeline execution.

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

Information about the user who created or modified an experiment, trial, trial component, lineage group, project, or model card.

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

The time when the pipeline execution was created.

TIMESTAMP_S
failure_reason

If the execution failed, a message describing why.

VARCHAR
last_modified_by

Information about the user who created or modified an experiment, trial, trial component, lineage group, project, or model card.

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

The time when the pipeline execution was modified last.

TIMESTAMP_S
parallelism_configuration

The parallelism configuration applied to the pipeline.

STRUCT(
"max_parallel_execution_steps" BIGINT
)
Show child fields
parallelism_configuration.max_parallel_execution_steps

The max number of steps that can be executed in parallel.

pipeline_arn

The Amazon Resource Name (ARN) of the pipeline.

VARCHAR
pipeline_execution_description

The description of the pipeline execution.

VARCHAR
pipeline_execution_display_name

The display name of the pipeline execution.

VARCHAR
pipeline_execution_status

The status of the pipeline execution.

VARCHAR
pipeline_experiment_config

Specifies the names of the experiment and trial created by a pipeline.

STRUCT(
"experiment_name" VARCHAR,
"trial_name" VARCHAR
)
Show child fields
pipeline_experiment_config.experiment_name

The name of the experiment.

pipeline_experiment_config.trial_name

The name of the trial.

selective_execution_config

The selective execution configuration applied to the pipeline run.

STRUCT(
"source_pipeline_execution_arn" VARCHAR,
"selected_steps" STRUCT(
"step_name" VARCHAR
)[]
)
Show child fields
selective_execution_config.selected_steps[]
Show child fields
selective_execution_config.selected_steps[].step_name

The name of the pipeline step.

selective_execution_config.source_pipeline_execution_arn

The ARN from a reference execution of the current pipeline. Used to copy input collaterals needed for the selected steps to run. The execution status of the pipeline can be either Failed or Success.

This field is required if the steps you specify for SelectedSteps depend on output collaterals from any non-specified pipeline steps. For more information, see Selective Execution for Pipeline Steps.