How to calculate each refresh of dashboard with BQ

Hi team,

I am trying to calculate the dashboard cost or I can say how much data dashboard refresh will access from source BQ database.

Source table has 1 GB total data(Last three years data) and each minute brings 3 new records(few byte). We have 12 looks(Table and Line charts).

I want to calculate how much data will be extracted each minute dashboard access. 

on my dashboard, 12 looks are there which is 12 different queries

One each minute, 3 new records will come to source table, so each minute dashboard refresh will access 3 GB+3 new records?

or only 3 records(few bytes) will be extracted?

Point is, I want to know, whenever new data comes on source table and PDT finds new records have come to source table, then it will trigger reload on explore which is based on source table so how much data will be extracted 3 years+3 records or 3 records only?

Thanks in advance

Rohit

0 0 98
0 REPLIES 0
Top Labels in this Space
Top Solution Authors