[Feature] Update deprecated columns in ENGAGEMENT source #143
Description
Is there an existing feature request for this?
- I have searched the existing issues
Describe the Feature
In the May 2023 HubSpot connector update, the ENGAGEMENT table was streamlined in favor of separate child tables, such as ENGAGEMENT_NOTE, ENGAGEMENT_EMAIL, etc. (see below)
Our engagement staging model should be updated to reflect this schema change. For example, fields like owner_id are no longer available in ENGAGEMENT, which currently results in null values being propagated downstream—e.g., in hubspot__engagements.
How would you implement this feature?
Once the sources are updated, dependent models will also need adjustments. We should either:
- remove deprecated fields like
owner_id, or - update the joins to pull those fields from the appropriate child tables.
Describe alternatives you've considered
No response
Are you interested in contributing this feature?
- Yes.
- Yes, but I will need assistance.
- No.
Anything else?
No response