[Bug] Fixing compilation error on hubspot_contact_lists

[fivetran-avinash]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

Description: For customers who do not have a contact_list_member table available in Quickstart, a compilation error can occur. In hubspot_contact_lists, there is a missing hubspot_contact_list_member_enabled conditional present in the upstream models that leads to the model calling on int_hubspot__email_metrics__by_contact_list when it shouldn't be (i.e. the variable is set to false). Adding this variable to the conditional should fix this issue.

Relevant error log or model output

compilation error model 'model.hubspot.hubspot__contact_lists' (models/marketing/hubspot__contact_lists.sql) depends on a node named 'int_hubspot__email_metrics__by_contact_list' which is disabled

Expected behavior

hubspot__contact_lists should compile with no errors.

dbt Project configurations

We are testing this with the following variable configuration.

Package versions

packages:

• package: fivetran/hubspot_source
  version: [">=0.14.0", "<0.15.0"]

What database are you using dbt with?

bigquery

dbt Version

1.7.14

Additional Context

No response

Are you willing to open a PR to help address this issue?

• Yes.
• Yes, but I will need assistance and will schedule time during our office hours for guidance
• No.