Workload Cost Field Guide

Data warehouse workload inputs: prepare a quote

Send each vendor the same workload. Ask for its own units and terms; these questions don’t calculate a total.

An alert and a spending stop are different

Before you price the workload, check which setting can actually stop it—and which charges remain outside.

Snowflake

What can stop work
A resource monitor can notify, wait for running statements before suspending a standard warehouse, or suspend immediately and cancel statements. SourceYou must configure a suspend action; notification alone leaves the warehouse running. Adaptive Warehouses use disable instead of suspend.
What falls outside the limit
Resource monitors do not control serverless feature costs. Cloud-services costs can continue after a warehouse is suspended. SourceEven immediate suspension can lag and consume additional credits; this is not an exact account-wide spending cap.

BigQuery

Per-query limit
For on-demand queries, maximum bytes billed rejects a query without a query charge when its estimated scan exceeds the limit. SourceClustered-table estimates can exceed the eventual billable scan. The limit controls query bytes, not storage or every other service charge.
Daily and capacity limits
Daily quotas can limit processed bytes per project or user. Capacity reservations cap the available slot count. SourceThe controls apply to different pricing models. LIMIT on a non-clustered table does not reduce the bytes read.

Databricks on AWS

Budget basis and blocking scope
Budgets use USD list prices, including platform add-ons, and exclude negotiated discounts or credits. The documented Block usage action blocks Unity Gateway requests. SourceDo not read a Unity Gateway action as a general SQL warehouse spending cap. Genie has separate budget guidance.
Alert and enforcement delay
Budget emails can arrive up to 24 hours after usage; Unity Gateway alerts are nearer real time. Gateway blocking uses approximate spend and does not interrupt active requests. SourceFinal billed amounts can exceed the threshold. This is not a guaranteed absolute spend cap.
  1. Query volume & bytes scanned: How many queries and bytes will you process? Ask BigQuery to quote the applicable region and on-demand or capacity model; we have not confirmed the region for the saved $6.25/TiB figure. Google BigQuery source
  2. Runtime & start/stop bursts: How long does each run last, and how often does compute restart? Snowflake bills at least 60 seconds on each warehouse start or resume. Snowflake virtual warehouse source
  3. Storage & retained history: How much compressed data and history will you keep? Snowflake storage includes Time Travel and seven-day Fail-safe on permanent tables; temporary and transient tables have different retention. Ask for the storage rate for your region and contract. Snowflake Storage source
  4. Region, cloud & commitment: Ask every vendor which region, cloud and contract length its quote covers. Get any reservation term, minimum spend, renewal and cancellation terms in writing.
  5. Open table format: If you use Iceberg or Delta, ask which catalog and read path apply, and which request or refresh charges remain. Read the format restrictions before accepting a quote. Databricks Delta UniForm source

Compare native billing rows →