Pre-workflow
Overview
Pre-workflow is a SQL script type that runs before workflow package execution.
Function
Use this type when SQL must prepare data or state before a workflow starts. Selecting it executes before workflow processing.
When to use
Choose Pre-workflow when SQL must prepare data or state before a workflow starts.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Assign the Pre-workflow type, sequence number, statement, and active status. |
| Processing | AnalyticsCreator runs active pre-workflow scripts before workflow packages. |
| Output | The script can initialize workflow prerequisites. |
Type-specific properties
| Property | Description |
|---|---|
| Sequence number | Execution order among pre-workflow scripts. |
| Statement | SQL executed before the workflow. |
| Inactive | Controls whether the script is skipped. |
| Description | Purpose and expected workflow effect. |
Compatibility and limitations
The script should not leave the workflow in an inconsistent state when it fails.
Relationships
| Related entity | Relationship |
|---|---|
| SQL Script | The script type defines the execution stage for the script. |
| Workflow | Pre- and post-workflow scripts run around workflow processing. |
| Deployment | Pre- and post-deployment scripts run around deployment processing. |
