Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on May 24, 2023 2:37PM
Likes: 0
Replies: 5
While using the time difference from prepare recipe I get this weird error. All values on preview seem right but when I run the recipe I get a const value.
Operating system used: Windows
Hi @imanousar
,
Can you confirm the engine you are running the recipe with? Do you get the expected results if you use the DSS engine?
Thanks,
I'm using SQL in Database since this our fastest engine in our case.
Which SQL database are you using exactly? Can you confirm if the DSS engine has the expected results? It would be best if you can raise support with the job diagnostics so we can look further into this.
DSS engine is ok. I'm using Snowflake.
The same happens with other stuff in prepare recipes like using formulas, dss engine gives the correct resutl. In SQL database engine shows in preview the correct result and the output is wrong.