We are doing a cost analysis for BigQuery Storage pricing. Do you have a sample computation to see the cost for Logical and Physical pricing model. We are also interested to know the pros and cons for using either of them. Thank you in advance.
I would suggest a read of the following:
- Storage pricing
- Storage billing models
- Forecasting storage billing
- TABLE_STORAGE_USAGE_TIMELINE_BY_ORGANIZATION view
This is the core of the underlying information. From here, we would want to map to your specific consumption models and which permutations may work out better for you. Remember it may not be ALL one or the other. You can specify a billing model on a per dataset level.