Previously we had BQ Mate and SuperQuery that are no longer working in new UI to check the cost of query. Is there any free or relatively inexpensive solution that would show cost estimation before running query?
How to see BQ query cost before running it?
1.2k Views Asked by user912830823 At
2
There are 2 best solutions below
0
On
According to the doc
To estimate costs before running a query, you can use one of the following methods:
- Query validator in the Google Cloud console
--dry_runflag in the bq command-line tool dryRun parameter when submitting a query job using the API- The Google Cloud Pricing Calculator
- Client libraries
In your case you have to use the Query validator from BQ Console with Pricing calculator .When you enter any query in BQ console the Query validator validates the query as well as show how much data will be read at runtime.
You have to enter those details in the Pricing Calculator and then you will be able to calculate estimated cost.
Google Cloud Pricing Calculator will be the best option to check cost estimation for any google cloud service
https://cloud.google.com/bigquery/docs/estimate-costs