The procedure for utilizing parameters in Kusto query on Expression builder within DataFlow activity is as follows:
Open the Azure Data Factory and navigate to the DataFlow activity.
Click on the "Expression" button next to the Kusto sink or source query textbox.
In the Expression builder, define the parameter by typing "@paramname" and specifying the datatype of the parameter.
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.
Save the query and test it by running the DataFlow activity.
Once validated and working, use the "Publish All" option to save the changes to the DataFlow activity in Azure.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-04-04 11:00:00 +0000
Seen: 10 times
Last updated: Apr 04 '23
What is the regular expression to eliminate the characters \n and \t?
How can the issue of text size error be resolved in an After Effect expression?
What does the expression [rep(token, nrow(.)), ] signify in R?
How can I retrieve the headings for a table in IMPORTXML on Google Sheets?
What is the regular expression that will only allow decimal input?