I am trying to load a table data from a AWS RDS instance to another AWS RDS instance.
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.