Physical storage cost on daily basis in BigQuery

[kd2709]

Hi,

We have recently moved our billing model from logical to physical.

We want to track storage cost in our BQ projects on daily basis.

by datasets
by tables

I tried using TABLE_STORAGE view and TABLE_STORAGE_USAGE_TIMELINE view.

In table_storage view, it shows me overall storage and billing on monthly basis.
where in usage timeline view , its not a real time and has a lag of 72 hours.

Can someone help to achieve this.