Connector Improvement: Mongo nested json getting stored as type json rather than type
AnsweredI've been working through the data in tellescopefivetran_ianacare and there are at least two fields I've found so far that are still formatted as json which requires writing more complex sql using JSON_EXTRACT_SCALAR and JSON_QUERY_ARRAY/UNNEST logic. Is there a way to update the Fivetran configuration so that all fields are presented as individual columns of either strings or arrays(records)? That's how the data is stored with our Stitch integration, so that's how all of our queries are structured, and we want to avoid restructuring everything when we move to Fivetran.
-
Official comment
Hi Andy,
Thanks for sharing your request! We currently don't have this on the roadmap, but happy to consider. Can you please describe your expectations in more detail? Any examples of how your data model looks like and how you would like to have it represented in the destination will help?
Thanks,
Val Kulichenko, Fivetran Product Team
Please sign in to leave a comment.
Comments
1 comment