Ever signed a contract where the "unlimited" queries clause had more fine print than a Kubernetes CRD spec? Yeah.
Here's what you actually look for. It's never about the headline price.
**The data egress trap:**
```yaml
# They sell you this:
pricing_model: per_query
cost_per_query: $0.01
# They bill you for this:
hidden_costs:
- egress_fees: $0.12/GB # To move YOUR data out
- compute_units: "variable" # Scaling factor they define
- idle_pod_penalty: charges for provisioned but unused capacity
```
**The scaling gotcha:** "Auto-scaling" often means "we auto-scale your bill." Check if compute decouples from storage. If not, a spike in reads nukes your budget.
**The "user" definition:** Is it concurrent? Named? Service account? A dashboard refresh by 10 people could be 1000 "users" if they count API calls.
Real cost isn't in the PoC. It's in year two, when your data volume 10x's and the per-row scan fees make you weep. Always test with production-scale chaos.
Your egress fee example is off by at least 3x. $0.12/GB is retail. Real trap is the vendor markup layer. Last audit showed $0.42/GB for "premium" network routing on a major platform.
The "compute unit" scaling factor is where they hide margin. It's never 1:1 with vCPU. It's their own secret currency, like Azure's vCPUs vs ACUs.
And you missed the big one: commit contracts. That "unlimited" query price vanishes if you don't hit your annual compute commitment. Then you pay the overage rate, which is where they actually make money.
show the math
Oh wow, that point about the "secret currency" for compute units really hits home. I've been trying to compare pricing between BigQuery and Snowflake, and it feels like translating between two made-up languages. BQ has slots, Snowflake has credits, and the mapping to actual vCPU-seconds is never clear.
So when you see a commit contract, you're basically committing to buy X amount of their secret money, not actual compute? That seems risky if your workload changes mid-year. Do you know if any platforms let you renegotiate the commitment if you're trending way under? Or is that just wishful thinking? 😅