Intermediate
How to query data with sigma on Stripe
Quick Answer
Stripe Sigma allows you to query your payment data using SQL through the Stripe Dashboard. You can create custom reports, analyze transaction patterns, and export data by writing SQL queries against your Stripe data warehouse.
Prerequisites
- Active Stripe account with Sigma access
- Basic understanding of SQL queries
- Access to Stripe Dashboard
- Familiarity with your Stripe data structure
1
Access Stripe Sigma
Log into your Stripe Dashboard and navigate to the Reports section in the left sidebar. Click on Sigma to access the SQL query interface. If you don't see Sigma, ensure your account has the feature enabled or contact Stripe support.
Tip
Sigma is available for accounts that meet certain volume thresholds or have it enabled as an add-on feature.
2
Choose or create a new query
In the Sigma interface, you can either select from Query templates for common use cases or click New query to create a custom SQL query. Templates include options like revenue analysis, customer lifetime value, and payment method breakdowns.
Tip
Start with templates to understand the data structure before writing custom queries.
3
Write your SQL query
In the query editor, write your SQL statement using Stripe's data schema. Common tables include
charges, customers, subscriptions, and invoices. For example:SELECT created, amount, currency, status
FROM charges
WHERE created >= '2026-01-01'
ORDER BY created DESC
LIMIT 100Tip
Use the schema browser on the left to explore available tables and columns.
4
Execute and review results
Click the Run query button to execute your SQL statement. Results will appear in a table format below the query editor. Review the data for accuracy and check that column headers match your expectations.
Tip
Start with LIMIT clauses to avoid overwhelming results when testing new queries.
5
Filter and refine your query
Use the Add filter options or modify your WHERE clause to narrow down results. You can filter by date ranges, amounts, currencies, customer segments, or any other available fields. Add
GROUP BY and aggregation functions like SUM() or COUNT() for summary reports.Tip
Use date functions like DATE_TRUNC() to group data by specific time periods.
6
Save and schedule your query
Once satisfied with your results, click Save query and provide a descriptive name. You can then set up Scheduled runs to automatically execute the query daily, weekly, or monthly. Configure email notifications to receive results automatically.
Tip
Saved queries can be shared with team members who have Sigma access.
7
Export or visualize data
Click the Export button to download results as CSV or Excel files. For visualization, use the Chart option to create graphs directly in Sigma, or export the data to external tools like Google Sheets or business intelligence platforms.
Tip
Large datasets may take several minutes to export - use filters to reduce data size when possible.
Troubleshooting
Query timeout errors
Reduce the date range or add more specific WHERE clauses to limit the dataset size. Consider using
LIMIT statements and avoid complex JOINs on large tables.Column not found errors
Check the schema browser for correct table and column names. Ensure you're using the right table aliases and that columns exist in your account's data structure.
No data returned from query
Verify your date filters match your account's data timeframe. Check that WHERE conditions aren't too restrictive and ensure your account has data for the specified period.
Sigma feature not available
Contact Stripe support to enable Sigma for your account. Feature availability depends on your account type and transaction volume. Some accounts may need to upgrade their plan.
Ready to get started with Stripe?
Put this tutorial into practice. Visit Stripe and follow the steps above.
Visit Stripe →