SQL can be parametrized using the data columns from the flow of data. A column value can be passed to a SQL query by surrounding it with curly brackets and prefixing it with the dollar sign, for example, my_data_column to ${my_data_column}. In the following picture, the src_full_name value is being used as a parameter for a query to select from a table.

Not all steps support parametrization. The I/O step JDBC Reader does not support parametrization and dynamic evaluation of the SQL queries. Advanced steps SQL Select or SQL Execute do support it as they execute the query for each record in the flow.

Tip: For more information, click the Help button (question mark icon) in the lower-left corner. The help system provides comprehensive information related to the queries and the SQL Steps, including the nuances of usage.