Channels
#troubleshooting
Title
o
Ofek Katriel
02/21/2022, 2:14 PMIs 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
amountPaidamountPaid_airbyte_transformHi @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 PMyes, 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