Hi again, can anyone give some hints how exactly the data-type binding works between different connectors ? for example the source stream i use is Oracle by default some columns have datatypes of VARCHAR and INTEGER. And The destination is Postgres by default the datatype for majority of columns by AirByte are TEXT and FLOAT. Can we actually change this to VARCHAR (255) and Int8 etc ??.
I tried changing it via Octavia-CLI in the stream information, (TEXT -> VARCHAR) but it overwrites to jsonb object.