Skip to main content

WAREHOUSE_QUERY_HISTORY

Zuora

WAREHOUSE_QUERY_HISTORY

  1. Last updated
  2. Save as PDF

When you query data from Zuora Warehouse in Zuora’s services such as Data Query, Data Source Exports, or Reporting, Zuora stores the query details in the WAREHOUSE_QUERY_HISTORY table. Each row in this table represents a query job.

Columns

Column name Data type Description
TENANT_ID VARCHAR ID of your Zuora tenant that this query job belongs to.
QUERY_ID VARCHAR ID of this query job in Zuora Warehouse.
QUERY_TEXT VARCHAR Query expression of this query job.
START_TIME TIMESTAMP_TZ The date and time when this query job started.
END_TIME TIMESTAMP_TZ The date and time when this query job finished.
APPLICATION_CONTEXT VARCHAR

Zuora service by which this query job was generated:

  • AQUA
  • DATA QUERY
  • DSE
  • REPORTING
  • TRIAL BALANCE
TOTAL_ELAPSED_TIME NUMBER Elapsed time (in milliseconds) of this query job.
WAREHOUSE_SIZE VARCHAR Size of the warehouse this query job was run against.

Table example

The following is an example of the WAREHOUSE_QUERY_HISTORY table with two query histories:

TENANT_ID,QUERY_ID,QUERY_TEXT,START_TIME,END_TIME,APPLICATION_CONTEXT,TOTAL_ELAPSED_TIME,WAREHOUSE_SIZE
33456,01ad9815-0403-5128-004b-6a0324f3a8b6,SELECT ba.id,ba.balance FROM zb_billing_account ba --context=DATA QUERY,2023-08-15T18:18:39.901Z,2023-08-15T18:18:40.87Z,DATA QUERY,969,X-Small
33456,01ad9815-0403-5128-004b-6a0324f3a8b6,SELECT inv.subscriberid,inv.invoice_number,inv.status FROM zb_invoice inv --context=DATA QUERY,2023-08-15T18:18:33.654Z,2023-08-15T18:18:33.954Z,DATA QUERY,300,X-Small