*Is this your first time deploying Airbyte*: No
*O...
# troubleshootingo
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_transformOfek Katriel
02/21/2022, 6:11 PMHi @David Effiong do you mind sharing your sync logs?
Ofek Katriel
02/21/2022, 6:27 PMHello 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.
Ofek Katriel
02/21/2022, 6:30 PMOk, 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