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

psvnm
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

  • StanG
    StanG Dataiker, Registered Posts: 52 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 ?

Setup Info
    Tags
      Help me…