Dynamic Query from 2 different data sources

[Abbi]

Hi All,

I have two different datasource SQL and Kusto 

SQL table has two columns ID and dependecy, I have to take up only Id's with the dependency as Client. 

I created a list using the ID's, as shown below 

Kusto table has a column called tags, Tags column contains these ID's along with some other data.

Now I have to pull all the rows, where the tags column contains any of these ID's .

How do I achieve it. Please help .

[Abbi · Accepted solution]

Hi All,

Got this figured out.

Declared the list in the query .

It worked fine