We publish Data Query Release Notes when customer-facing features, enhancements, or resolved issues of Data Query are deployed to Zuora Sandbox environments. See the Data Query Release Notes below:
April 6, 2021
Workflow tables viewable to Schema Browser
You can now use Schema Browser to view the following Workflow tables:
See View objects in Schema Browser for how to access Schema Browser.
March 27, 2021
Table attachment available
attachment table is available for you to retrieve the attached file information records for the following Zuora objects:
See Best-practice samples for an attachment query sample.
March 16, 2021
updatedDate field has been added to the following objects since this release:
March 3, 2021
Data Query Schema Browser available
Data Query Schema Browser provides the capability for viewing schemas of all tables available in your tenants. With Schema Browser, you have the ability to get a custom view into all Zuora data, optimize an external warehouse, and gather a better understanding of the Zuora Billing object model.
See View objects in Schema Browser for more information.
Data Query Unlimited available as an Early Adopter feature
In addition to run data queries against the live transactional databases at Zuora, you can now use the Data Query Unlimited feature to query against the optimized, replicated database at 12 hours freshness for high volume extraction.
Deleted records can be filtered using WHERE clause
Deleted records are by default included in the output of Data Query Unlimited but not in that of Data Query Live, when deleted records exist in the tables. However, you can always filter deleted records using WHERE clause in both Data Query Unlimited and Data Query Live.
See Filter Deleted Records using WHERE clause for more information.
Resolved issue: converting query result into JSON file failed
Previously, when you used aggregation functions with Row type inputs in your SQL statements, Data Query failed to convert query results into JSON files. This issue has been resolved since this release.
February 3, 2021
Previously, when you queried objects with custom fields of
date type, the
date custom fields were actually retrieved as
varchar type. This issue has been resolved since this release and you can now perform date functions on the custom fields of