SQL Dynamic query not working

WeirdMan 220 Reputation points
2024-06-01T17:24:19.4033333+00:00

How can I replace a question mark "?" in a SQL dynamic query with pipeline parameters in Azure Data Factory? When I attempt to pass the parameters, ADF does not recognize the "?" symbol, and the parameters are not correctly passed.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,925 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 18,026 Reputation points
    2024-06-01T17:26:47.5266667+00:00

    To build a dynamic query, you can either use the concat function to concatenate the query with your parameters, or you can use string interpolation (@{...}). Both methods allow you to construct a query dynamically with parameters having the desired values.

    Check this old thread :

    https://stackoverflow.com/questions/75590526/sql-dynamic-query-in-adf

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful