Member-only story
Snowflake — The Shortcomings
This article highlights the limitations, challenges and shortcomings with snowflake technology
Overview
Snowflake is undoubtedly one of the leading data warehouse technologies and provides multiple benefits over its traditional counterparts. I already covered the benefits in one of my articles.
In this article I am going to capture the other side of it — Limitations, challenges and shortcomings of Snowflake.
No On-premise Option
Snowflake is available as a SAAS (Software as a Service) offering, which means we cannot host it on premise. This leads to relatively less control over the implementation.
Though snowflake provides multiple cloud options, the count is just three — AWS, Azure and Google Cloud. If you are on another cloud platform like Alibaba, IBM, or Oracle, you need to think twice. The choice of regions is also limited, as this is tied up to the existing cloud providers.
Infrastructure and Software both are managed by the snowflake itself. This works fine in many ways but limits us in many other ways.
Query optimization is one of such areas. Imagine the traditional ecosystem where the query performance is bad and we plan to fix…
