Skip to main content
Variables components read, write, and inspect pipeline variables while an orchestration pipeline runs. They let you pass values between components, populate variables from query results or warehouse metadata, and check that a variable holds the value you expect.

​
Use cases

Variables components are especially useful for building dynamic pipelines that adapt their behavior based on data—for example, feeding an iterator from a query result, or branching logic based on a value calculated earlier in the pipeline. Use variables components to:
  • Store the result of a query as a scalar variable or a grid, for use later in the pipeline.
  • Add to or remove rows from a grid variable as the pipeline runs.
  • Retrieve metadata about a table or column and load it into a variable.
  • Print the current value of one or more variables, for example while debugging a pipeline.
  • Update a scalar variable to a new value based on pipeline logic.
  • Check that a variable holds an expected value before continuing.