Don't know enough about Vertex AI, SageMaker is great though. But on BigQuery v Redshift: Having used both over many years, BigQuery is the clear winner. It's a much better, much more modern product.
BigQuery is also a central part of GCP, with almost all services having integrations to it (PubSub, CloudSQL, Bigtable, etc). It also seems to get a lot of resources and is continuously improved. That is not the case for Redshift, which is not as important to AWS.
BigQuery is also a central part of GCP, with almost all services having integrations to it (PubSub, CloudSQL, Bigtable, etc). It also seems to get a lot of resources and is continuously improved. That is not the case for Redshift, which is not as important to AWS.