fivetran / dbt_hubspot

Data models for Hubspot built using dbt.
https://fivetran.github.io/dbt_hubspot/
Apache License 2.0
33 stars 38 forks source link

[Bug] Fixing compilation error on `hubspot_contact_lists` #141

Closed fivetran-avinash closed 3 months ago

fivetran-avinash commented 4 months ago

Is there an existing issue for this?

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:

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?