MongoDB connector data type issue with GCP BigQuery destination

Summary

The user is facing an issue where the MongoDB connector in Airbyte fails to determine data types for some attributes, resulting in ‘Unknown’ types and no data being downloaded for those attributes.


Question

Hi all,
I’m attempting to download data from MongoDB using Airbyte, utilizing the latest MongoDB connector and GCP BigQuery destination. The issue I’m encountering is that while the connector successfully identifies all attributes in the document, it fails to determine the data type for some of them and sets them up as ‘Unknown’. Consequently, the connector doesn’t download any data for attributes with an unknown data type. Is there a solution to this issue?
Thank you.



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mongodb-connector", "gcp-bigquery", "data-type", "unknown"]