I have an Orchestration job running in which I am using an iterator component. I have created a job variable which is reading filename for the iterator. Is their any way to store the variable value (i.e. filename) in a Snowflake table?
Thank you.
I have an Orchestration job running in which I am using an iterator component. I have created a job variable which is reading filename for the iterator. Is their any way to store the variable value (i.e. filename) in a Snowflake table?
Thank you.
Start with a fixed flow component in a transformation Job. Add a column of type varchar and name the variable: Var1_Value
Add a value to the fixed flow: ${VAR1} (if your job variable is named 'VAR1') Then output the fixed flow to a rewrite table component.
since you are using an orchestration job, you can pass the variable into the transformation job to write it out.
That will store the value of the variable into a Snowflake table.