how to call the global variable in SQL recipe in dataiku?
psvnm
Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 7 ✭✭✭✭
I have tried the code available in Dataiku notes as "SELECT count FROM logs WHERE count == '${FINAL}'; But I am getting error as "
Job failed: SQL compilation error: Object 'LOGS' does not exist or not authorized."
Answers
-
Hi,
'${FINAL}' is the correct way to call a global variable in a SQL recipe.
Your error seems to come from something else.
Do you have access to the "logs" table and is it an input of your recipe ?
What message do you get when you click on Validate in the SQL recipe editor ?