> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/docs/platform/data/data-query/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Data Query

> Learn about Data Query.

Learn about Data Query.

The Data Query feature enables you export data from your Zuora tenant by performing SQL queries. The following topics provide detailed information:

* [Overview of Data Query](/docs/platform/data/data-query/overview-of-data-query)
* [Construct SQL queries in Data Query](/docs/platform/data/data-query/construct-sql-queries-in-data-query)
* [Best practices when writing data queries](/docs/platform/data/data-query/best-practices-when-writing-data-queries)
* [Common use cases of data query](/docs/platform/data/data-query/common-use-cases-of-data-query)
* [Data Query Templates](/docs/platform/data/data-query/data-query-templates)
* [Use Data Query through user interface](/docs/platform/data/data-query/use-data-query-through-user-interface)

> Learn about Data Query.

## Docs

- [Overview of Data Query](https://zuora.ferndocs.com/docs/platform/data/data-query/overview-of-data-query.md): The Data Query feature allows exporting data from Zuora using asynchronous, read-only SQL queries, supporting multiple objects and providing API and UI access.
- [Use Data Query through API](https://zuora.ferndocs.com/docs/platform/data/data-query/overview-of-data-query/use-data-query-through-api.md): Learn how to export data from your Zuora tenant through Data Query API.
- [Construct SQL queries in Data Query](https://zuora.ferndocs.com/docs/platform/data/data-query/construct-sql-queries-in-data-query.md): Here is an overview of constructing SQL queries in Data Query, including supported SQL syntax and sample queries for retrieving data from your Zuora tenant.
- [Join data across multiple tables](https://zuora.ferndocs.com/docs/platform/data/data-query/construct-sql-queries-in-data-query/join-data-across-multiple-tables-part-2.md): Learn how to construct your query by joining data across multiple tables.
- [Encryption](https://zuora.ferndocs.com/docs/platform/data/data-query/construct-sql-queries-in-data-query/encryption.md): Learn to encrypt your query result.
- [Available tables](https://zuora.ferndocs.com/docs/platform/data/data-query/construct-sql-queries-in-data-query/available-tables.md): This reference provides an overview of available tables in Data Query, differences between tenants, and methods to retrieve table lists using the SHOW TABLES statement and Data Query Schema Browser.
- [Best practices when writing data queries](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries.md): Here are best practices when writing data queries.
- [Best-practice samples for common queries](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/best-practice-samples-for-common-queries.md): Here are best-practice samples for common queries, including retrieving subscriptions, products, accounts, attachments, and invoices.
- [General best practices](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/general-best-practices.md): Learn about best practices to query data by using Data Query.
- [Indexed fields](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/indexed-fields.md): Indexed fields are essential for optimizing data retrieval and search operations in databases, enhancing query performance and efficiency.
- [Common use cases of data query](https://zuora.ferndocs.com/docs/platform/data/data-query/common-use-cases-of-data-query.md): Here are examples of common data query use cases, including retrieving account details, processed usage records, and product information.
- [Data Query help section](https://zuora.ferndocs.com/docs/platform/data/data-query/data-query-help-section.md): This section provides help through a list of clarifications.
- [Data Query Templates](https://zuora.ferndocs.com/docs/platform/data/data-query/data-query-templates.md): Learn how to efficiently reuse predefined SQL queries using the Templates tab in the Data Query UI, enhancing data analysis tasks.
- [Use Data Query through user interface](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface.md): Learn how to use Data Query through user interface.
- [Create new data queries](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface/create-new-data-queries.md): Learn how to create new data queries through Data Query UI to export data from your Zuora tenant.
- [Save data queries](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface/save-data-queries.md): Learn how to save, view, and run data queries using the Data Query UI.
- [Update or delete data queries](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface/update-or-delete-data-queries.md): Learn how to update or delete data queries using the Data Query UI.
- [View the data query history](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface/view-the-data-query-history.md): Learn how to view the data query history.
- [Schema browser](https://zuora.ferndocs.com/docs/platform/data/data-query/use-data-query-through-user-interface/schema-browser.md): Explore and manage table schemas in your tenant using the Data Query Schema Browser, featuring search, sorting, and detailed field views.