Azure Data Factory Dynamic Content

Question

Hi there,

I want to use a variable inside my Data factory Copy activity.
I trying to use a variable which I got from an Azure Function.

When I run the debug for the variable I can see that I'm getting the value but I can't access it as a dynamic value for my CosmosDB query. Not sure where I'm doing wrong.

I have also removed the (" ") between my query, that is still giving me an error.

Help would be really appreciated.

Thanks.

Answer 1

I throw my SQL queries that use a variable inside a Concat() function.

The sql text will be inside single quotes.

The variable with no quotes.

You may need to do triple single quotes if you need the variable to resolve inside single quote.

I can throw up an imagine a littler later when I’m on my desktop.

Answer 2

Here is an example where I use a CONCAT function to run a SQL Query (it's an update query inside a lookup activity. then a select to meet the requirements of the of the lookup. I'm never using double quotes, so what you see in the image is triple quotes