Query Log and Audit Trails
All queries sent to the Data Virtuality Server are recorded in a central query log, independent of their origin (e.g. from Studio users or other data consumer tools). The query log can be opened from the Studio’s main toolbar :
The query log includes the following information:
- The actual SQL query sent
- The issuer of the SQL query (Data Virtuality user name)
- Execution time, including details on certain state changes of the query
- Failure messages, if any
- Historic execution plan and data lineage at the time the query was issued (if enabled)
Retention of the query log
There is a system job periodically cleaning up the query log, excluding still running queries. The retention period can be configured by opening the jobs tab (), right-clicking on “Clean finished job and query logs task” and selecting “Edit job”.
All changes to entities maintained by the Data Virtuality Server are recorded in an audit trail. Each entity (e.g. virtual views, jobs, users, etc) maintain their own trail and are represented as system tables in the
Querying audit trails
To query those tables, open the SYSLOG schema in the Studio and search for tables including the string
A more detailed description of each table can be found in the documentation.
Many objects also have a “View history” option in their context menu to directly show the audit trail for a given object.
Retention of audit trails
There is a system job periodically cleaning up history tables. The retention period can be configured by opening the jobs tab (), right-clicking on “Clean old histories task” and selecting “Edit job”.