4 Replies Latest reply on Jun 27, 2018 11:25 AM by Mark McGhee

    Hyper Query Logs? If so, Where?

    Steven Burger

      Does Hyper maintain a set of query logs for extract datasources much in the same manner that a relational database does?

       

      My ask is similar to this older (TDE) thread: Re: Where to find backgrounder query used to refresh TDE?

       

      Key Need: Need to find a way to audit and trace lineage from the workbook all they way back to specific columns in the source data to meet GDPR auditing requirements.

       

      I am aware the columns (dimensions & measures) can be found in the workbook XML, and that really should be proactively managed in Hyper extract creation.   But need to meet a requirement to write SQL for results.

       

      Have tried joining Historical_Events table to the various hist_* tables in Workgroup Server (PostgreSQL) with no luck.  The best I can get is a lineage from workbook back to the source table, but not specific columns there-in.

       

      Suspect my answer will involve parsing log files and the PostgreSQL Workgroup server. Can anyone refute or confirm?

       

      Articles I've read for reference:

      Re: Where to find backgrounder query used to refresh TDE?

       

      http://ugamarkj.blogspot.com/2018/02/monitor-user-queries-from-tableau.html

       

      Thank you very much in advance!!