Active Logical Storage

[sharontmathew]

I have a gcp account and the active logical storage cost has increased from the last 3 days, even though I don't made much changes from  corresponding to the volume of data.
What is the potential cause for this sudden spike.

[kolban · Accepted solution]

Here is a link to an article on BigQuery storage.  If your cost for active logical storage has increased then one must imagine that your utilization of such storage has also increased.  There is a BigQuery table called INFORMATION_SCHEMA.TABLE_STORAGE_USAGE_TIMELINE_BY_ORGANIZATION (ref) that contains data for your historic consumption on a daily basis.  You might want to examine this table and see how your storage has changed day by day. 

[shubham21feb]

Hi @kolban ,Thanks for the above answers. It helped a lot in understanding the ways to calculate the storage cost.

I can not get the access on Table_Storage and Table_Storage_usage_Timeline as both of the table are available at region level not available at dataset level. Can you please suggest if there is any other way to get the cost with the help of Information_Schema tables.