Sources Stripe

1version: 2
2
3# Raw Stripe tables as they land in YOUR warehouse (e.g. via Fivetran, Airbyte, or a custom sync).
4# Adjust database/schema to match. If you use custom revenue events instead of Stripe, declare the
5# PostHog events export here instead and stage the revenue property out of it.
6sources:
7    - name: stripe
8      database: analytics
9      schema: stripe_raw
10      tables:
11          - name: invoice_line_items
12            description: Line items — the grain for revenue recognition.
13          - name: invoices
14          - name: subscriptions
15          - name: customers
16
17seeds:
18    # Static currency rate table for dbt (PostHog's convertCurrency has no dbt equivalent).
19    # Provide seeds/currency_rates.csv with columns: currency, rate_date, rate_to_base.
20    - name: currency_rates
21      description: Daily FX rates to the reporting base currency.