How It Works

Key Concepts

• Read-only: Queries never modify operational data.
• Scoped access: Results include only your organization’s data.
• Curated schema: Tables reflect common analytics needs, such as payments, refunds, customers, payouts, disputes, and balance transactions.
• Templates: Prebuilt queries help you get started quickly and can be customized.

What Data Is Included

• Payments: One row per successfully processed charge; includes amounts, status, method type, timestamps, and customer linkage.
• Refunds: One row per refund; linked to original payments.
• Payouts: Disbursements to your bank account, with status and arrival times.
• Balance transactions: Ledger of changes to your available balance (amount, fee, net, type, available_on).
• Customers: Basic customer profile fields used for reporting.
• Disputes: Dispute/chargeback records, when available.

Availability of fields can vary by integration and plan. Use the schema browser for the most accurate, up-to-date view.

Data Freshness

• Most tables update within minutes of new activity.
• Reconciliation-heavy tables (for example, disputes) may appear later.
• The editor displays table-level freshness so you can see when a dataset was last updated.

Security & Privacy

• Organization-level isolation prevents cross-tenant access.
• Sensitive fields may be masked depending on plan and policy.
• Access and actions in Prism are audited for safety and compliance.

Plans & Limits (Overview)

• Interactive queries have runtime, row/size, and concurrency limits to keep the system fast for everyone.
• Exact limits depend on your plan and may change over time.
• See details: /docs/prism-limits-performance

Last updated: 2025-10-20