Skip to main content

workflow_steps

Creates, updates, deletes, gets or lists a workflow_steps resource.

Overview

Nameworkflow_steps
TypeResource
Idaws.migrationhuborchestrator.workflow_steps

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe name of the step.
creation_timestring (date-time)The time at which the step was created.
descriptionstringThe description of the step.
end_timestring (date-time)The time at which the step ended.
last_start_timestring (date-time)The time at which the workflow was last started.
nextarrayThe next step.
no_of_srv_completedintegerThe number of servers that have been migrated.
no_of_srv_failedintegerThe number of servers that have failed to migrate.
outputsarrayThe outputs of the step.
ownerstringThe owner of the step. (AWS_MANAGED, CUSTOM)
previousarrayThe previous step.
script_output_locationstringThe output location of the script.
statusstringThe status of the step. (AWAITING_DEPENDENCIES, SKIPPED, READY, IN_PROGRESS, COMPLETED, FAILED, PAUSED, USER_ATTENTION_REQUIRED)
status_messagestringThe status message of the migration workflow.
step_action_typestringThe action type of the step. You must run and update the status of a manual step for the workflow to continue after the completion of the step. (MANUAL, AUTOMATED)
step_group_idstringThe ID of the step group.
step_idstringThe ID of the step.
step_targetarrayThe servers on which a step will be run.
total_no_of_srvintegerThe total number of servers that have been migrated.
workflow_idstringThe ID of the migration workflow.
workflow_step_automation_configurationobjectThe custom script to run tests on source or target environments.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_workflow_stepselectworkflowId, stepGroupId, id, regionGet a step in the migration workflow.
list_workflow_stepsselectworkflow_id, step_group_id, regionnextToken, maxResultsList the steps in a workflow.
create_workflow_stepinsertregion, name, stepGroupId, workflowId, stepActionTypeCreate a step in the migration workflow.
update_workflow_stepupdateid, region, stepGroupId, workflowIdUpdate a step in a migration workflow.
delete_workflow_stepdeleteid, stepGroupId, workflowId, regionDelete a step in a migration workflow. Pause the workflow to delete a running step.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
idstringThe ID of the step you want to delete.
regionstringAWS region (default: us-east-1)
stepGroupIdstringThe ID of the step group that contains the step you want to delete.
step_group_idstringThe ID of the step group.
workflowIdstringThe ID of the migration workflow.
workflow_idstringThe ID of the migration workflow.
maxResultsintegerThe maximum number of results that can be returned.
nextTokenstringThe pagination token.

SELECT examples

Get a step in the migration workflow.

SELECT
name,
creation_time,
description,
end_time,
last_start_time,
next,
no_of_srv_completed,
no_of_srv_failed,
outputs,
owner,
previous,
script_output_location,
status,
status_message,
step_action_type,
step_group_id,
step_id,
step_target,
total_no_of_srv,
workflow_id,
workflow_step_automation_configuration
FROM aws.migrationhuborchestrator.workflow_steps
WHERE workflowId = '{{ workflowId }}' -- required
AND stepGroupId = '{{ stepGroupId }}' -- required
AND id = '{{ id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Create a step in the migration workflow.

INSERT INTO aws.migrationhuborchestrator.workflow_steps (
name,
stepGroupId,
workflowId,
stepActionType,
description,
workflowStepAutomationConfiguration,
stepTarget,
outputs,
previous,
next,
region
)
SELECT
'{{ name }}' /* required */,
'{{ stepGroupId }}' /* required */,
'{{ workflowId }}' /* required */,
'{{ stepActionType }}' /* required */,
'{{ description }}',
'{{ workflowStepAutomationConfiguration }}',
'{{ stepTarget }}',
'{{ outputs }}',
'{{ previous }}',
'{{ next }}',
'{{ region }}'
RETURNING
id,
name,
step_group_id,
workflow_id
;

UPDATE examples

Update a step in a migration workflow.

UPDATE aws.migrationhuborchestrator.workflow_steps
SET
stepGroupId = '{{ stepGroupId }}',
workflowId = '{{ workflowId }}',
name = '{{ name }}',
description = '{{ description }}',
stepActionType = '{{ stepActionType }}',
workflowStepAutomationConfiguration = '{{ workflowStepAutomationConfiguration }}',
stepTarget = '{{ stepTarget }}',
outputs = '{{ outputs }}',
previous = '{{ previous }}',
next = '{{ next }}',
status = '{{ status }}'
WHERE
id = '{{ id }}' --required
AND region = '{{ region }}' --required
AND stepGroupId = '{{ stepGroupId }}' --required
AND workflowId = '{{ workflowId }}' --required
RETURNING
id,
name,
step_group_id,
workflow_id;

DELETE examples

Delete a step in a migration workflow. Pause the workflow to delete a running step.

DELETE FROM aws.migrationhuborchestrator.workflow_steps
WHERE id = '{{ id }}' --required
AND stepGroupId = '{{ stepGroupId }}' --required
AND workflowId = '{{ workflowId }}' --required
AND region = '{{ region }}' --required
;