Summary
When setting up a source from the platform account in Stripe Connect, data from connected accounts may not be included. The user is seeking advice on whether to set up connected accounts to import to the same dataset and potential issues that may arise.
Question
We use Stripe Connect, and I noticed that setting up a source from the platform account means we don’t get the data from our connected accounts. I’m wondering if we should set up the connected accounts (which we manage) to import to the same dataset, or whether that will create issues. Does anyone have any advice on how to handle this?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
["stripe-connect", "data-import", "connected-accounts", "platform-dataset"]
Subscriptions that are managed via our connected account
We still get the webhooks for those events on our primary account, so I’m pretty sure I’m using platform accounts correctly. We have it set up in the way that users never see the platform account (I know there are multiple ways to set this up)
Are those subscription managed on the connected account or the platform account? Subscriptions are usually managed on the connected account level but I want to make sure we have the same setup
They’re managed on the connected account yeah
It feels consistent with my understanding of platform accounts i.e. that the platform account and all the connected accounts are still just Stripe account with their own objects. Do you have any information that would lead us to believe that the platform account should expose this information?
No I think it makes sense that they’re not imported actually. I guess my question is: should they be imported to the same bigquery dataset (my-gcp-project.stripe) or should the platform data and each connected account data be imported to different datasets (my-gcp-project.stripe_some_account, my-gcp-project.stripe_platform )
Yes, that is a good question and it really depends on your use case. I think the easier path is to have them in different tables and perform a query in BigQuery using a wildcard table. Would that work in your case?
I think that would probably work actually, yeah! Hadn’t thought of that.
I think I’ll go for that approach then. Thank you!
Cool! Let me know if you end up taking a different approach. I’m always curious about how our users end up using our source and destination
<@U04CMAQQL3D> as you’re the Stripe expert, do you mind helping here? :octavia-thanks:
To help me scope the problem <@U07AAJ4B2DR>, can you describe some of the data you are missing when using the platform account?