Use a list as variable in SQL Query

Sv3n-Sk4
Sv3n-Sk4 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 32 ✭✭✭✭

Hello everyone,

I need your help in using a list as project variable in a SQL query.

I have a dataset with a list on numbers, with a custom python recipe, I stored the numbers as list in my variable project. It's looking like this :

{
"liste": [
12265378,
9122915,
12292085,
12514810001,
12241211,
12262172,
4624440]

}

I now would like to use this list in my SQL recipe in my where condition as :

SELECT *

FROM TABLE

WHERE NUMBERS IN ('${liste}')

But it seems Dataiku is reading it as a long string.

If anyone could help please (it will help me a lot for this project and a lot of others).

Thanks!


Operating system used: Windows

Tagged:

Answers

Setup Info
    Tags
      Help me…