Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] Include Owner variable to disable int_hubspot__deals_enhanced model #128

Closed
1 of 4 tasks
fivetran-joemarkiewicz opened this issue Dec 7, 2023 · 0 comments · Fixed by #129
Closed
1 of 4 tasks
Assignees
Labels
error:unforced priority:p4 Affects few users; pick up when available status:in_progress Currently being worked on type:bug Something is broken or incorrect update_type:models Primary focus requires model updates

Comments

@fivetran-joemarkiewicz
Copy link
Contributor

Is there an existing issue for this?

  • I have searched the existing issues

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?

  • Yes.
  • Yes, but I will need assistance and will schedule time during our office hours for guidance
  • No.
@fivetran-catfritz fivetran-catfritz self-assigned this Dec 12, 2023
@fivetran-catfritz fivetran-catfritz added type:bug Something is broken or incorrect priority:p4 Affects few users; pick up when available status:in_progress Currently being worked on update_type:models Primary focus requires model updates labels Dec 12, 2023
@fivetran-catfritz fivetran-catfritz linked a pull request Dec 12, 2023 that will close this issue
7 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
error:unforced priority:p4 Affects few users; pick up when available status:in_progress Currently being worked on type:bug Something is broken or incorrect update_type:models Primary focus requires model updates
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants