Linked to this question:
https://meltano.slack.com/archives/C01PKLU5D1R/p1644014783916389
Has anyone ever tried to create a child stream with multiple parents? I know this is currently impossible, but any ideas on hwo to circumvent this issue?
My use case is that I have api (hubspot) that takes in a TYPE, and an objectId. I have 2 types,
deals and
contacts. I currently run through all of the contacts to get their ids and make one query by id. I would like to now run through contacts
AND deals to get both their ids and create on large table of web analytics.
Any thoughts?