Bigquery has a cool function like this where it will tell you the cost of the query before you run it.