Closed lsusie closed 4 months ago
Thanks @lsusie for creating this very detailed ticket! We'll look to add this fix in the coming weeks.
Hi @lsusie ! We've got the ball rolling and will work to get this released in the coming week. In the meantime, feel free to use the following branch with the update. You'll need adjust the packages.yml in your stripe package. Let me know if there are any issues!
- git: https://github.com/fivetran/dbt_stripe.git
revision: bugfix/invoice_line_item_uniqueness_test
warn-unpinned: false
Thanks @lsusie for opening this! We've releasee this update and as such will close this issue out.
@fivetran-reneeli Awesome! Thanks for all the work you and your team does!
Is there an existing issue for this?
Describe the issue
An error in my Fivetran/Stripe package today with uniqueness in
stg_stripe_invoice_line_items
model. Seems to be testing for uniqueness onunique_invoice_line_item_id
but I have a few records where it is not unique through the data source.Relevant error log or model output
Expected behavior
As this
stg_stripe_invoice_line_items
has 2 PK's I expect theunique_stg_stripe__invoice_line_item_unique_invoice_line_item_id
to not exist.dbt_utils_unique_combination_of_columns_stg_stripe__invoice_line_item_invoice_line_item_id__invoice_id__source_relation
is already there to ensure the combo is uniquedbt Project configurations
Package versions
What database are you using dbt with?
bigquery
dbt Version
18:16:55 Running with dbt=1.6.11
Additional Context
I think you just need to remove this test?
Are you willing to open a PR to help address this issue?