Skip to main content

Data Query Release Notes

Zuora

Data Query Release Notes

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:

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

Data Query Unlimited is an Early Adopter feature.  If you want to have access to the feature, submit a request at Zuora Global Support.

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.

You can use the Data Query Unlimited feature through Data Query UI and Submit data query API.

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.

Data Query Unlimited is an Early Adopter feature.  If you want to have access to the feature, submit a request at Zuora Global Support.

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 date type.