Stripe — data contract (daily revenue aggregate between stages; not affiliated with Stripe)
Daily revenue mart grain built from staged charges. Between-stages gate, kept alongside dbt, Great Expectations, or Soda. Derived from stripe_charges_staged. Not affiliated with Stripe.
This contract is one boundary in the Stripe charges pipeline chain. Validate the payload at that boundary, then follow the neighbors.
Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.
Contract family
Stripe charges pipeline
Stripe charges as they move from raw ingest, through a cleaned stage and a daily revenue mart, to a partner payout feed. Not affiliated with Stripe. Sample ids are fake.
- Ingest
- Between stages
Derived from stripe_charges_raw
- Between stages3revenue_daily_martThis contract
Derived from stripe_charges_staged
- Egress
Derived from revenue_daily_mart
Fields
| Name | Type | Required | Rule | Description |
|---|---|---|---|---|
| revenue_date | string | required | pattern /^[0-9]{4}-[0-9]{2}-[0-9]{2}$/ | UTC calendar date of the aggregate (from charged_at). |
| currency | string | required | pattern /^[A-Z]{3}$/ | — |
| status | string | required | one of: succeeded, pending, failed | — |
| charge_count | integer | required | ≥ 0 | — |
| gross_amount | number | required | ≥ 0 | Sum of staged charge amounts for the grain, major currency units. |
| refunded_amount | number | required | ≥ 0 | — |
| net_amount | number | required | — | gross_amount minus refunded_amount for the grain. |
| as_of | string | required | pattern /^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}Z$/ | When this mart row was computed, UTC ISO-8601. |
Sample rows
One synthetic row we wrote. It validates against this contract with zero violations. No real customer data.
[
{
"as_of": "2025-01-02T06:00:00Z",
"charge_count": 3,
"currency": "USD",
"gross_amount": 128.97,
"net_amount": 128.97,
"refunded_amount": 0,
"revenue_date": "2025-01-01",
"status": "succeeded"
}
]Provenance
- Verified against
- —
- Checked
- —
- Version
- v1.0
- Author
- DataContractGate
- License
- MIT
Spotted a mismatch with the vendor’s current schema? Report an issue.
Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.