https://linen.dev logo
o

Ofek Katriel

02/21/2022, 2:14 PM
Is this your first time deploying Airbyte: No OS Version / Instance: Windows 11 Memory / Disk: 8GB RAM Deployment: Docker Airbyte Version: 0.35.2-alpha Source name/version: airbyte/source-mongodb 0.1.11 Destination name/version: airbyte/destination-bigquery 0.6.8 Step: I am experiencing a strange behaviour in my connection, where Airbyte changes the field name and type from
amountPaid
to
amountPaid_airbyte_transform
. the new field is all NULL but there are values in the field. Please I need help to resolve this. Thank you.
Hi @David Effiong do you mind sharing your sync logs?
Hello Augustin, thank you very much. I and my CTO have observed the cause of this behaviour. This happened because that field had different data types. For example, row 1 of that field was "int" and row 2 was a "double"... So when this happens, airbyte transforms the field to Null strings. Thank you very much.
Ok, so you could set the type of your documents to double?
c

Carlos Alberto Cabrera Quiroga

02/21/2022, 11:19 PM
yes, we can. So we learnt that every row in the field must have the same data type - all int or double else airbyte will transform it to string null field.
2 Views