Pre-creation
Overview
Pre-creation is a SQL script type that runs before warehouse object creation or synchronization work.
Function
Use this type when SQL must prepare the environment before objects are created. Selecting it executes before creation processing.
When to use
Choose Pre-creation when SQL must prepare the environment before objects are created.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Assign the Pre-creation type, sequence number, statement, and active status. |
| Processing | AnalyticsCreator runs active scripts in sequence before the relevant creation phase. |
| Output | The script can prepare schemas, settings, or prerequisites. |
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
Failures can interrupt or affect creation. The script must be valid for the repository or target context.
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. |
