how to call the global variable in SQL recipe in dataiku?

psvnm
Level 2
how to call the global variable in SQL recipe in dataiku?

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."

0 Kudos
1 Reply
StanG
Dataiker

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 ?

0 Kudos