FEATURE - subscription_item

fivetran / dbt_stripe_source

Fivetran's Stripe source dbt package

https://fivetran.github.io/dbt_stripe_source/

Apache License 2.0

8 stars 27 forks source link

FEATURE - subscription_item #49

Open lijol opened 1 year ago

lijol commented 1 year ago

Is there an existing feature request for this?

[X] I have searched the existing issues

Describe the Feature

The new model for subscription item to be added

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

[X] Yes.
[X] Yes, but I will need assistance and will schedule time during your office hours for guidance.
[ ] No.

Anything else?

No response

fivetran-joemarkiewicz commented 1 year ago

Hi @lijol thanks so much for opening this feature request! Would you be able to elaborate a bit more on what the new model for subscription item would be?

I am picturing that you would like for us to add the subscription_item source table to this package to have a proper staging model. Would you consider doing any additional downstream transformations with this new staging model? Additionally, are there any other new sources you would consider useful to add to this package?

lijol commented 1 year ago

The model is helpful as I want the plan associated with the subscription and quantity.

I am creating a model involving invoice, plan, subscription_history and item. We wanted to know the invoice revenue .

I was trying to use the model stripe__invoice_line_items but unfortunately as I am not using customers it didn't help

fivetran-joemarkiewicz commented 1 year ago

Thanks for the clarification @lijol. As I mentioned in Issue #48, we are actually planning updates to this package and will keep the subscription_item in consideration when adding to the package.