> 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/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Bulk data extraction from Zuora using AQuA

> This task outlines best practices for extracting data from Zuora using AQuA and loading it into an external data warehouse.

This task outlines best practices for extracting data from Zuora using AQuA and loading it into an external data warehouse.

The following steps are recommended:

Initial data extract:

1. Query historical data
2. Load historical data into the external data warehouse

Incremental data extracts:

1. Query changed data
2. Load changed data into the external data warehouse

> This task outlines best practices for extracting data from Zuora using AQuA and loading it into an external data warehouse.

## Docs

- [Best practices when querying data from Zuora](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/best-practices-when-querying-data-from-zuora.md): Learn the recommended steps for querying data from Zuora using AQuA, including querying each data source individually, batching queries, filtering by updated date, using stateless queries, and extracting deleted data.
- [Query each data source individually](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/query-each-data-source-individually.md): Learn how to query each data source individually by focusing on base object fields and parent object IDs to optimize performance and reconstruct relationships in an external repository.
- [Filter by UpdatedDate only](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/filter-by-updateddate-only.md): Learn how to efficiently filter data using the indexed UpdatedDate column to improve query performance and avoid full table scans.
- [High Water Mark Approach for AQuA Stateless Queries](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/high-water-mark-approach-for-aqua-stateless-queries.md): This article explains the high water mark approach for AQuA stateless queries, recommended for efficient bulk data extraction in Zuora.
- [Extract deleted data in AQuA queries](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/extract-deleted-data-in-aqua-queries.md): Learn how to extract deleted data in AQuA queries by setting the forceExport parameter to true within the deleted section.
- [Best practices when loading data into your data warehouse](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/best-practices-when-loading-data-into-your-data-warehouse.md): Learn best practices for loading data into your data warehouse, including initial extracts, incremental updates, and table management.
- [Data loading steps](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/data-loading-steps.md): Follow these steps to perform a single load operation of a data source, ensuring data consistency and freshness in your data warehouse.
- [Delete data from staging table](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/delete-data-from-staging-table.md): View the SQL syntax and guidelines for efficiently deleting data from the staging table using the TRUNCATE command.
- [Bulk data extraction using other Zuora APIs](https://zuora.ferndocs.com/docs/platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua/bulk-data-extraction-using-other-zuora-apis.md): Explains why Zuora Data Query API is not recommended for large-scale data exports and outlines Zuora's planned Bulk Query API for warehouse-level data extraction.