Skip to main content

Retrieve: Data Query

Zuora

Retrieve: Data Query

This task exports data from your tenant by running SQL queries. Because of the flexibility of SQL, you can use a single SQL query to retrieve data from multiple data objects that are not pre-joined by Zuora.

The data query task runs the entered query and exports data in a ZIP or CSV file. 

See SQL Queries in Data Query for the supported SQL syntax, the available tables, and sample queries. See Overview of Data Query for more information about Data Query.

Task settings

  • File Format: Select the format for the exported file. Available formats are CSV, TSV, DSV, and JSON.
  • Mode: Select the to run the query in either of the following modes for your task:
    • Live - Run data queries against Zuora live transactional database.

    • Unlimited - Run data queries against an optimized and replicated database designed for high volume extraction use cases.

  • Stop when no result returned: Select this option if you want the workflow to stop at this task if the query returns no data.
  • Use index join: If you want to use index join in your query, select this option. For more information about using index join in a data query task, see Use index join.
  • Compressed: Select whether you want to zip the output file. This option is selected by default. 
  • Read deleted: If selected, the query will only retrieve objects that are soft deleted. If not selected, only active objects will be retrieved. You cannot retrieve both soft-deleted and active data in a single data query task.

wf-dq.png