Hi , 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. (edited)

Hi @zafar mahmood

Can we actually change this to VARCHAR (255) and Int8 etc ??.

You can't change the type binding. In Airbyte, the source database types are currently mapped to JSON schema types and then mapped again to the destination database type. It's not something you can change from the CLI. If you need more details about type bindings feel free to post on our forum.

the objective is to do some memory optimisation instead of generic column datatypes

You could do using custom transformation instead of normalization