The solution is very good for building data warehouses. However, it has some limitations if we need it for more use cases.
Snowflake AI Data Cloud
SnowflakeExternal reviews
660 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Good for SQL developer
What do you like best about the product?
Most of SQL syntax is matching with Snowflake, processing is very fast. easy to handle.
What do you dislike about the product?
its bit costly difficult to manage multiple warehouses
What problems is the product solving and how is that benefiting you?
Snowflake can hold large volume of data and data i/o process is very fast.
Data Heros Platform
What do you like best about the product?
Best Web UI, and connection drivers for all programming languange and feature of SNOWPARK
What do you dislike about the product?
Snowflake ML modules need much better documentation and simple integration
What problems is the product solving and how is that benefiting you?
The Retail Transcation analysis, able to perform huge data analysis
Snowflake Makes It Easy
What do you like best about the product?
Data sharing within our organization is simplified with Snowflake. It's fast and it has everything we need to make our jobs easier.
What do you dislike about the product?
It's expensive but when you need an enterprise solution, you pay an enterprise price.
What problems is the product solving and how is that benefiting you?
Getting all our data in one location
Scalable Data Store
What do you like best about the product?
Scalability and their willingness to innovate as a company.
What do you dislike about the product?
I'd like to have more options for automation and scheduling. I also find that getting data into Snowflake tends to be challenging for new data sources.
What problems is the product solving and how is that benefiting you?
Centralizing data and normalizing access. It also allows us to scale our data processing quickly when needed.
Snowflake Just Works
What do you like best about the product?
Snowflake does a lot to remove the time consuming aspects of DB adminstration and management and streamlines a lot of its functionality eliminating developer overhead.
What do you dislike about the product?
Cost management and querying metadata can quickly become cumbersome without soliod forethought and planning
What problems is the product solving and how is that benefiting you?
Reducing silos and overhead from managing multiple SQL Servers. Creating a unified Data Warehouse.
A Data Warehousing Tool For All
What do you like best about the product?
Snowflake is one of the best data warehouse tool out there. It is super easy to use, so gone are the days of menotinous DBA tasks needing to be done. The pricing model is based on pay-for-what-you-use and is very cost efficient. You have total control over how much compute power you use, with incredible scalability. Every query can use a different size compute engine if you want! In addition, they have built in stored procedures, triggers, events, etc to make ELT easier. They also have a service called SnowPipe which allows you to easily create real-time streaming from common storage locations such as S3 and Azure Blob.
What do you dislike about the product?
The new GUI is still difficult to get used to. It used to be much cleaner/simpler of an interface but along with more and more capabilities, you sometimes need to have more and more complex interface. With all that said however, you don't have to use the GUI. Everything you can do in the GUI can be done in any ODBC/JDBC compliant data tool you like to use.
What problems is the product solving and how is that benefiting you?
Snowflake is the perfect tool for having a powerhouse data warehouse that is strong enough for fortune 50 companies to use, yet simple enough for anyone with minimal data warehousing experience.
The product enables users to import data quickly from different sources, but exporting data to third-party solutions is difficult
What is our primary use case?
What is most valuable?
All the features of the product that are needed for the data warehouse are good. The solution enables the ingestion of data and the usability of preferred languages while creating the data. The performance of the engine is good. The solution speeds up the process of onboarding. We can connect to different sources and get the data very fast.
The tool does a very good job in reporting and data transformation. We can adapt it well to our needs. When we try to ingest data from many sources, it helps harmonize the data sources. It also helps with duplication and cleaning of the data. It is a pretty difficult and time-consuming task, and Snowflake helps us with it.
What needs improvement?
I do not like the proprietary format of the solution. Getting data out of the tool to third-party applications is difficult. The data science workloads must be improved. Snowflake has a lot to learn. There are better options in the market for data science.
For how long have I used the solution?
I have been using the solution for almost three years.
What do I think about the stability of the solution?
The tool is stable. I rate the stability a nine or ten out of ten.
What do I think about the scalability of the solution?
If we need to scale up, it will impact our costs. I work in a consulting company. We have a department dedicated to Snowflake. We have seven to eight people on our team. Our clients were medium-sized businesses with 1000 employees. They are focused on data analytics solutions. They also have departments for Azure and AWS. I rate the tool’s scalability a seven or eight out of ten.
How was the initial setup?
I rate the ease of setup a seven or eight out of ten. The tool is deployed on the cloud. The time taken for deployment depends on the workload and how we build it.
What's my experience with pricing, setup cost, and licensing?
The solution is expensive. I rate the pricing a nine out of ten.
What other advice do I have?
We are partners. The impact of the solution’s automatic scaling feature on the workload depends on how we build our workload. The vendor must take a look at the market and how technologies evolve. The solution can do more in the area of distributed systems. If our use cases require data scientists, I rate the tool a three or four out of ten. I rate the tool a nine or ten out of ten for SQL data warehouse use cases. Overall, I rate the product a seven out of ten.
The product is fast and easy to use, but it is expensive compared to other products in the market
What is our primary use case?
We use the solution extensively for reporting and analytics. We put data into it and publish reports. A report could be a dashboard. The data is used for data-driven insights and AI and MLOps. There are many use cases for the data that we procure on Snowflake.
How has it helped my organization?
The product has impacted collaboration across our teams. The correlation is quite easy. We use the solution because most of our life sciences and healthcare customers prefer it. Their preferences directly impact us as vendors and partners. We have to promote the same tools and technology they are familiar with.
What is most valuable?
The product is quite fast. There are several connectors in Snowflake that we could leverage for ingesting data. The data could be in zettabytes or petabytes. It is easily manageable.
What needs improvement?
The cost is a bit high. The storage cost and the extraction cost of data are high. The final invoicing cost will be higher if we do a rich data-oriented task on Snowflake.
For how long have I used the solution?
I have been using the solution for close to three years.
What do I think about the stability of the solution?
The tool is stable and very powerful.
What do I think about the scalability of the solution?
We have at least 1000 users in our organization. We will surely use the product in the future.
How was the initial setup?
The solution is cloud-based. There is no on-premise solution. It has its own cloud. The installation is quite easy.
What was our ROI?
The solution is worth the money. It is good to use. It has a lot of features which are not available in other products. However, users must explore other products to control their costs.
What's my experience with pricing, setup cost, and licensing?
Other products like Google Cloud, AWS, and Azure have competitive pricing. Snowflake costs 15 to 20% more than AWS and Microsoft Azure.
What other advice do I have?
People who want to buy the product must initially use the free trial version. It can be installed on a desktop. The user can do a lot of R&D. We have a good playground. We can play with the components and learn them easily. We can learn how each component talks to each other, how the performance is, and how to create tables. There are a ton of tasks we can do.
After ingesting the data, we can perform advanced analytics and make models. The end users can do many things on the tool. It is quite an easy tool. I will advise any new user to install a free version. They will be able to learn about the product and get good insights when they work on their pilot project. Overall, I rate the tool a seven out of ten.
A scalable and cost-effective solution that stores data streamed from the source system
What is our primary use case?
We use Snowflake as a database to store all the data we stream from the source system.
What is most valuable?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power. If I want to change the computation with other tools like Netezza, I would have to add a hard disk to it. With Snowflake, being on the AWS side, changing warehouses provides me with faster execution of my queries.
What needs improvement?
The real-time streaming feature is limited with Snowflake and could be improved.
Currently, Snowflake doesn't support unstructured data. With Snowflake, you need to be very particular about the type of data in your source systems. It has to be in a proper structure. You cannot push data to Snowflake in any possible way.
For how long have I used the solution?
I have been using Snowflake for a couple of years.
What do I think about the stability of the solution?
Snowflake is a stable solution.
What do I think about the scalability of the solution?
Around 400 users are using the solution in our organization.
Which solution did I use previously and why did I switch?
We previously used IBM Netezza. We switched to Snowflake in 2020 because it provided us control over its scalability and costing model.
How was the initial setup?
The solution’s initial setup is comparatively easier.
What was our ROI?
Snowflake is a cloud-based, scalable solution that provides strong data security. Handling all the data is much easier in Snowflake, and it has a very nice interface to control user access. The administration of Snowflake is also comparatively easier.
What's my experience with pricing, setup cost, and licensing?
Snowflake is a cost-effective solution.
What other advice do I have?
Choosing Snowflake completely depends on the quantum of data your organization has and the requirements. Snowflake is suitable for someone looking for a scalable and cost-effective solution that provides quick analysis.
Overall, I rate Snowflake a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
The best DataWarehouse
What do you like best about the product?
the integration is rellly easy and the sql querying supported by snowflake make it really great for analyzing data. I use it daily for identifying data insights.
What do you dislike about the product?
i think the pricing can be thought as many of the new users are small scale IT companies.
What problems is the product solving and how is that benefiting you?
Getting all the insights from the data
showing 181 - 190