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] Include Owner variable to disable int_hubspot__deals_enhanced model #128

Closed fivetran-joemarkiewicz closed 8 months ago

fivetran-joemarkiewicz commented 9 months ago

Is there an existing issue for this?

Describe the issue

Currently the int_hubspot__deals_enhanced (and downstream models) are dependent on the following variables: ['hubspot_sales_enabled','hubspot_deal_enabled']. However, the intermediate model uses the owner source and the hubspot_owner_enabled variable should also be incorporated in the enable/disablement of the model(s)

Relevant error log or model output

Partial parse save file not found. Starting full parse.
14:15:19
Encountered an error:
Compilation Error in model int_hubspot__deals_enhanced (models/sales/intermediate/int_hubspot__deals_enhanced.sql)
Model 'model.hubspot.int_hubspot__deals_enhanced' (models/sales/intermediate/int_hubspot__deals_enhanced.sql) depends on a node named 'stg_hubspot__owner' which is disabled

Expected behavior

The models run properly even if the owner source is not included in the source schema.

dbt Project configurations

vars:
   hubspot_owner_enabled: false

Package versions

packages:
  - package: fivetran/hubspot
    version: [">=0.15.0", "<0.16.0"]

What database are you using dbt with?

bigquery

dbt Version

1.3.2

Additional Context

We should also check if there are other variables that need to be considered across the other intermediate/end models.

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