Skip to main content
The Execute SQL workflow component runs a SQL statement as a step in your workflow. Use it to perform database operations between package executions.

​
Overview

  • Runs a single SQL statement against a database connection
  • Commonly used for pre/post-processing: truncating staging tables, updating flags, running stored procedures
  • Does not return data — it executes the statement and reports success or failure

​
Configuration

1
Select a database connection.
2
Enter the SQL statement to execute.
3
Optionally use variables in the SQL statement with the ${variable_name} syntax.

​
Use Cases

  • Truncate a staging table before loading data
  • Run a stored procedure after a dataflow completes
  • Update a status flag to mark a batch as processed
  • Create or drop temporary tables between pipeline steps
Last modified on April 15, 2026