the pricing models for bigquery and redshift are different enough that it is hard to compare on price. redshift is fixed cost (hourly per node like ec2) while o

the pricing models for bigquery and redshift are different enough that it is hard to compare on price. redshift is fixed cost (hourly per node like ec2) while on bigquery you pay proportional to data scanned during queries if you do only occaisonal queries on mostly static data bigquery is probably fine but redshift is a fraction of the cost for more frequent use