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

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.