IT Central Station is now PeerSpot: Here's why

Snowflake Pros

SreenivasanRamanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Decision Minds
Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake.
View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant
Time travel is one feature that really helps us out.
View full review »
TB
director of business operations at a logistics company with 51-200 employees
It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well.
View full review »
Buyer's Guide
Snowflake
July 2022
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,645 professionals have used our research since 2012.
VP
Solution Architect at a wholesaler/distributor with 10,001+ employees
The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business.
View full review »
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a computer software company with 10,001+ employees
The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure.
View full review »
Mauricio Ruiz Falcón - PeerSpot reviewer
Senior Information Management Architect at Raken
The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.
View full review »
CD
Data Architect at a tech services company with 201-500 employees
It was relatively easy to use, and it was easy for people to convert to it.
View full review »
ES
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees
The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do.
View full review »
AN
Senior Data Engineer at a financial services firm with 10,001+ employees
The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer.
View full review »
CR
Director Consultoria at tecnoscala consulting
Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.
View full review »

Snowflake Cons

SreenivasanRamanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Decision Minds
Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues.
View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant
The solution could use a little bit more UI.
View full review »
VP
Solution Architect at a wholesaler/distributor with 10,001+ employees
They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that.
View full review »
Buyer's Guide
Snowflake
July 2022
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,645 professionals have used our research since 2012.
TB
director of business operations at a logistics company with 51-200 employees
An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly.
View full review »
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a computer software company with 10,001+ employees
There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was.
View full review »
Mauricio Ruiz Falcón - PeerSpot reviewer
Senior Information Management Architect at Raken
It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.
View full review »
CD
Data Architect at a tech services company with 201-500 employees
The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL.
View full review »
ES
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees
Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market.
View full review »
VG
Senior Vice President at a tech services company with 201-500 employees
It's difficult to know how to size everything correctly.
View full review »
AN
Senior Data Engineer at a financial services firm with 10,001+ employees
Their UiPath, the workspace area, needs some work.
View full review »
Buyer's Guide
Snowflake
July 2022
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,645 professionals have used our research since 2012.