Did the cost estimate calculator provide an inaccurate estimate?
https://cloud.google.com/bigquery/docs/best-practices-costs
Estimate query costs
BigQuery provides various methods to estimate cost:
Use the query dry run option to estimate costs before running a query using the on-demand pricing model. Calculate the number of bytes processed by various types of query. Get the monthly cost based on projected usage by using the Google Cloud Pricing Calculator.