SQL Scripts - variable for inputs / outputs

stainlessteelra

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

HarizoR

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:

Hope this helps!

Best,

Harizo