CODEWITHSUNDEEP
azure-data-factory
Sandeep T
Sandeep T

Reputation: 441

azure data factory lookup activity - parameterize sql query

How do I parameterize the where condition in a lookup activity query in azure data factory? I have created a pipeline parameter and tried to pass it to the lookup activity query as given below.

select max(dt) as dt from tab1 where col='@pipeline.parameters.parama1'

I have tried with quotes, without quotes, curly brackets, but still not firing. Any help would be appreciated.

Regards, Sandeep

Upvotes: 6

Views: 11434

Answers (1)

Martin Esteban Zurita
Martin Esteban Zurita

Reputation: 3209

Official doc here: https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions

Expressions can also appear inside strings, using a feature called string interpolation where expressions are wrapped in @{ ... }.

Taking this into consideration, this may work for you:

select max(dt) as dt from tab1 where col=@{pipeline().parameters.param}

Hope this helped!

Upvotes: 8

Related Questions