> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# 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.

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](https://support.zuora.com/).

## Columns

The following table provides information on columns:

<table>
  <tr>
    <th>
      Column name
    </th>

    <th>
      Data type
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      FROM_TIME
    </td>

    <td>
      TIMESTAMP_TZ
    </td>

    <td>
      Beginning date and time of this data quality check.
    </td>
  </tr>

  <tr>
    <td>
      TO_TIME
    </td>

    <td>
      TIMESTAMP_TZ
    </td>

    <td>
      End date and time of this data quality check.
    </td>
  </tr>

  <tr>
    <td>
      TENANT_ID
    </td>

    <td>
      VARCHAR
    </td>

    <td>
      ID of your Zuora tenant that the object data being checked belongs to.
    </td>
  </tr>

  <tr>
    <td>
      STATUS
    </td>

    <td>
      VARCHAR
    </td>

    <td>
      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.
    </td>
  </tr>

  <tr>
    <td>
      EVENT_TYPE
    </td>

    <td>
      VARCHAR
    </td>

    <td>
      Type of this event. The only available value is `Snowflake Quality Check` .
    </td>
  </tr>

  <tr>
    <td>
      OBJECT
    </td>

    <td>
      VARCHAR
    </td>

    <td>
      Name of the object being checked.
    </td>
  </tr>

  <tr>
    <td>
      MESSAGE
    </td>

    <td>
      VARCHAR
    </td>

    <td>
      Details of this data quality check.
    </td>
  </tr>
</table>

## 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"
```