Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

SQL Scripts - variable for inputs / outputs

Solved!
stainlessteelra
Level 2
SQL Scripts - variable for inputs / outputs

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

0 Kudos
1 Solution
HarizoR
Developer Advocate
Developer Advocate

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

View solution in original post

0 Kudos
1 Reply
HarizoR
Developer Advocate
Developer Advocate

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

0 Kudos