> This page is for Docs.

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

# Data loading steps

> Follow these steps to perform a single load operation of a data source, ensuring data consistency and freshness in 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.

To complete a single load operation of a data source, Zuora recommends the following steps:

Delete all data from the staging table

Load incremental batch into the staging table

Delete from the query table any row that has the same Id as a row in the staging table

Insert into the query table all the rows whose `is_deleted` is `false` in the staging table

Zuora recommends that you script all the steps for all data sources so that you can perform them in a single transaction. In this way, your data warehouse clients always query against a consistent snapshot of the complete data set.

You can keep track of how fresh the data in the data warehouse is by maintaining a data freshness table of data sources and their last update dates.