now() formula in prepare recipe not translatable on SQL engine

Options
rsingamsetty
rsingamsetty Dataiku DSS Core Designer, Dataiku DSS & SQL, Registered Posts: 18 ✭✭✭✭✭

Hi

I am using Redshift dataset in my flow and when I use prepare recipe and add another column for current_date

using now() formula function and select SQL engine as my RUN option, Its says formula not translatable hence

not allowing me to use the underlying SQL engine. Any workaround this would be highly appreciated !

Thanks

Rajesh

Best Answer

Answers

Setup Info
    Tags
      Help me…