Answer the question
In order to leave comments, you need to log in
How to track table usage in BigQuery?
Hello, the essence of the question is this:
BigQuery has a data warehouse, analysts build their views for work, and to reduce costs, these views are daily distilled into static tables, which are subsequently cached during queries and reduce traffic.
Based on these tables, dashboards were built in Data Studio.
And this is where the weirdness starts. When opening a dashboard, it executes all the queries that are written in it, in theory they end up in the BigQuery logs - in the audit tables and in the Query History (cached or not, it doesn't matter), but I ran into such a problem - the same built dashboard when opened by one person, it does not write absolutely anything to the logs, and when opened by another, it logs all executed requests.
There is an option that when updating the table, the whole thing is cached, but then it is strange that for some they are logged, but for others they are not.
Perhaps there are some other ways to track if there are table accesses or not? Or are these logs saved somewhere else?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question