Azure Data Factory Dynamic Content

Tahmid Eshayat 286 Reputation points
2020-06-27T10:33:26.767+00:00

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.

10767-screenshot-1.jpg

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

Help would be really appreciated.

Thanks.

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

Accepted answer
  1. Jaryd 181 Reputation points
    2020-06-27T12:58:06.167+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Jaryd 181 Reputation points
    2020-06-27T13:57:59.423+00:00

    10795-annotation-2020-06-27-095537.png

    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