Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

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?

Many Thanks.

1 Community Answers

Matillion Agent  

Laura Malins —

Hi Adam

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.

Thanks
Laura

Post Your Community Answer

To add an answer please login