https://linen.dev logo
#help-api-cli-orchestration
Title
# help-api-cli-orchestration
z

zafar mahmood

09/29/2022, 8:52 AM
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)
a

Augustin Lafanechere (Airbyte)

09/29/2022, 9:02 AM
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.
z

zafar mahmood

09/29/2022, 9:27 AM
the objective is to do some memory optimisation instead of generic column datatypes
c

Chris Duong [Airbyte]

09/30/2022, 11:02 PM
You could do using custom transformation instead of normalization
3 Views