Snowflake is definitely a great data warehouse as well as BigQuery, the advantage has always been that it can be used across platforms, Goolge has now delivered an option with BigLake to do this as well. But I would say that it depends on the use case, which is really better. I think there are many advantages, especially for companies that use BigQuery and can now also connect cloud platforms such as AWS and Azure more easily and more cheaply.