Data Query Release Notes

Revision to end-of-life columns

In the release note dated August 10, 2021, we advised that the following columns would become unavailable in the Data Query schema in January 2023. We have revised this plan. The following columns will continue to be available in the Data Query schema after January 2023.

• The amount column in the PaymentPart object.
• The accountingcode column in the ProductRatePlanCharge object.
• The price and priceformat columns in the ProductRatePlanChargeTier object.

The release note dated August 10, 2021 has been updated accordingly.

Tables for Collections features available

The following tables are available for you to retrieve records for Collections features:

• Collections_ApmPaymentRuns
• Collections_CollectionsWindowInfo
• Collections_ConnectorExecutions
• Collections_LockboxRecords
• Collections_Lockboxes
• Collections_LockboxPayment
• Collections_RetryAttempts
• Collections_CustomerGroups
• Collections_MetricSnapshots
• Collections_RetryCycles
• Collections_Groups
• Collections_Note
• Collections_Replies
• Collections_Commentables

See Use Data Query to report on Collections features for more information.

End-of-life columns heads-up

The following impactful changes for Data Query objects will take place in January 2023. To minimize any impact on your queries, please make changes as soon as possible in your existing queries. For any assistance please contact Zuora Global Support.

Workflow tables viewable to Schema Browser

You can now use Schema Browser to view the following Workflow tables:

• workflow
• workflow_api_call
• workflow_linkage
• workflow_task
• workflow_task_usage

See View objects in Schema Browser for how to access Schema Browser.

Table attachment available

The attachment table is available for you to retrieve the attached file information records for the following Zuora objects:

• debitmemo
• creditmemo
• account
• subscription
• invoice

See Best-practice samples for an attachment query sample.

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.

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.

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.