I am using a variable in the join condition of the target update component in the matillion transformation job. But it does not get resolved during execution and hence the job fails during runtime

Matillion ETL
1

I am using a variable in the join condition of the target update component in the matillion transformation job. But it does not get resolved during execution and hence the job fails during runtime. The value of the variable is being set in the orchestration job.

This is how it is entered in the join condition : ${variable_name}

Is there a different way of doing it?

2

HI @py471040

Does this job run successfully if you run it in isolation? If so, what is the default variable value you are using in the job?