The solution is primarily used for data warehousing.
Snowflake AI Data Cloud
SnowflakeExternal reviews
660 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Snowflake is an amazing tool with great speeds, scalability, controls different groups and security.
What do you like best about the product?
The speed at which Jira performs is exceptional and surpasses expectations. The pricing is similar to what one would usually pay for a SQL server license or a comparable tool. We have no maintenance responsibilities, and the execution speed for queries and data loading is impressive. Furthermore, Jira showcases remarkable proficiency in handling unstructured data such as JSON arrays or XML, demonstrating its exceptional capabilities.
What do you dislike about the product?
I would like to propose adding a feature called materialized views, which can potentially improve the performance of specific operations. It would be advantageous to have the flexibility of incorporating multiple tables within these materialized views. Furthermore, including cursor functionality would facilitate bulk updates and the execution of more advanced queries. Additionally, a valuable enhancement would be the ability to create tables as required dynamically.
What problems is the product solving and how is that benefiting you?
Snowflake demonstrates exceptional stability and simplicity during the setup process. I found it effortless to activate and establish a dependable Data Warehouse without requiring extensive cloud expertise for administration. The user interface for database administration is intuitive, allowing for efficient management. The dynamic Roles feature greatly assists in implementing robust data governance and compliance practices within the organization
Best Thing For Data On Cloud Era
What do you like best about the product?
its computing speed, timely updates, documentation everything is fantastic. Its unique architecture help us to vanish disadvantages of tradition database tools.
What do you dislike about the product?
I think snowflake is costly if you can't use it properly. So some open guidelines should be provided. The snowflake cost calculator should provide so that customers can take a decision accordingly
What problems is the product solving and how is that benefiting you?
On prem sql server taking 3-4 hour to complete job but same implementation in snowflake takes only 6-8 mins. We don't need to keep DBA team as snowflake is SAAS.
Easy to manage with lots of features and good reliability
What is our primary use case?
What is most valuable?
It's a good tool. It is quite easy to manage.
There are a lot of features.
If you accidentally delete something, you can time travel and retrieve it.
Within half an hour or even 15 minutes, you can set up a new data warehouse, and you can clone a table or whatever you like.
It's easy to provide access to clients if they need to.
The solution is stable.
It can scale well.
There is good online documentation via the community, and you can learn the solution on your own.
What needs improvement?
These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach. That's just a personal choice. I prefer the database views like you would get on an SQL Server or other databases.
For how long have I used the solution?
I've been using the solution for two and a half years or so. I haven't used it for too long.
What do I think about the stability of the solution?
The solution is stable and reliable. There are no bugs or glitches, and it doesn't crash or freeze. I've never had an issue when you connect it to your infrastructure. I'd rate the stability nine out of ten.
What do I think about the scalability of the solution?
We have 250 or more users on the solution currently. They are predominantly IT specialists, including engineers and developers. It's for those on the application side of development. The solution is scalable. I'd rate the scalability nine out of ten.
How are customer service and support?
I've never directly dealt with technical support. We do have a direct contact. There are other people who might have. There might have been a version issue at some point. However, it wasn't something I dealt with. I've only interacted with the Snowflake community pages.
Which solution did I use previously and why did I switch?
We are currently moving everything from Oracle to Snowflake.
We've used a combination of other tools in the past. We've used Microsoft's Stack, for example. We were using a SQL database in the past.
How was the initial setup?
We're migrating from Oracle right now. We have two people that handle the maintenance of the solution. A company may need two to four engineers to manage maintenance 24/7.
It's not difficult to deploy. It's pretty straightforward. It took us only a couple of minutes in order to get everything up and running.
What's my experience with pricing, setup cost, and licensing?
We pay a licensing fee to use the solution. It's paid monthly. My understanding is that it is not that expensive. We might have a specific extra cost surrounding running it on a private cloud. I'd rate the cost as six out of ten. It's moderately priced compared to others on the market. That said, I don't directly manage the account and don't directly deal with pricing. We have a contract of three to five years.
What other advice do I have?
I'm an end-user.
Everything is on the cloud, and therefore I'm always using the latest version of the solution. It updates itself regularly.
It fulfills our needs, and it's easy to pick up by looking at some reference guides. I'm still getting used to the GUI. I might find it even easier to use if I go through more formal training. Right now, I've simply learned it on my own. Overall, I'd rate the solution eight out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Fast and reliable data warehouse
What do you like best about the product?
- etl job are much faster than other services
- UI is simple
- first time user can also navigate easily
- easy to navigate
- multiple option to run jobs according to load.
- UI is simple
- first time user can also navigate easily
- easy to navigate
- multiple option to run jobs according to load.
What do you dislike about the product?
- code maintanence features is not there.
- only support data from cloud location
- tables are managed by snowflake cant be managed by users
- support only 3 cloud currently
- snowflake dont support sub query in a query or in a function
- only support data from cloud location
- tables are managed by snowflake cant be managed by users
- support only 3 cloud currently
- snowflake dont support sub query in a query or in a function
What problems is the product solving and how is that benefiting you?
Its helping to manage data load and data warehousing as its faster and data is quickly available which can then can easily used by business to create visuals/ reoprts
One of the best Cloud Data Platforms to solve all analytic and storage needs
What do you like best about the product?
The best thing about Snowflake is that it is cloud independent and solves the problems for both data warehousing and storage.
What do you dislike about the product?
Snowflake can work on solving edge cases for all the solutions provided by it.
What problems is the product solving and how is that benefiting you?
Snowflake combines data warehousing and Storage into a single product without affecting the performance. It provides faster data retrieval as compared to other open source frameworks like Hive.
Has good stability and processes the data efficiently
What is our primary use case?
We use the solution for data storage and integration purposes.
What is most valuable?
The solution's most valuable feature is path application.
What needs improvement?
They should improve the performance of the solution's transaction application.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
We have 20-30 solution users in our organization.
How are customer service and support?
The solution's customer service is good.
How was the initial setup?
The solution's initial setup was very straightforward.
What's my experience with pricing, setup cost, and licensing?
The price for the solution's license depends on the use cases.
What other advice do I have?
I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.
Snowflake is awesome tool
What do you like best about the product?
Snowflake is very effective in writing the code to pull the data required for analysis. It's quite user friendly, simple and effective. The flow and various options are easy to use.
What do you dislike about the product?
Sometime it's slow and could not handle the load of the system. Could be more efficient.
What problems is the product solving and how is that benefiting you?
I pull the data from the very big data base and it helps me in making the efficient analysis.
Good scalability and has a simple query process
What is our primary use case?
We use the solution to build the pipelines in stream sets, including data source, data warehouse, and destination endpoints.
What is most valuable?
The solution's most valuable features are storage, run time, scalability, and minimum query time compared to other vendors.
What needs improvement?
The solution's stability needs improvement.
For how long have I used the solution?
I have been using the solution for seven or eight months.
What do I think about the stability of the solution?
Recently, I encountered an issue with the solution's data warehouse. The resource monitor had exceeded its quota. I rate its stability as an eight.
What do I think about the scalability of the solution?
I rate the solution's scalability as a nine.
Which other solutions did I evaluate?
We use Hive and Hadoop as well. Snowflake is more stable and scalable.
What other advice do I have?
The solution is more straightforward to use than the other IDBMS tools. It has a simple query process. Its computing time is less as well. One can easily have access to it. I rate it as a nine.
Optimizes costs, works with various clouds, and great dashboards
What is our primary use case?
Data warehousing is typically a rich guys' toy. Large enterprises are only able to leverage data warehouses for data analytics purposes. We wanted to change that and wanted to build a data warehouse template model for businesses across industries.
If Snowflake was not around, we would have used Google's Big Query or Amazon's Redshift, or a MYSQL/Postgres database in a Windows VM (virtual machine). However, Snowflake made it a lot easier for us with loads of features such as encryption of data in motion and at rest, masking policies, time travel (to correct data load issues), controlled access based on roles, data sharing, third-party data from marketplaces, etc.
How has it helped my organization?
It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses.
About ten years ago, force.com from salesforce.com offered a similar platform for us to build data warehouses. However, our staff with a data engineering background found it easier to build the data warehouse in Snowflake, with the easy-to-use SQL interface and RBAC models (role-based access control). The platform saved us money as it automatically shuts down the compute engines after about five minutes of idle time. Per second billing (above the first minute) is great.
What is most valuable?
In my view, cost optimization for the computing power required by the ETL jobs, reports, and dashboards is the most valuable feature. Especially for startups, this helps us to keep cost spending within control without having to worry about manually shutting down the server when not used.
As a Google partner, we like to leverage GCP (Google Cloud Platform). Snowflake supports GCP, AWS & Azure platforms. This works just fine for us. Encryption of data with multiple keys for both data in transit and data at rest gives us enough confidence to use snowflake for our customer 360 solutions.
What needs improvement?
Currently, we use Snowsight only to monitor the usage of the Snowflake environment by our users. However, if Snowsight can be improved, we can host our BI (business intelligence) environment also within Snowflake. In our case, to provide basic reports and dashboards, we started to use Tableau, Power BI, Looker, and Qliksense, depending on our customer preference.
We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model. If Snowflake could guide us with some easy-to-use integration (similar to DBT integration), that would be great.
For how long have I used the solution?
I've used the solution since 2020.
What do I think about the stability of the solution?
Stable
What do I think about the scalability of the solution?
Scalable
How are customer service and support?
Support can be enabled in the Snowflake UI.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
In the past, we used Google Cloud SQL. However, Snowflake offered cost optimization among the many other useful features. They also introduced app building on top of the data hosted.
How was the initial setup?
The initial setup is not difficult. Google Search will lead us to articles that can guide us on the setup of users, roles, warehouses, and access controls.
What about the implementation team?
We did the initial setup on our own, and it was not difficult.
What was our ROI?
We constantly monitor the usage with grafana dashboards to keep the ROI growing and to assist/ alert users about any wastage.
What's my experience with pricing, setup cost, and licensing?
Many interesting features are available only in the enterprise edition. Check out the differences when you are evaluating the product: https://docs.snowflake.com/en/...
Which other solutions did I evaluate?
We considered MySQL and Google Big Query. We're also happy with Google Big Query.
What other advice do I have?
Snowflake is growing with newer features and capabilities. But not much success with Stream lit app. Big query + app sheet is an alternative that we're considering.
Guided use, simplicity and easy to keep on track with your projects
What do you like best about the product?
The databases are easily organized. You can search them on your own. The features allow you to keep an easy track of your projects and because of that you´re able to recicle code and separate your queries according to the project.
What do you dislike about the product?
Sometimes when the query fails you are not told very specifically where the error is being generated. A FAQ section should be included or a section with tips to get started with SF
What problems is the product solving and how is that benefiting you?
Working with relational databases without having to dowload them and work on them in R or Python. Thanks to snowflake I´m able to get just the data I need. It simplifies my job because some of the communications I send extract the most recent data from SF instead of hurrying to upload data.
showing 231 - 240