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

Solved!
rsingamsetty
Level 3
now() formula in prepare recipe not translatable on SQL engine

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

 

1 Solution
Mattsco
Dataiker
Dataiker

Hi, 

No, you should upgrade. 

Mattsco

View solution in original post

4 Replies
Mattsco
Dataiker
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

 

Mattsco
rsingamsetty
Level 3
Author

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

Mattsco
Dataiker
Dataiker

Hi, 

No, you should upgrade. 

Mattsco

View solution in original post

CoreyS
Community Manager
Community Manager

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

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
Labels (4)
A banner prompting to get Dataiku DSS
Public