Getting "JSON to avro conversion failed" error while trying to sync MongoDB data to GCS

[anshjain-18]

Connector Name

destination-gcs, source-mongodb

Connector Version

gcs-0.4.8

What step the error happened?

During the sync

Relevant information

1. Trying to sync a Mongodb collection to GCS in parquet format. In the documents, some fields have boolean types, which are being interpreted as string by Airbyte.
2. Thus, when trying to sync, it fails with the error "Could not evaluate union, field apply_consistency is expected to be one of these: NULL, STRING. If this is a complex type, check if offending field (path: apply_consistency) adheres to schema: true"

Airbyte version: 1.3.1
MongoDb version: MongoDB 6.0.19 Atlas (edited)

Relevant log output

`"Could not evaluate union, field apply_consistency is expected to be one of these: NULL, STRING. If this is a complex type, check if offending field (path: apply_consistency) adheres to schema: true"`

Contribute

• Yes, I want to contribute