(Disclaimer : I use BigQuery for a personal project and it is virtually free for smaller workload, at work we use SQL Server as a Data Store, I will try my best to be objective ) TL:DR ; Run TPCH-SF100 benchmark (base table 600 million rows) to understand how different Engine Behave in this workload … Continue reading Benchmarking , Snowflake, Databricks , Synapse , BigQuery, Redshift , Trino , DuckDB and Hyper using TPCH-SF100