Invoice Line Item is not guaranteed to be unique

[kristin-bagnall]

dbt_stripe/models/stripe.yml

Line 314 in d1ff90c

- name: invoice_line_item_id

From customer:
The stripe connector has ingested the data and I run the dbt job and get an error that the invoice line item id is not unique. I look at the data and, sure enough, it is not unique.

I email Stripe support. The long and the short of it is for invoice line items made before their 2019-12-03 API update the id field is not guaranteed to be unique. They told me that for items like this I really should be using the unique_id field for a unique id 🙄 .

This can be identified by the prefix on the id. If it is sli_ it is old and potentially not unique and should use the unique_id field which is guaranteed unique and is prefixed with il_.

I think this could be handled in the dbt module about how invoice_line_item_id is selected.

[fivetran-joemarkiewicz]

Addressed in PR #8