SQL Scripts - variable for inputs / outputs

Options
stainlessteelra
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 ✓
    Options

    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!

    Best,

    Harizo

Setup Info
    Tags
      Help me…