How to query data with sigma on Stripe

intermediate 8 min read Updated 2026-03-18

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.

Try Stripe Full Stripe Review

Prerequisites

Active Stripe account with Sigma access
Basic understanding of SQL queries
Access to Stripe Dashboard
Familiarity with your Stripe data structure

Step-by-Step Instructions

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.

Sigma is available for accounts that meet certain volume thresholds or have it enabled as an add-on feature.

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.

Start with templates to understand the data structure before writing custom queries.

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 100

Use the schema browser on the left to explore available tables and columns.

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.

Start with LIMIT clauses to avoid overwhelming results when testing new queries.

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.

Use date functions like DATE_TRUNC() to group data by specific time periods.

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.

Saved queries can be shared with team members who have Sigma access.

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.

Large datasets may take several minutes to export - use filters to reduce data size when possible.

Common Issues & 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.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Stripe website before purchasing.

Visit Stripe View Stripe Pricing