Hi all! I believe it is a very noob question, but how to add some "constant"/"fixed" value to some data from source to store it in a destination (i.g. from REST API to Postgres). I receive from REST:

[{"a":"1"},{"b":"2"}]

I persist:

{"a":"1", "super": "hot"}
{"b":"2", "super": "hot"}

or maybe Airbyte is not a good place to do this? Is there option to do it more beautiful than just hardcode it in

parse_response

?

If you can send this information from the API would be the best way. Airbyte is a ELT tool and the main goal is transfer the raw data as it is. If it's not possible adding the info in the

parse_reponse

function is the place.

Airbyte is a ELT tool and the main goal is transfer the raw data as it is

Yes, agree. I have realised this while I am writing my question)