LinkedIn
Twitter
We have internally created reports for showing GCP billing information to be accessed in the company, with the data source being logicals views in BigQuery.
This report only need to be updated in a daily basis. Due to the cache ttl limitation, we set it to
However, we saw obvious increase of cost due to this report. And after investigating, I found the report data refreshes (from the bottom left of report) more often than we expected.
I read from https://cloud.google.com/looker/docs/studio/manage-data-freshness?visit_id=638851604252009554-121089... and learned that it could happen due to various reasons.
But I still can't explain the finding during my test:
1. I open the report for the first time, noted down the refresh date at the time I opened it. After 1 hour, I opened it again, the refresh date got updated to a new time. -> I thought without clicking button to refresh, it should not be refreshed with my 12-hours setting.
I was not applied any filters so not trying to change the queries.
Another question is: in my understanding the data in report is in memory and it should be served to all users who try to access the same report. Why didn't I see an old date (when report auto refresh) when I firstly time access it?
All in all, we want to control the cost to minimum for such reports.
