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