☰

BigQuery Cost Estimator

Dynamically replace BigQuery's query size estimate (GB) with the estimated cost in USD.

Author
Dann Berg
Daily installs
0
Total installs
1
Ratings
0 0 0
Version
1.7
Created
2025-01-30
Updated
2025-01-30
Size
1.65 KB
License
MIT
Applies to

BigQuery Cost Estimator

This script dynamically replaces BigQuery’s "This query will process X GB when run" text with an estimated cost based on Google’s on-demand pricing ($6.25 per TB).

✅ Features

  • 🚀 Works dynamically as you type queries.
  • 🔍 Uses MutationObserver to detect changes.
  • ⚡ No external dependencies; lightweight and fast.

💡 How to Use

  1. Install a Userscript Manager:
  2. Click "Install" on this script.
  3. Open Google BigQuery and enter a query.
  4. The estimated cost will replace the GB value automatically.

📌 Example Calculation:

Query processes: 11.37 GB
Cost = (11.37 GB ÷ 1024) × 6.25
Cost = $0.07

BigQuery now displays:

"Estimated cost: $0.07"

📜 License

This script is licensed under the MIT License – feel free to use, modify, and contribute!

💡 Questions or Issues? Report an issue 🚀