Skip to main content

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

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