# Adds the Queries and Reports API for querying your Stripe data with SQL

## What’s new

Adds the Queries and Reports API (`/v2/data`). You can use it to query your Stripe data with SQL and to run Stripe-defined reports.

The Queries and Reports API includes:

- [Schemas](https://docs.stripe.com/api/v2/data/schemas.md?api-version=2026-10-28.preview): List and retrieve the tables and columns you can query.
- [Reports](https://docs.stripe.com/api/v2/data/reports.md?api-version=2026-10-28.preview): List and retrieve Stripe-defined reports.
- [Query Runs](https://docs.stripe.com/api/v2/data/query-runs.md?api-version=2026-10-28.preview): Run SQL queries against your Stripe data.
- [Report Runs](https://docs.stripe.com/api/v2/data/report-runs.md?api-version=2026-10-28.preview): Run Stripe-defined reports.

Query runs and report runs are asynchronous. After you create a run, poll it until it completes, or listen for the [v2.data.query_run.succeeded](https://docs.stripe.com/api/v2/data/query-runs/event-types.md?api-version=2026-10-28.preview#v2_data_query_runs_event_types-v2.data.query_run.succeeded) or [v2.data.report_run.succeeded](https://docs.stripe.com/api/v2/data/report-runs/event-types.md?api-version=2026-10-28.preview#v2_data_report_runs_event_types-v2.data.report_run.succeeded) event. You can download results as a file or pass `include[]=result.inline` to get rows directly in the response. To see the SQL Stripe used to produce a report, pass `include[]=sql`.

## Impact

The Queries and Reports API replaces the Sigma API (`/v1/sigma`), the v1 Reporting API (`/v1/reporting`), and the preview Reporting APIs (`/v2/data/reporting` and `/v2/reporting`).

## Changes

#### REST API

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Endpoints | Change | Resources |
| --- | --- | --- |
| `list`, `retrieve` | Added | [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2.Data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2.Data.ReportRun` |

#### Ruby

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2::Data::QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2::Data::Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2::Data::ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2::Data::Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `list`, `retrieve` | Added | [V2::Data::Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2::Data::Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [V2::Data::QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2::Data::ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2::Data::QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2::Data::ReportRun` |

#### Python

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [v2.data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [v2.data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [v2.data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [v2.data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `list`, `retrieve` | Added | [v2.data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [v2.data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [v2.data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [v2.data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `v2.data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `v2.data.ReportRun` |

#### PHP

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `all`, `retrieve` | Added | [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2.Data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2.Data.ReportRun` |

#### Java

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [v2.data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [v2.data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [v2.data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [v2.data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `list`, `retrieve` | Added | [v2.data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [v2.data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [v2.data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [v2.data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `v2.data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `v2.data.ReportRun` |

#### Node.js

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `list`, `retrieve` | Added | [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `create`, `retrieve` | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2.Data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2.Data.ReportRun` |

#### Go

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2DataQueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2DataReport](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2DataReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2DataSchema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `Get`, `List` | Added | [V2DataReport](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2DataSchema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `Get`, `New` | Added | [V2DataQueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2DataReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2DataQueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2DataReportRun` |

#### .NET

|  | Change | Resources |
| --- | --- | --- |
|  | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |

| Methods | Change | Resources |
| --- | --- | --- |
| `Get`, `List` | Added | [V2.Data.Report](/api/v2/data/reports/object?api-version=2026-10-28.preview#v2_data_report_object), [V2.Data.Schema](/api/v2/data/schemas/object?api-version=2026-10-28.preview#v2_schema_object) |
| `Create`, `Get` | Added | [V2.Data.QueryRun](/api/v2/data/query-runs/object?api-version=2026-10-28.preview#v2_data_query_run_object), [V2.Data.ReportRun](/api/v2/data/report-runs/object?api-version=2026-10-28.preview#v2_data_report_run_object) |

|  | Change | Event types |
| --- | --- | --- |
| `V2DataQueryRunCreatedEvent`, `V2DataQueryRunFailedEvent`, `V2DataQueryRunSucceededEvent`, `V2DataQueryRunUpdatedEvent` | Added | `V2.Data.QueryRun` |
| `V2DataReportRunCreatedEvent`, `V2DataReportRunFailedEvent`, `V2DataReportRunSucceededEvent`, `V2DataReportRunUpdatedEvent` | Added | `V2.Data.ReportRun` |

## Upgrade

#### REST API

1. [View your current API version](https://docs.stripe.com/workbench/guides.md#view-api-versions) in Workbench.
2. If you use an SDK, upgrade to the corresponding SDK version for this API version.
   - If you don’t use an SDK, update your [API requests](https://docs.stripe.com/api-versions.md#how-versions-are-specified-in-requests) to include `Stripe-Version: 2026-10-28.preview`
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### Ruby

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your Ruby SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### Python

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your Python SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### PHP

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your PHP SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### Java

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your Java SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### Node.js

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your Node SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### Go

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your Go SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).

#### .NET

1. [View your current API version](https://docs.stripe.com/upgrades.md#view-your-api-version-and-the-latest-available-upgrade-in-workbench) in Workbench.
2. Upgrade your .NET SDK to the latest version.
3. Upgrade the API version used for [webhook endpoints](https://docs.stripe.com/webhooks/versioning.md).
4. [Test your integration](https://docs.stripe.com/testing.md) against the new version.
5. If you use Connect, [test your Connect integration](https://docs.stripe.com/connect/testing.md).
6. In Workbench, [perform the upgrade](https://docs.stripe.com/upgrades.md#perform-the-upgrade). You can [roll back the version](https://docs.stripe.com/upgrades.md#roll-back-your-api-version) for 72 hours.

Learn more about [Stripe API upgrades](https://docs.stripe.com/upgrades.md).
