Jsonb Data Integration


I am trying to load a table data from a AWS RDS instance to another AWS RDS instance.

For e.g.
Instance 1 : Table A (ID Int , Column1 jsonb , column2 Varchar)
Instance 2 : Table A (ID Int , Column1 jsonb , column2 Varchar)

created a pipeline using Genric JDBC Select → Mapper → Genric JDBC Insert


But, the pipeline fails with below exception

ERROR: column “Column1” is of type jsonb but expression is of type character varying Hint: You will need to rewrite or cast the expression.

Tried using JSON.stringify($Column1) but is of no use. I still get the same exception. Can i have some pointers here?
If it is through command line then it works fine with a simple cast function.

Pipeline works fine if i remove Jsonb column mapping.