I have a need to build a system that fetches data from an Amazon pgdb3 and provide a constant that is used later in the transformation, which is "S_ID" here.
This is my transformation and it is giving me errors if I try to use the variable as ${S_ID} in the "Add constants" step as shown.
What do I need to do in order to make the transformation succeed?