airbytehq / airbytehq/airbyte

[source-postgres] not detect correct datatype `numeric(35)` reads as `integer`

Aperta
#33,780 3 commenti 0 reazioni 0 assegnatari Vedi su GitHub
area/connectors community connectors/source/postgres frozen team/db-dw-sources type/bug
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:
![image](https://github.com/airbytehq/airbyte/assets/31256186/e285c14a-9535-4a2f-af04-f7f25692f3e0)

Types in Airbyte:
![image](https://github.com/airbytehq/airbyte/assets/31256186/ff448000-1dfa-4614-92cf-8e92fed58016)

Types in BQ:
![image](https://github.com/airbytehq/airbyte/assets/31256186/1e7bf809-7feb-44cd-a9d3-223a6eb4e415)

[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.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.