Is this your first time deploying Airbyte: No
OS Version / Instance: Windows 11
Memory / Disk: 8GB RAM
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
. the new field is all NULL but there are values in the field. Please I need help to resolve this.
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?
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.