☰

BigQuery Cost Estimator

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

Autore
Dann Berg
Installazioni giornaliere
0
Installazioni totali
1
Valutazione
0 0 0
Versione
1.7
Creato il
30/01/2025
Aggiornato il
30/01/2025
Dimensione
1,65 KB
Licenza
MIT
Applica a

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 🚀