Joining External Data with a Company

[w4ngel]

Feature request

Is your feature request related to a problem?

I am trying to connect Stripe data with companies within PostHog, I want this to be visible in the groups tab so non-technical users can easily put together insights based off revenue data from Stripe.

Describe the solution you'd like

I'd like to be able to join rows from Stripe to the properties row of a group or customer.

This would allow non-technical users to be able to easily include Stripe data in their insights, it would also save engineers time rather than manually sending a plan's value to PostHog via the API.

Describe alternatives you've considered

I've looked at using expanded person properties. But this doesn't seem to be accurate when displaying results within a insight. It's not showing all the customers that it should.
I also don't know how expanded person properties are being linked with a group or customer when our we store any IDs that would like it to a customer in stripe metadata.

Additional context

Debug info

Location: https://eu.posthog.com/project/12677/data-warehouse
Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/01944581-ce2c-7374-8b21-fb9eac6b76e4?t=2266
Admin: http://go/adminOrgEU/018ab7c3-7a4b-0000-491c-f1ebbc197f1d (project ID 12677)
Sentry: http://go/sentryEU/12677