Currently, the stripe__customer_overview model is joining the transaction into the customer object. However, this results in transactions that are no associated with a customer to be included in the model. This can be confusing for customers as the totals for this model will not tie out to the other models if they have transactions not associated with customers. As mentioned in this dbt Slack thread, this is something that is confusing and should be updated.
Expected behavior
All transactions (even the ones not associated with a customer) should be included in the stripe__customer_overview model. For those that are not associated, we should include them in the "No Associated Customer Records" record.
Are you a current Fivetran customer?
Fivetran created bug.
Describe the bug
Currently, the
stripe__customer_overview
model is joining the transaction into the customer object. However, this results in transactions that are no associated with a customer to be included in the model. This can be confusing for customers as the totals for this model will not tie out to the other models if they have transactions not associated with customers. As mentioned in this dbt Slack thread, this is something that is confusing and should be updated.Expected behavior
All transactions (even the ones not associated with a customer) should be included in the
stripe__customer_overview
model. For those that are not associated, we should include them in the "No Associated Customer Records" record.