Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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