SQL Scripts - variable for inputs / outputs

stainlessteelra Registered Posts: 4 ✭✭✭

Is there are way to point within a SQL query or script to the input(s) / output(s) setup in dataiku.

For example, would love to do something like:

Create table ${output[1]} as (

Select *

from ${input[1]}


Operating system used: Windows

Best Answer

  • HarizoR
    HarizoR Dataiker, Alpha Tester, Registered Posts: 138 Dataiker
    Answer ✓

    Hi William,

    In a regular SQL query recipe in DSS you don't have to worry about the CREATE TABLE statement, it's handled for you automatically. That being said, if at some point you need to retrieve the name of your input/output table(s), you can call them via the variables generated after validating the recipe. For example:

    Screenshot 2021-12-10 at 17.29.27.png

    Hope this helps!



Setup Info
      Help me…