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
External reviews are not included in the AWS star rating for the product.
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.
easy to parse unstructured data
Snowflake Usecases
SNOWSQL UI
time travel
difficult to integrate other ides
It is very fast and the performance is great but has some technical quirks
What is our primary use case?
I use it for data warehousing. I just design databases, put data in there, and get data out.
What is most valuable?
Although I haven't used it much, it is very fast and the performance is great.
What needs improvement?
It has some technical quirks that whoever is using it needs to be aware of. It doesn't enforce typical relational database constraints. If you're not aware of that, you can really put some bad data in there.
For how long have I used the solution?
I've been using it for about three months.
What do I think about the stability of the solution?
I would give it a ten out of ten. I haven't seen it failover.
What do I think about the scalability of the solution?
I've never had any issues with it. It is being extensively used. We have between a hundred and a thousand users using Snowflake.
How are customer service and support?
I have not had any experience with customer support, but I've heard it's good.
What's my experience with pricing, setup cost, and licensing?
I've heard it's quite expensive.
What other advice do I have?
I would give Snowflake a seven out of ten.
Snowflake is awesome tool
My Snowflake review
Amazing Easy to Scale Product Lacking In Support
Their Data Exchange and Marketplace is top notch as well, giving both easy access to data but also a great ability to share data with others.
User access and management was quite nice with easy SSO setup.
The interface is a little clunky and I know there is a new Snowsight interface but to be honest it isn't even as good as the clunky older interface in my opinion.
Building data products and syndicating them within the marketplace.
Importing 3rd party data assets into our systems.