We would like to add a hook before DB queries as fired against our DB (ideally when user navigates to the embedded Dashboard) - the use case is that we want to provide a Dashboard with tiles that display Staff Commission data, but this data is not stored in the DB, but instead is calculated “on the fly” - calculation logic is quite complex + there is a number of situations that lead to the commission values invalidation, hence performing those calculations in the background is not optimal from our point of view. Is there a way to plug in our own code to be executed before data is queried by Looker?
LinkedIn
Twitter
