Home› Reference› Entity types› SQL Script types

SQL Script types

SQL script types define when custom SQL scripts are executed in AnalyticsCreator and which phase of creation, workflow execution, deployment, or repository extension they belong to.

Use this section to understand the available SQL script types and choose the correct execution point for custom SQL logic.

Available SQL script types

Pre-creation

Used to execute SQL logic before object creation takes place.

  • Runs before creation steps
  • Useful for preparation logic
  • Supports setup before generated objects are created

Open reference

Post-creation

Used to execute SQL logic after object creation has completed.

  • Runs after creation steps
  • Useful for follow-up logic
  • Supports post-processing after generated objects exist

Open reference

Pre-workflow

Used to execute SQL logic before a workflow or execution package starts.

  • Runs before workflow execution
  • Useful for preparation or cleanup logic
  • Supports workflow-specific setup

Open reference

Post-workflow

Used to execute SQL logic after a workflow or execution package has finished.

  • Runs after workflow execution
  • Useful for validation or cleanup
  • Supports follow-up logic after processing

Open reference

Pre-deployment

Used to execute SQL logic before deployment starts.

  • Runs before deployment steps
  • Useful for environment preparation
  • Supports deployment-specific setup logic

Open reference

Post-deployment

Used to execute SQL logic after deployment has completed.

  • Runs after deployment steps
  • Useful for finalization logic
  • Supports post-deployment adjustments

Open reference

Repository extension

Used to extend or customize repository-related behavior with SQL logic.

  • Repository-focused customization
  • Supports metadata extension scenarios
  • Useful for repository-specific enhancements

Open reference

How to choose a SQL script type

  • Use Pre-creation or Post-creation when the script belongs to object creation timing
  • Use Pre-workflow or Post-workflow when the script belongs to execution timing
  • Use Pre-deployment or Post-deployment when the script belongs to deployment timing
  • Use Repository extension when the script is intended to extend repository behavior or metadata-related logic

Key takeaway

SQL script types define the lifecycle stage at which custom SQL logic is executed in AnalyticsCreator, from creation and workflow execution to deployment and repository extension.