Skip to main content
Question

Location of Errors and Warnings Messages

  • June 2, 2022
  • 1 reply
  • 0 views
A

Dear Community
If I'm clicking on Report->Errors or Warnings then I see a fulll list of them. Where are those records stored? In which table can I find them ?

My problem is that once forgot to check the "Error" manually, therefore I want to create a script which regularly should check if errors exists.

But wo far, I couldn't the table/view/place where this Infos are stored.

Any ideas?

 

Regards

Alex
e1122wg_cqmwut0sGIWZ1g.png

RJQarpl8oeCDuSwZcsYi1g.png

    J
    • JTreadwell
    • Community Manager
    • June 2, 2022

    Hi Alex, Great question. This data is stored in the Targe Database in the <TableName>_L and <TableName>_M tables. 

    1. The List Table (_L) - Holds the list of all DW_IDs of rows in the raw table that were flagged by a data validation rule.
    2. The Messages Table (_M) - Includes a description of why each record in the List table was flagged.

    Hope that helps!

     

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept or continue browsing you agree to our cookie policy. Learn more about our cookies.

     
    Cookie settings