<ul><li>total_logical_bytes represents the uncompressed size of data stored in BigQuery before internal compression, used to calculate storage charges based on logical size.</li><li>total_billable_bytes specifies the amount of data scanned/processed by a SQL query, used for calculating query costs under the on-demand pricing model.</li><li>Understanding these metrics is crucial for cost optimization in BigQuery, where storage costs are based on logical bytes stored, while query costs are based on the data processed.</li><li>To view total_logical_bytes and total_billable_bytes for a table, you can execute a SELECT query on INFORMATION_SCHEMA.PARTITIONS for the specific table.</li></ul>

Understanding total_logical_bytes vs total_billable_bytes in BigQuery

Discover more