☰

BigQuery Cost Estimator

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

Autor
Dann Berg
Instalaciones diarias
0
Instalaciones totales
1
Calificaciones
0 0 0
Versión
1.7
Creado
30/01/2025
Actualizado
30/01/2025
Tamaño
1.65 KB
Licencia
MIT
Funciona en

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 🚀