Comments (5)
Hi @d3ad-pix3l thanks so much for opening this feature request.
Before we talked further about this feature, I did want to bring light to the metadata
fields that are synced within the Fivetran Stripe connector. This field is a JSON object that contains extra fields and information related to your base tables that weren't awarded their own specific field. This is usually due to the fact that not all customers may have these fields.
Do you by chance see the paid_out_of_bond
field within the metadata
JSON object of your invoice table? If so, you can leverage the feature of this package to pivot out a metadata field in order to leverage it in your down stream analysis.
Let me know if this was helpful. If you are unable to find that field in the metadata object then we can chat more about the possible implementation of this feature.
Thanks!
from dbt_stripe.
@fivetran-joemarkiewicz I checked the metadata
column on the invoice
table and did not see this value. Looking in Stripe's UI and their Sigma reporting solution I do not see this value in the metadata. In the Sigma reporting it is a separate column on the invoices
table.
from dbt_stripe.
Ah I see this is a field that doesn't exist within the metadata
column or in the source table at all. If that is the case, then I actually feel that a better first step would be to see if this is something that could be brought into the connector.
Since there doesn't seem to be a very clear and direct way to identify if an invoice was paid_out_of_bound, I am leaning towards trying to bring the field into the connector instead of attempting to recreate in the dbt package. It actually looks like another customer was hoping to do the same with their Feature Request. I think a best next step would be for you to upvote that FR and comment your need for the field within the invoice table.
Reaching out to your account rep should also be able to get more eyes on this to be integrated into the connector. Let me know if you have any other questions!
from dbt_stripe.
@fivetran-joemarkiewicz That makes sense. I was told to create the issue here, but think there might have been some confusion about the ask and what was currently being supported. I have followed and voted the linked feature request and will send an email to our rep. Thanks for your help.
from dbt_stripe.
Happy to help @d3ad-pix3l
Yeah I would be happy to support this within the package but it seems like there would be too many edge cases that we wouldn't be able to account for in our logic if we implemented a transformation to recreate the field. Since it seems to be a similar request from other customers, it may be the most beneficial to add this field into the connector itself. I would rather have the connector produce something 100% accurate than try our best to recreate the field in the dbt package and see it not work in all cases.
I will close this issue as your rep will be able to direct you in the right place following our discussion here. Feel free to have the rep loop me into your correspondence if I can help provide any clarification 😄
from dbt_stripe.
Related Issues (20)
- [Bug] Issue with stripe source on dbt run HOT 5
- [Bug] Timezone conversion doesn't work on postgres HOT 3
- [Bug] Latest Version of Stripe does not reference latest stripe_source HOT 1
- [Feature] Databricks Support
- How to adjust models? HOT 18
- [Bug] Errors when extracting JSON values HOT 12
- [Feature] currency field to be pulled through to invoice_line_items HOT 4
- Your package relies on older versions of dbt-utils, which means our project is stuck on an older version HOT 2
- Add table rename at the end of each refresh HOT 5
- [Bug] stripe__daily_overview run exceeds memory HOT 1
- [Bug] Error in tmp models due to metadata type json HOT 3
- [FEATURE] metadata columns does not appear summary tables HOT 3
- [Feature] DuckDB Support HOT 1
- [Feature] Be able to leverage package to create MRR reports
- [Feature] Stripe report folder should be renamed to Stripe financial reports
- [Question] Custom metadata column don't use alias feature HOT 3
- [Bug] update date_spine model to accommodate empty `stripe__balance_transactions`
- [Bug] livemode_predicate generates invalid SQL on Redshift: cannot cast type character varying to boolean HOT 5
- [Investigation] Possible fanout in `int_stripe__account_daily` when using connected accounts
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt_stripe.