I have a job where I am calling a previously set global variable called "PROCESS_DATE" in a tEltMap that inserts data into Snowflake.
Where I needed the date from the variable, I am calling it using globalMap.get("PROCESS_DATE") as shown in one of the screenshot. In the generated SQL, it gets written out as is and is not replaced by the variable value.
Also, the get method works in other places in the same job, however, it doesn't in tEltMap. When I went over to the Code tab, Talend is adding backslashes just before the double quotes, it makes sense from the Java perspective. So I tried adding one more backslash just before the double quote, but it didn't work either.
