Snowflake

Friendly Cloud Data Warehousing

Kommentare: Very good and reliable tool. I am very satisfied.

Vorteile:

Snowflake is easy to use and clear. Maybe the hardest part is to set up Roles and Policies. Overall, I think it is the easiest data warehousing in the market and works very well.

Nachteile:

It is kind of expensive and sometimes I feel I am getting "over billed". With this I mean that some operations take extra computing time that is not really needed or there are hidden costs difficult to track. To know how much money are you spending is difficult and overall I feel like Snowflake does not want you to track billing that much.

The incredible power of a cloud data platform

Kommentare: We use Snowflake to aggregate hundreds and hundreds of disparate databases across many different clouds and platforms into one single data warehouse allowing us, for the first time, to give customers visibility of all their data across all our products.

Vorteile:

The concept of Snowflake is so clever - mass amounts of micro-partitions of data, with the storage and compute separated. It is a smart product that enables so much functionality and capability. It is more than simply a database in the cloud, it is truly a feature-rich platform that offers a huge amount of functionality. I also very much like that role-based access is a fundamental part of it. Its data sharing features are terrific too.

Nachteile:

Some things are a little tricky to figure out, like row-level policies the first time you do it, or data masking. There are no triggers. Scheduled tasks are a little limited. Stored procedures are not as simple as I'd like.

A great example of a data warehouse solution

Vorteile:

I love how straightforward and performant the solution was

Nachteile:

Data visualisation was a little lacking, meaning you had to tether to a system like Google Data Studio or Sigma/Tableau to make sense of the data

Snowflake has been a game changer

Kommentare: Snowflake has been a game changer for us. It has enable all kinds of new architectures due to it's fast and low-cost performance. It has eliminated the need for so many maintenance tasks that used to be such a hassle.

Vorteile:

Snowflake is super fast, requires virtually no maintenance (no logs, indexes, tuning, etc.) and the pay per use price model scales perfectly with cyclical workloads which are common in data warehouse applications.

Nachteile:

It does not natively support any real constraints such as uniqueness or referential integrity which requires the user to explicitly check all these things via stored procedures. The SQL worksheet GUI still has remove to improve but they have been rapidly enhancing it. It's not too uncommon to have brief outages but they are usually resolved within a few hours.

A fantastic data warehouse solution that solved all our problems

Kommentare: I have an amazing experience using Snowflake. It is better than out previous Data Warehouse solution in everything I can think of (besides pricing). We are very satisfied with, and I feel very confident on having it as the backend of all our data needs.
It is also important to notice that we had a very pleasent experience with Snowflake's sales and account managers: they were very helpful and not pushy at all.

Vorteile:

Snowflake is exteremely stable and easy to setup. I was able to turn it on and have a reliable Data Warehouse that didn't require me having a lot of cloud knowledge to administrate. The database administration through the UI is intuitive and the Roles dynamic helps with implementing good data governance and compliance pratics inside the company. Snowflake also offers user security options out of the box, which was a huge improvement for us. The doccumentation is very well written and SnowSQL offest a lot of useful functions. The main improvement on this front was how Snowflake treats JSON, which helped us a lot.

Nachteile:

If your revenue is not on US dollars, Snowflake is an expensive product, there is no way around that. It is indeed a very good service that charges accordingly. We are using the smallest cluster possible and it was necessary to do some convincing inside the company to approve it for our budget. That being said, the smallest cluster we are using is more than enough for our needs and will be for a long time, so it will take a long time for this cost to increase again, but it was a pretty big budget increase initially.