Pass value from Transformation to Orchestration Component
I would like a transformation component to return some manner of value to its parent orchestration component. To my understanding, transformation jobs cannot affect variable values (unless I'm mistaken); are there any other accepted practices for returning values apart from writing them to the database or to an S3 component?
1 Community Answers
Laura Malins —
Currently in Matillion with a Transformation Job the only way to return a value is to write data to the database and read this in in the parent Orchestration job.
I usually write what I need to a table using the Rewrite component in the Transformation. Then in the Orchestration I read that in a python component, update my variable. Then I delete the table created in the Transformation.