CSV file to Postgres connection- Number formats saving as float data type

Connector Questions & Issues
,
1

Hi.
I am new to Airbyte and was testing CSV file loading data to Postgres database.

issue is i have number format columns automatically converting to float8 data type with decimals.

how to avoid this.

Thanks
Pavan

2

Hi @pavancharan25, thanks for your post.

The Postgres connector supports Basic Normalization which is responsible for the behavior you are seeing with the type conversions. Unfortunately, if you don’t want to enable this feature, you will have to transform the data from that column yourself from the raw JSON blob.

You can learn more about basic normalization here: https://docs.airbyte.com/understanding-airbyte/basic-normalization/

Let me know if this helped!