[Bug] Account for new category field in Hubspot models, bring in engagement table and update upstream joins

[fivetran-avinash]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

A new category field was introduced in a recent PR to dbt_hubspot_source. More information available in these release notes.

We will need to add the category field to these models:

• stg_hubspot__engagement_company
• stg_hubspot__engagement_contact
• stg_hubspot__engagement_deal

We will also need to account for category in the upstream join in the int_rag_hubspot__deal_document here to ensure uniqueness within the Hubspot ticket RAG.

How would you implement this feature?

We will bring in the engagement source table into the Hubspot model, add it at the staging layer, then join it in to ensure uniqueness of the Hubspot RAG data.

Follow the steps in this PR!, then validate uniqueness on the new Hubspot staging models and make sure the joins also reflect uniqueness.

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