Job fail when run a postgresql code recipe

Solved!
UserBird
Dataiker
Job fail when run a postgresql code recipe
Hi, after I validate my syntax and click run, I got this error:

Job failed : Cannot run program "psql" (in directory "/Users/Library/DataScienceStudio/dss_home"): error=2, No such file or directory, caused by: IOException: error=2, No such file or directory

I'm using Postgres app 9.6.2 and I've set the path already. I tried to copy the psql inside Postgres app's package to /Users/Library/DataScienceStudio/dss_home/ but I still got the same error

Thanks,
1 Solution
Clรฉment_Stenac
By default, for "SQL Script" recipes (as opposed to SQL Query), DSS uses the "psql" command line tool of PostgreSQL, which gives better logging abilities. You can disable this in Advanced settings (uncheck "Use psql").

DSS will not look for psql in the dss_home folder, only in the PATH used when starting DSS (which is not the PATH configured in your shell configuration files).

Also note that depending on what you want to do, the SQL query recipe might satisfy your needs (https://doc.dataiku.com/dss/latest/code_recipes/sql.html)

View solution in original post

0 Kudos
1 Reply
Clรฉment_Stenac
By default, for "SQL Script" recipes (as opposed to SQL Query), DSS uses the "psql" command line tool of PostgreSQL, which gives better logging abilities. You can disable this in Advanced settings (uncheck "Use psql").

DSS will not look for psql in the dss_home folder, only in the PATH used when starting DSS (which is not the PATH configured in your shell configuration files).

Also note that depending on what you want to do, the SQL query recipe might satisfy your needs (https://doc.dataiku.com/dss/latest/code_recipes/sql.html)
0 Kudos

Labels

?
Labels (1)
A banner prompting to get Dataiku