[source-postgres] not detect correct datatype `numeric(35)` reads as `integer`
- Lingua principale
- Python
- Stelle
- 22.1k
- Fork
- 5.3k
- Metriche di merge delle PR
- Metriche PR in attesa
Descrizione
### Connector Name
airbyte/source-postgres
### Connector Version
3.2.21
### What step the error happened?
During the sync
### Relevant information
Hello!
We used CDC. The determination of the data type and subsequent transfer occurs incorrectly.
In postgres there is a column numeric(35), Airbyte defines it as Integer, when further inserting data into Bigquery, an overflow occurs - too large a number does not fit in Integer.
Types in Posgres:

Types in Airbyte:

Types in BQ:

[Initial LOGS](https://github.com/airbytehq/airbyte/files/13770627/84e96bf0_c03c_4fc2_a7df_01b7a779f42e_logs_47665_txt.txt)
### Relevant log output
_No response_
### Contribute
- [ ] Yes, I want to contribute
Guida per i contributori
Apri la guida per i contributori
Valutazione
Questa issue non è ancora stata valutata.