Bug in prepare recipe with compute time difference

imanousar
Level 3
Bug in prepare recipe with compute time difference

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. 

 

 

Untitled.png


Operating system used: Windows

0 Kudos
5 Replies
AlexT
Dataiker

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,

0 Kudos
imanousar
Level 3
Author

I'm using SQL in Database since this our fastest engine in our case.

0 Kudos
AlexT
Dataiker

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. 

0 Kudos
imanousar
Level 3
Author

DSS engine is ok. I'm using Snowflake.

0 Kudos
imanousar
Level 3
Author

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.

0 Kudos