-
Notifications
You must be signed in to change notification settings - Fork 39
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] Missing column in intermediate model if variable is set #102
Comments
HI @antoon-r thanks for opening this bug report. I agree with you that these downstream models fail when the Upon further scoping I found the following additional problems areas:
Based on the above, it is clear that we should not be iterating on a field that could possibly not exist in the data based if a variable is set to false. I believe what may be the optimal path forward is to add the functionality to the package to dynamically infer the metrics. If the metric doesn't exist, then it can be skipped. Nevertheless, we will add this to our upcoming sprint to be addressed. Thanks again for raising this to our team! |
Hi @antoon-r I've created a test branch for you to try out. To use it, simply replace the dbt_hubspot section in your - git: https://github.com/fivetran/dbt_hubspot.git
revision: bug/email-metrics-variable
warn-unpinned: false You should be able to use this new branch without any further modifications. Please let me know how it works for you! |
Hi @fivetran-catfritz this branch fixes the problem, thank you. |
Is there an existing issue for this?
Describe the issue
When running project with var
hubspot_email_event_status_change_enabled: false
, it fails with Database ErrorProblem is on this line:
dbt_hubspot/models/marketing/hubspot__email_sends.sql
Line 43 in 7d76e94
When column
unsubscribes
is not created, it should not be accessed, too. It can be fixed by using customemail_metrics
array in dbt_project.yml, but it is impossible to figure it out without looking into the code of packageRelevant error log or model output
Expected behavior
Run does not fail with Database Error
dbt Project configurations
vars:
hubspot_email_event_status_change_enabled: false
Package versions
packages:
version: 0.9.0
What database are you using dbt with?
bigquery
dbt Version
1.3.1
Additional Context
No response
Are you willing to open a PR to help address this issue?
The text was updated successfully, but these errors were encountered: