so in other words we could replace snowflake/bigquery with this solution and get pretty much the same performance?
it depends... but yes, you could likely set it up in a way that matches (or beats) snowflake performance.