Data Query becomes general availability early this year, so not a lot of customers are using it. Besides the articles in the knowledge center, maybe you can reach out to your Zuora account manager or Zuora customer success manager to learn more about the a dvantage of using Data query over Aqua API (ZOQLExport).
Based on the current definition in the developer center, the target value must be S3 only and there are no other options yet.
https://www.zuora.com/developer/api-reference/#operation/POST_DataQueryJob
The Available Tables of data query can be found in https://knowledgecenter.zuora.com/Central_Platform/Query/Data_Query/BA_SQL_Queries_in_Data_Query#Supported_SQL_Syntax
Data Source objects can be found in
https://knowledgecenter.zuora.com/Billing/Reporting_and_Analytics/D_Data_Sources_and_Exports/AB_Data_Source_Availability
"The main difference between tables in Data Query and data sources is that tables in Data Query are not pre-joined to other tables. When you query a table in Data Query, you can arbitrarily join other tables to retrieve any data that you require. In the corresponding data source, Zuora has pre-joined the base object to a fixed set of related object types; you cannot retrieve data from other object types."
Both the ZOQLExport & Data Query are asynchronous method and you need to perform multiple steps to get the result file.
... View more
