Sweet! Another wrinkle to add in: if you’re comparing a redshift system that’s >$35k/yr, BQ does have a flat rate pricing option which might fare better in your TCO analysis. Info here: https://cloud.google.com/bigquery/pricing#flat_rate_pricing
Yes, I’m a biased cloud Googler.