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.

Best practices when querying data from Zuora

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.

Query each data source individually

Learn how to efficiently filter data using the indexed UpdatedDate column to improve query performance and avoid full table scans.

Filter by UpdatedDate only

This article explains the high water mark approach for AQuA stateless queries, recommended for efficient bulk data extraction in Zuora.

High Water Mark Approach for AQuA Stateless Queries

Learn how to extract deleted data in AQuA queries by setting the forceExport parameter to true within the deleted section.

Extract deleted data in AQuA queries

Learn best practices for loading data into your data warehouse, including initial extracts, incremental updates, and table management.

Best practices when loading data into your data warehouse

Follow these steps to perform a single load operation of a data source, ensuring data consistency and freshness in your data warehouse.

Data loading steps

View the SQL syntax and guidelines for efficiently deleting data from the staging table using the TRUNCATE command.

Delete data from staging table

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.

Bulk data extraction using other Zuora APIs

<body id="task-ac-1282"><main role="main"><article role="article" aria-labelledby="ariaid-title1"><h1 class="title topictitle1" id="ariaid-title1">Bulk data  extraction from Zuora using AQuA</h1><div class="body taskbody"><p class="shortdesc">This task outlines best practices for extracting data from Zuora using AQuA and loading it into an external data warehouse.</p><section class="section context">
      
      <p class="p">The following steps are recommended:</p>
    </section><ol class="ol steps"><li class="li step"><span class="ph cmd">Initial data extract:</span><ol type="a" class="ol substeps"><li class="li substep"><span class="ph cmd">Query historical data</span></li><li class="li substep"><span class="ph cmd">Load historical data into the external data warehouse</span></li></ol></li><li class="li step"><span class="ph cmd">Incremental data extracts:</span><ol type="a" class="ol substeps"><li class="li substep"><span class="ph cmd">Query changed data</span></li><li class="li substep"><span class="ph cmd">Load changed data into the external data warehouse</span></li></ol></li></ol></div></article></main></body>

zuora-platform/data/aggregate-query-api-aqua/aqua-api-introduction

Aggregate Query API (AQuA)

Learn how to access and use the AQuA Job Finder in the Zuora application to manage data integration tasks.

Access and use the AQuA job finder

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

Bulk data extraction from Zuora using AQuA

zuora-platform/data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua

data/aggregate-query-api-aqua/bulk-data-extraction-from-zuora-using-aqua

<body id="topic-9918"><main role="main"><article role="article" aria-labelledby="ariaid-title1"><h1 class="title topictitle1" id="ariaid-title1">zuora-footer</h1><div class="body"><div class="div custom-footer">
            <div class="div left-column"> <img class="image logo" src="https://zuora.deploy.heretto.com/v4/deployments/QPAZk6lsgXwvotedNERE/object/91e2cbe5-f650-465d-b2e0-001b64f6ed08?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJodHRwczovL2pvcnNlay5jb20vZXpkX29yZ2FuaXphdGlvbiI6Inp1b3JhIiwiaHR0cHM6Ly9qb3JzZWsuY29tL2V6ZC9vYmplY3RfdXVpZCI6IjkxZTJjYmU1LWY2NTAtNDY1ZC1iMmUwLTAwMWI2NGY2ZWQwOCIsImV4cCI6MTc2NDQzNzI1OCwianRpIjoiMDcwZmY1OTNhMWQzNDlmNTg3NTRiNDJhODgzMjRlYjMiLCJodHRwczovL2pvcnNlay5jb20vZXpkX2ZpbGVzZXQiOiIydHlaTmFoUWRnRll3dUd0VHVrQiJ9.-gsSNhUDSBDZfAKcUpLX_TzlaQbrlz0PjnxJAiUgZ98">
            </div>
            <div class="div right-column">
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Privacy Statement</a></p>
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Terms and Conditions</a></p>
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Cookie Preference</a></p>
                <p class="p">© 2025 Zuora Inc.</p>
            </div>
        </div></div></article></main></body>

zuora-footer

Developer Center

Find training and certifications to achieve your business needs

Zuora University

Connect, share, collaborate with the Zuora Community

Zuora Community

Fundamental Zuora information you should know

Basics

Explore entitlements for all Zuora product offerings

Entitlements

Learn the support and service policies at Zuora

Support and policies

Zuora Product Documentation

Monetize new offerings, create and manage subscriptions, and invoice customers

Zuora Billing

Collect and manage payments, reduce fraud, and boost acceptance

Zuora Payments

Build, customize, extend, and integrate with Zuora

Zuora Platform

Configure, price, and quote with speed and ease

Zuora CPQ

Optimize digital subscription Journeys and boost revenue growth

Zephr

Recognize, reconcile, and analyze revenue automatically

Zuora Revenue

Automate invoicing and collections to improve cash flow, mitigate financial risk, and ensure financial accuracy

Welcome to Zuora Product Documentation

Explore our rich library of product information

Bulk data extraction from Zuora using AQuA

zuora-footer