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