CODEWITHSUNDEEP
google-bigquery
Mikhail Berlyant
Mikhail Berlyant

Reputation: 173038

BigQuery Classic UI fails to show estimated cost and always shows "This query will process 0 B when run."

I noticed this issue - can be quite bad for users if they don't check size of querying table(s) by their own.

No matter how really heavy query in terms of bytes to be processed - I see below

enter image description here

Looks like this feature is broken on Classic UI since recently. What can I do?

Note: not really programmatic question but I thought critical enough to expose this hopefully temporary issue to users

Upvotes: 0

Views: 588

Answers (2)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173038

The best option you have is to either use BigQuery New UI (I double checked and this is not broken there) or to use third party tools like Potens.io as an example

Update :

This was fixed and now estimated bytes and respective cost is available in Classic UI

enter image description here

enter image description here

Upvotes: 0

Pratik Patil
Pratik Patil

Reputation: 832

Try bigquery-mate chrome browser plugin: https://chrome.google.com/webstore/detail/bigquery-mate/nepgdloeceldecnoaaegljlichnfognh?hl=en-US

Or even a better solution for your org: https://potens.io/products/#goliath

Upvotes: 1

Related Questions