BigQuery vs Redshift

While the former is free of cost as long as a shared slot pool is used, the latter is billed on usage at $ per 200MB of data

Flexibility: Flex slots allow users to dynamically increase or decrease their BigQuery resources as needed This pricing option is ideal for

bigquery slot reservation Standard $ $ - Per Slot Hour Low-cost option for standard SQL analysis; Capped at 1,600 slots per reservation; Max 5 reservations per admin; %

bigquery slot pricing On July 5, 2023, Google will begin migration of existing flat-rate and flex slots to the new BigQuery editions See below for the default