Destination Improvement: Need Json Data type for the columns in Big Query Destination
PlannedHi,
We are using multiple Mongo DB connectors for warehousing our transaction data. Majortiy of the fields in the Mongo DB collections that we are syncing are nested json Object. Now, we received an update that fivetran now supports Json datatype in the Big Query destination.But in our case the nested json objects we have are still loaded as string instead of native Json data type. Which is in convenient for us to perform operations. We found this article that says fivetran do not convert nested json objects from mongo db source to native Big Query Json data type. So we need this feature to support any nested json object or any json objects from any source , MongoDB specially to be converted to native destinations Json data type specially Big Query. We raised a case for this as well case number 202389, you will find detailed discussions there.

Please sign in to leave a comment.
Comments
0 comments