Welcome to Zuora Product Documentation

Explore our rich library of product information

DATA_QUALITY_LOG

Zuora runs a data quality check on each Zuora business object in your Snowflake account on a daily basis and stores the check logs in the DATA_QUALITY_LOG table.

You can use this table to monitor the completeness and accuracy of your Zuora data in Snowflake. Each row in this table represents the result of a data quality check of a specific Zuora business object.

If you want to enable the DATA_QUALITY_LOG table for your tenant, submit a request at Zuora Global Support.

Columns

The following table provides information on columns:

Column name

Data type

Description

FROM_TIME

TIMESTAMP_TZ

Beginning date and time of this data quality check.

TO_TIME

TIMESTAMP_TZ

End date and time of this data quality check.

TENANT_ID

VARCHAR

ID of your Zuora tenant that the object data being checked belongs to.

STATUS

VARCHAR

Result of this data quality check:

  • PASS : Data quality check succeeded, indicating the data of a specific object in your Zuora tenant and Snowflake is the same.

  • FAIL : Data quality check failed because of differences between data in your Zuora tenant and Snowflake. For example, count of rows, field values, or checksum. If you encounter a check failure, contact your Zuora account representative for more details and solutions.

EVENT_TYPE

VARCHAR

Type of this event. The only available value is Snowflake Quality Check .

OBJECT

VARCHAR

Name of the object being checked.

MESSAGE

VARCHAR

Details of this data quality check.

Table example

The following is an example of the DATA_QUALITY_LOG table with two successful checks and one failed check:

FROM_TIME,TO_TIME,TENANT_ID,STATUS,EVENT_TYPE,OBJECT,MESSAGE
2023-08-15T00:05:00.981Z,2023-08-16T00:02:34.171Z,33456,PASS,Snowflake Quality Check,Account,
2023-08-15T00:05:00.981Z,2023-08-16T00:02:34.171Z,33456,PASS,Snowflake Quality Check,Contact,
2023-08-15T00:05:00.981Z,2023-08-16T00:02:34.171Z,33456,FAIL,Snowflake Quality Check,InvoiceItem,"Failed quality check; Zuora team alerted"