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.

Snowflake - Best Cloud database you could get to build data warehouse

Kommentare: I would give my over all rating for this product as 10 on 10 . Coming from ORACLE background I really liked this product . You could avoid the entire database management tasks since its been taken care by the snowflake itself.

Vorteile:

The I/O operation within the database are handled well . Repeated same query results are being cached to avoid I/O operations, which is great!

Nachteile:

The Task functionality can have a separate UI to manage the scheduled tasks . The Web workbook could have been improved with more features.

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

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.

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.

Snowflake, Unique just like Us

Kommentare: My overall experience with Snowflake has been a pleasurable one. Though there have been some frustrations at times I have learned and overcome and become a better programmer, and SQL developer for it. I feel like Snowflake is an old friend now.

Vorteile:

The thing that I like most about this software is really if you can think it you can do it with Snowflake. I mean as long as it deals with data. I first started at my company using oracle and I didn't stick with that for long because we adopted snowflake. When we started using snowflake my knowledge of SQL just jumped sky high. Instead of just selecting from tables, I was using cte's and partitions and all of that fun stuff. Snowflake made it super easy to understand and learn. The ability it has to handle the amount of columns that it does is amazing.

Nachteile:

There is a little bit of a learning curve to get the hang of it. But on the surface it is just like any other sql language and you just have to figure out the different quirks that it has. I wish it could give data instantaneously and read my mind on what I want but that is pretty much impossible so I'm going to stick with what I have.

A Promising Solution Marred by Poor Support and Pricing Structure

Kommentare: From the tech support side, some of the engineers did not know the product well. It took several conversations to resolve simple issues.

Vorteile:

The ability to load data in using tools like Alteryx is a major plus. Snowflake also integrated well with our data science platform. The management of users and access was very simple to use and understand.

Nachteile:

Building out incremental loading was difficult and did not save us time in comparison to our incumbent solution. The pricing structure for usage was nebulous. We did not fully understand the pricing model until that renewal period at the end of the year which included fees that were not mentioned during the sales process.

Snowflake review

Vorteile:

I really liked the easy use of snowflake as a SQL coder. It made my work very easy and I liked that there were tutorials and suggested corrections.

Nachteile:

I did not like having to switch between different user roles in order to access certain files, but I think this was because of my company.

Snowflake in AIA

Vorteile:

The ease of using this software. It’s very easy and functional for data work. As a beginner of SQL , you can still smoothly use it.

Nachteile:

I don’t have any complaints about this Software

Snowflake: Good tool in the World of Data Warehousing

Vorteile:

The most impressive aspect of Snowflake is its scalability and performance. It's truly built for the cloud, with a unique architecture that separates compute from storage, allowing each to scale independently. This means you can handle massive amounts of data without worrying about infrastructure or performance degradation. The pay-as-you-go model is also a big plus, as it allows for cost-effective data management.

Nachteile:

While Snowflake offers a lot of advantages, it does have a steep learning curve, especially for those not familiar with SQL or cloud-based systems. The documentation, though extensive, can be overwhelming for beginners. Also, while the pay-as-you-go model is generally a plus, it can lead to unexpected costs if not managed properly.

Snowflake: Modern OLTP DB

Kommentare: Great to have snowflake as out OLTP system. High volume data processing are happening real quick.

Vorteile:

Performance is outstanding. No explicit maintenance is needed. High availability. No need to worry about SQL processing speed, easy scalability.

Nachteile:

Quit expensive while comparing to other database.

Modern warehouse on cloud technology

Kommentare: Overall if I ignore the cost factor, I am very much satisfied with Snowflake and with the features and capabilities it exposes. For a fast growing DataWarehouse, Snowflake is a very good choice as it is secure, robust and scalable.

Vorteile:

Snowflake is very easy to use and can easily connect to different cloud platforms like AWS, GCP and Azure. The fact that it can be hosted on any of these platforms makes it portable and easy to use. The access and security is very flexible and scalable. The fact that storage and compute are separate makes it ideal for use with big data warehouses where usage can be monitored easily and can be charged back ti the appropriate business unit. More and more features are getting added to it which makes it a flexible, scalable data warehouse in cloud.

Nachteile:

The warehouse currently does not support procedural languages and some of the datatypes do not align with some other popular databases which makes it difficult for migration to Snowflake. The cost is little bit on the higher side.

Superior Cloud Warehousing Capability

Kommentare: Snowflake allows us easier access to our data and integration partners are abundant

Vorteile:

Snowflake is an industry leader and has ample connectors to all data sources. They integrate flawlessly with our BI platform and allow for management by a 3rd party. Compute power is FAST and easily scalable.

Nachteile:

Snowflake, like most, has its own dialect for SQL - not necessarily a bad thing but something to adjust to. There is no data cap, so data usage can get expensive.

Great data warehouse software

Vorteile:

Snowflake is being utilized as a data warehousing system based on cans. We're utilizing Snowflake and additional tools like HVR and Dell Boomi to create a data lake. Currently, different business teams are using different systems for reporting and analytics purposes. We're now working on a centralized solution for the entire company.

Nachteile:

Snowflake has its limitation when dealing with unstructured data

Snowflake is a great way to store data

Kommentare: It has been very positive. The primary motivation for the switch is the price and although I wasn't involved in those pricing discussions, it seems that everyone at my company is happy with the price and the value for the price.

Vorteile:

I like that it has a really good interface that is easily accessible. We were using AWS before this and it was really hard to get the connections right. Keeping track of the drivers and everything was really complicated and I never got it to work as seamlessly as Snowflake

Nachteile:

I don't know if there are any data visualizations that I could do in the program. That would be a cool value add. If that feature already exists, then I apologize to Snowflake. Another quirk is that not everything worked in the exact way that I wanted it to. There were some weird syntax things that didn't allow me to directly transfer my AWS queries, I had to go through and change them and there is one query that I still cannot figure out where the translation error is.

Review for Snowflake

Kommentare: Snowflake is very appropriate assuming your association needs to begin little with negligible speculation, and afterward develop at any speed. It is additionally useful for groups that definitely know SQL from chipping away at another stage, like MS SQL Server. It matches all around well with incorporation errands on account of its local capacity to deal with JSON information, for both import and questioning. In the event that your instruments can just associate by JDBC (no local Snowflake connector) you might have a few issues with enormous informational collections. This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about.

Vorteile:

This is a cloud-based application that gives me a safe stage to the simple sharing of information with my customers. I feel sure to associate with my various colleagues as a result of its high level security and successful programming. Through this instrument, I am equipped for incorporating, dissecting, and the whole information in an exact structure and with investigation also, because of which I generally have a straightforward thought regarding the information extraction and its exchange from numerous mists.

Nachteile:

Security jobs and access are difficult to comprehend and oversee Rollout of new components appears to intensely support US West coast, every other person needs to pause Visual interface doesn't permit you to oversee custom capacities and schedules. For those, it is code as it were. The board of tables and perspectives is visual

Snowflake - The next generation cloud data warehouse

Kommentare: It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses could not offer the same. Snowflake can scale both vertically and horizontally to cater all needs.

Vorteile:

Snowflake is very easy to use and scale. It provides helpful features like merge, JSON flattening which are very handy options. Snowflake cloud SQL editor is very fast and helps easy developments.

Nachteile:

It can be a costly solution if optimizations are not planned accordingly.

Totally satisfied from Snowflake

Vorteile:

Configuring the Warehouses can give you endless possibilities.

Nachteile:

There are some implicit casts in data types sometimes that seem to be the default behavior

Best cloud data warehousing solution for all reporting needs.

Vorteile:

We can schedule the data synchronization timelines, and store the data for analytical and reporting purposes.

Nachteile:

I don't find any thing to dislike, it serves the purpose of data warehousing for reporting.

Vipul Chona - Snowflake Review

Vorteile:

very easy to integrate with all our other tools

Nachteile:

Honestly having a tough time coming up with what I like lease. Maybe some of the UI

Transition Extremely Difficult

Kommentare: The ramp up has been difficult. There are a couple key features missing that might overpower the strengths of the software.

Vorteile:

The interface is very attractive, it is extremely fast to query huge datasets, and there is a strong online community of users to learn from.

Nachteile:

I think it has the possibility to be a great software for querying huge databases, but some of the basic uses of that data are hard to come by - it is difficult to interface with Microsoft products.

Best cloud data warehouse as a service available to date

Kommentare: Centralized data.

Vorteile:

Easy setup and configuration. The Ability to scale up and scale down at needed. Pay as you go and only for what you use.

Nachteile:

Limited to AWS currently with planned expansion to Azure and GCP. On-Premise is not an option, but VPC is.

Super Scalable

Vorteile:

My favorite feature in Snowflake is the ease of use provided by SnowSQL. You can create variables in SQL that you reference throughout your queries. It additionally performs super fast and reduces many management needs.

Nachteile:

Snowflake lacks the ability to create stored procedures, this would add a lot of value and ease of use to the software. While the lack of management is great, I find that it may not always be worth the cost for it. In addition to this, it does not perform well (or at all) as an ETL Tool.

Great learning platform for SQL

Kommentare: I am currently learning SQL and my company uses Snowflake. It's been a great learning tool for me to see how all of our data tables are connected and how to get the data I want from each table. We are able to take what we create in Snowflake and then make that a permanent metric in Looker, a fantastic feature to further help with visualization.

Vorteile:

Product is easy to use to go along with a Udemy course I am taking. If making an error in how I input the SQL, it will point out to me where my error was, making it easy to correct.

Nachteile:

So far I don't have any, as I'm still in the learning phase and wouldn't know if any limitations are based on the software, or based on my limited knowledge.