Support Knowledge Base
Login Registration
Contents

Parameterizing SQL Queries

Reported for version 10

SQL can be parametrized using the data columns from the flow of data. A column value can be passed to an SQL query by surrounding it with curly brackets and prefixing it with the dollar sign, e.g. 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.

For more information, press the Help button (with a question mark) on the bottom left corner. The built-in help has rich information related to the queries and SQL steps.