Post-creation
Overview
Post-creation is a SQL script type that runs after warehouse object creation or synchronization work.
Function
Use this type when SQL must finalize or adjust objects after creation. Selecting it executes after creation processing.
When to use
Choose Post-creation when SQL must finalize or adjust objects after creation.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Assign the Post-creation type, sequence number, statement, and active status. |
| Processing | AnalyticsCreator runs active scripts in sequence after the relevant creation phase. |
| Output | The script can apply post-creation changes or cleanup. |
Type-specific properties
| Property | Description |
|---|---|
| Sequence number | Execution order among scripts of the same type. |
| Statement | SQL executed by the script. |
| Inactive | Controls whether the script is skipped. |
| Description | Purpose and expected effect of the script. |
Compatibility and limitations
The script must account for the final state of generated objects.
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. |