I am wanting to use the Looker System Activity models in our own model in LookML in order to combine it with other sources, but wondering if this is possible.
Specifically, one example of what I am trying to do is that I've got the BigQuery InfoSchema jobs pushing into Looker and that contains the labels on each job of Looker user id used. So I can see the BigQuery metrics by the Looker User ID, but I want to join this to the actual Looker metadata in order to pull back the Name of the Looker User ID.
This is just one example, and I may also want to try and do other things that could enrich the BigQuery data with the Looker metadata.
Are there some view names that I can use in my BigQuery explore, that connect to that backend Looker system activity data?
Solved! Go to Solution.
also me, seems it was removed.
Here's another solution I just found too! https://medium.com/plum-fintech/linking-looker-activity-with-bigquery-costs-d0aef48a082f