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

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

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

Tagged:
· Share on Facebook

Best Answer

Answers

  • Mattsco
    Mattsco Dataiker, Registered Posts: 125 Dataiker

    Hi Rajesh,
    In the formula processor, you can write the SQL translation to be used when you use the SQL engine.
    So you can check in redshift what is the function to get the date of today and write it here.

    Mattsco_0-1589275047101.png

    · Share on Facebook
  • rsingamsetty
    rsingamsetty Dataiku DSS Core Designer, Dataiku DSS & SQL, Registered Posts: 18 ✭✭✭✭✭

    Hi Mattsco

    Im not able to see SQL Extression option in formula and I'm using DSS 5.*

    is your answer valid for this version as well ?

    Thanks

    Rajesh

    · Share on Facebook
  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭

    As a resource, here is a link to Upgrading a DSS instance

    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…