What pricing does this tool use?

Default rates are BigQuery $6.25/TB (on-demand), Snowflake $2.00/TB (virtual warehouse estimate), and Redshift Spectrum $5.00/TB. You can override the rate with your actual contract price.

Does BigQuery charge for queries under 1 TB?

BigQuery has a free tier of 1 TB of query data processed per month. This estimator shows the raw per-query cost; subtract your remaining free-tier allowance manually.

Why does Snowflake pricing differ from the default?

Snowflake charges by compute credits (virtual warehouse time) rather than bytes scanned. The default $2.00/TB is a rough heuristic. Override the rate with your cluster's effective cost per TB for a more accurate estimate.

How do I find how much data my query scans?

In BigQuery, run a dry run or check the query validator — it shows bytes processed before execution. In Snowflake, query QUERY_HISTORY after execution. In Redshift, check SVL_S3QUERY or the query plan's "rows" and "bytes" columns.

Are these estimates exact?

No — they are order-of-magnitude estimates. Actual charges depend on caching, partitioning, clustering, compressed storage format, and platform-specific billing rules. Always verify with your cloud console.

Query Cost Estimator

Name: Query Cost Estimator
Availability: InStock
Author: Nham Vu

Estimate your BigQuery, Snowflake, or Redshift query cost by entering the amount of data scanned.

Query Parameters

Platform

Data Scanned

Price per TB (USD)

Number of Queries

Run the same query multiple times? Adjust this to see total cost.

Enter query parameters and click Estimate Cost to see results.

Copied!

Summary

Estimate your BigQuery, Snowflake, or Redshift query cost by entering the amount of data scanned.

How it works

Select your cloud data warehouse platform (BigQuery, Snowflake, or Redshift Spectrum).
Enter the amount of data your query scans, then choose the unit (GB or TB).
Optionally adjust the per-TB price if your account has custom pricing.
The estimator converts the scanned size to terabytes and multiplies by the per-TB rate.
Review the cost breakdown and copy the result for budgeting or reporting.

Use cases

Estimate BigQuery costs before running an expensive analytical query.
Compare query costs across BigQuery, Snowflake, and Redshift to choose the cheapest platform.
Budget monthly data warehouse spend based on expected query volume.
Justify query optimization efforts by showing potential cost savings.
Teach team members about the financial impact of scanning large datasets.
Quickly check if a proposed query fits within a project cost limit.

Frequently Asked Questions

Related tools

Sql Minifier Json Formatter Uuid Generator

Last updated: 2026-05-29 · Reviewed by Nham Vu