We built Stripe Sigma to help businesses quickly analyse their Stripe data and to enable teams to get faster business insights.
We’ve already written the queries for the most useful reports for different types of businesses: From computing ARPU to analysing the payment methods your customers prefer, you can jump in quickly by editing one of our prebuilt templates or start from scratch to fully customise your report. We’ve also added syntax highlighting, descriptive errors, and auto-completion for data tables and columns - it’s like a built-in IDE for writing queries.
idPrimary key
Unique ID.
amountBigint
The amount (in the smallest currency unit; e.g. cents in USD and yen in JPY).
amount_dueBigintamount_offBigintamount_refundedBigintamount_reversedBigintcustomersTablecustomers.account_balanceBigintcustomers.business_vat_idVarcharcustomers.createdTimestampcustomers.currencyVarcharcustomers.default_source_idVarcharcustomers.delinquentBooleancustomers.descriptionVarcharcustomers.discount_coupon_idForeign keycurrencyVarchar
Three-letter ISO currency code, in lowercase. Must be a supported currency.
current_period_endTimestampcurrent_period_startTimestampcurrencyVarchar
Three-letter ISO currency code, in lowercase. Must be a supported currency.
source_idForeign key
ID of the related payment source.
source_transaction_idVarcharsource_transfer_idVarcharsource_typeVarcharsourcesTablesources_metadataTablesources_metadata.keyVarcharsource_idForeign key
ID of the related payment source.
source_transaction_idVarcharsource_transfer_idVarcharsource_typeVarcharsource_idForeign key
ID of the related payment source.
balance_transactionsTablebalance_transactions.amountBigintbalance_transactions.automatic_transfer_idForeign keybalance_transactions.available_onTimestampbalance_transactions.createdTimestampbalance_transactions.currencyVarcharQuick sidebar access to a full map of the structure of your data stored in Stripe (including any additional metadata you send us) makes it easy to combine all the relevant data needed from across Stripe’s products - payments, payouts, customers, subscriptions, refunds, and more.
Preview the full schema available in Stripe Sigma.
Save frequently-used queries to run them again at any time or share a link to a useful query so that any of your teammates can use it too.
Stripe Sigma has helped accelerate our financial close process. Instead of manually combining multiple data sources each month, we’re now able to run a few simple queries in Sigma, enabling faster monthly reconciliation for credit card transactions.
With a query that took less than 5 minutes to write, our team has been able to identify unpaid invoices and recapture tens of thousands of dollars of revenue - 8 percent of failed payments - in just two months.
We handle orders for thousands of stores, so financial reporting can get challenging. Stripe Sigma gives us a lightning-fast, reliable way to analyse our financial data and helps us run the business more efficiently.
Before Stripe Sigma, we built our own tool to analyse our Stripe data, but it took our engineers weeks to build, required ongoing work to maintain and update, and it wasn’t always accurate. Sigma now gives all our teams accurate data without any engineering work.
Stripe warehouses and makes all of your business’s historical data highly available with extensive parallelism so that you can generate even complex reports in seconds. Stripe Sigma’s monthly pricing is based on how many charges, authorisations, and application fees your business processed in the previous month. Learn more
Charges per month
Estimated monthly cost