Snowflake is used to create a data lake, and we have a consumer base where we create data. This data is consumed by different consumers and vendors, who have different needs in how they want to use it. We are from the data engineering side, and we put this data from various source systems in this data lake. We put the data into Snowflake and use connectors to connect to the data lake.
Snowflake AI Data Cloud
SnowflakeExternal reviews
648 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Snowflake an excellent data cloud platform
What do you like best about the product?
Scalability, High Availability , Governance
What do you dislike about the product?
Still needs more flexibility on integrations setup
What problems is the product solving and how is that benefiting you?
Managing enterprise data in a single platform for data analytics
Snowflake: An Innovate Solution
What do you like best about the product?
Snowflake is really great for managing your infraestructure with the benefit to only pay what you are using on the contrary of many other solutions where you need to pay for the whole package even though you don't use many features. Also really easy to get everything up and running.
What do you dislike about the product?
Snowflake offers impressive scalability, nevertheless it can become expensive for companies with large data volumes and intensive use.
What problems is the product solving and how is that benefiting you?
The main problem it solving for me is the unification of the data storage. This tool consolidates all the data into a single accesible location breaking down silos and making it easy to view and understand the data.
Provides good data ingestion capability, but should include more AI capabilities
What is our primary use case?
What is most valuable?
With Snowflake, we don't need any other ETL tool, which is the primary reason I started liking this tool. In addition to the database, Snowflake also provides ingestion capabilities. Currently, we are only using the database because we already have integrations with the IICS. The solution also provides data engineering capabilities, which we can leverage and utilize in the future.
What needs improvement?
The addition of more AI capabilities in Snowflake would help us more.
For how long have I used the solution?
I have been using Snowflake for two years.
What do I think about the stability of the solution?
To the extent I use it, Snowflake is a very stable solution. I did not find any instability with the tool because we primarily use it to create our data lake, and it is available.
What do I think about the scalability of the solution?
Snowflake is a scalable solution. Depending on your needs, you can scale it up or down. I find it quite flexible in terms of scalability. Around 50 users work with Snowflake in my process.
Which solution did I use previously and why did I switch?
I also used Oracle. Snowflake is easier to handle than other solutions and has many things under one umbrella. I like Snowflake's data ingestion capability the most compared to other RDS and database vendors. In other solutions, you would need to design your integration methods separately. However, if you choose, it's not fake. Data ingestion and data lake creation can be easily achievable with Snowflake.
What's my experience with pricing, setup cost, and licensing?
Oracle is less expensive than Snowflake. Snowflake provides better value at a little higher cost in the Snowflake. RDS is cost-effective but has fewer features than Snowflake.
What other advice do I have?
The solution's integration aspect is good, and all the connectors are in place. I found Snowflake similar to RDS. We use it for both data in motion and data in transit. It looks like the tool handles the data quite securely.
We create ETL patterns. We ingest data from different source systems, and we have to create data pipelines. It would be useful if we could have AI features added to identify what I'm going to do with this data. It would be good if it could look at the data and help me create an automated pipeline instead of me creating a pipeline by myself.
I'm from a retail background. I completed my Oracle DBA training a long time ago, about 18 years ago. I was quite familiar with the Snowflake and relational database concepts since I had already completed the Oracle ops, DBA ops, OCP, and OPA courses. For me, it was a journey similar to when I shifted from Oracle RDS to Snowflake. Although I was quite familiar with most of the concepts, there were some learnings.
Whosoever is in the data field should at least try Snowflake once. They will then realize the best features in the solution and can continue using it.
Overall, I rate the solution a seven out of ten.
Generates metrics efficiently, but the integration process needs enhancement
What is most valuable?
The platform's most valuable features include its ability to effectively summarize and manage large datasets, allowing multiple teams to analyze and generate insights. Its integration with data lakes for business impact analysis, performance metrics, and KPIs is particularly important.
What needs improvement?
Improvement is needed in integrating external tools, such as data catalogs, which can be complicated due to differing formats and usage across departments. The goal is to enhance collaboration and streamline workflows.
What do I think about the scalability of the solution?
The product's scalability is crucial for managing petabyte-scale data generated daily across various regions, allowing for efficient data validation and handling.
How was the initial setup?
The primary challenges during the initial setup were the high pricing and uncertainties regarding future costs associated with data usage.
The deployment involved consultation among managers, agreement on on-site requirements, scale calculations, and collaboration with engineers for setup approval.
I rate the process a seven out of ten.
What other advice do I have?
Snowflake is integrated through a complex workflow that involves collecting data on the publisher side, using tools like Airflow and Kafka for batch jobs, and frequently importing data into the product from various sources, including S3 and Data Lakes. It creates a smooth data pipeline.
I rate it a seven out of ten.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Snowflake conference
What do you like best about the product?
New innovation and application. Meta lot of vendors with different ideas
What do you dislike about the product?
Too many products to absorb. Also overlapping sessions.
What problems is the product solving and how is that benefiting you?
Consolidate data from different platforms
Not very flexible at times
What do you like best about the product?
I like how easy and straight forward it is for beginners
What do you dislike about the product?
Wish I could do more inside of snowflake like GitHub prs and would be nice if I permissions would trickle down per schema or databases
What problems is the product solving and how is that benefiting you?
One stop shop for all data
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.
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.
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?
The solution is very good for building data warehouses. However, it has some limitations if we need it for more use cases.
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.
showing 1 - 10