The Dataiku Frontrunner Awards are now accepting submissions until July 15 to recognize your achievements! ENTER YOUR SUBMISSION

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

psvnm
Level 1
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
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
A banner prompting to get Dataiku DSS
Public