We are starting to report from our GCP BQ instance and, as such, have some stringent audit requirement hurdles to overcome.  The first is auditing users who have access to add, update or delete tables, channels, etc.  Currently, that appears to be within the HVR_EVENT table within the EV_BODY column - this is JSON data.  If we change/add/modify access we would have to compare previous entries for this column based on the ev_type column.  

This is doable, however, very clumsy for something as simple as auditing access to the application.

Adding more complexity, there is no easy way to report on a compare job that was run against a channel.  As we leverage BigQuery, row-wise refresh is not a feasible option.  We need a way to provide this information to our business partners in a meaningful way.  Currently, this would require one of 2 options:

1.   Grant read-only access to the users that would need to see the data.  While this would work, on channels with hundreds of tables, the information is not presented in a meaningful way for decision making.  Each table would need to be evaluated individually
2. The way we are going to do it for now, write a report based on HVR_EVENT and HVR_EVENT_RESULT.  Again, this is "fine" in the fact that we can get the data, it would be significantly easier if we could just generate a report and send it to the users who would like to see the information.  They would let us know what tables to refresh based on that information.

Overall - any reporting for access, changes made to channels (via table/column addition or removal) or newly added or deleted channels; along with a method to provide information for users not defined access to HVR would be highly appreciated.