Revision history [back]

The procedure for utilizing parameters in Kusto query on Expression builder within DataFlow activity is as follows:

1. Open the Azure Data Factory and navigate to the DataFlow activity.

2. Click on the "Expression" button next to the Kusto sink or source query textbox.

3. In the Expression builder, define the parameter by typing "@paramname" and specifying the datatype of the parameter.

4. Use the parameter in the Kusto query by replacing the corresponding value in the query with the parameter defined in the Expression builder. For example, use "@paramname" instead of a static value.

5. Save the query and test it by running the DataFlow activity.

6. Once validated and working, use the "Publish All" option to save the changes to the DataFlow activity in Azure.