ToM Report Series on Data Warehouse – A Snowflake and Synapse comparison
This white paper is directed at decision makers and data architects who are thinking about implementing a cloud data warehouse solution. It presents the result of a detailed comparison between two large products in this space, Snowflake and Microsoft Synapse (formerly known as Azure SQL Data Warehouse).
This comparison has been done both using on-paper evaluations and hands-on-keyboards physical testing of functions, providing a strong argument for why Snowflake is currently (March 2020) a better option in most cases. In the paper contains a grading matrix where each evaluation area is summarized for an overall score for each solution.