An excellent, accessible data warehouse solution
What do you like best about the product?
The ease of access and useability of the web UI, but also the integration with Mode Analytics.
What do you dislike about the product?
Confusing SQL coding syntax differences.
What problems is the product solving and how is that benefiting you?
We have data from many different source systems and Snowflake provides us an easily accessible warehouse to organize the data within.
Structured and user friendly experience using SQL for efficient data handling.
What do you like best about the product?
The structured database approach and the tab on the left side reflect the exact table or database you are working on.
What do you dislike about the product?
Each time you refresh the page, previous queries get lost.
What problems is the product solving and how is that benefiting you?
Snowflake provides an interactive platform for database management systems, an easier and more efficient way of using SQL.
Easy to manage with lots of features and good reliability
What is our primary use case?
The solution is primarily used for data warehousing.
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.
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
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
Enjoy using snowflake but wish it was better
What do you like best about the product?
I like the overall interface of snowflake. I like the layout and it's easy to use. I love that it auto populates certain syntax words. I also love the query search feature.
What do you dislike about the product?
I don't like when someone shares a sheet with you , you aren't allowed to move it to another folder or stop sharing it.
What problems is the product solving and how is that benefiting you?
I'm using it to query data
great data organizer for BI and data science
What do you like best about the product?
can manage big data very efficiently and easily
What do you dislike about the product?
sometime the data transfer can be little slow
What problems is the product solving and how is that benefiting you?
Helps store and analysis of big data in companies
Best Data Warehouse Tool
What do you like best about the product?
Snowflake's engineering depends on a cloud-based information distribution center that isolates processing assets from capacity. This considers versatility and flexibility, permitting clients to add or eliminate assets on a case-by-case basis to meet changing information needs. Moreover, Snowflake has inherent help for different information arrangements and information types, including organized and semi-organized information.
What do you dislike about the product?
There are couple of things I could do without about the snowflake is it's doesn't uphold unstructured information stacking it's just help the design and semi structure information. Furthermore, other one is it's just help the mass stacking records so it's hard for a little size documents stacking or including exactly couple of segments it.
What problems is the product solving and how is that benefiting you?
One of the vital highlights of Snowflake is its capacity to deal with huge volumes of information while keeping up with quick execution. This is accomplished through its protected multi-cluster shared data architecture design, which considers equal handling of inquiries across numerous groups. Snowflake likewise offers worked in security highlights, including encryption and access control, to safeguard delicate information.
Very good support with any troubles I had.
What do you like best about the product?
Customer support. One of the reps was/is responsive when helping me upload the data.
What do you dislike about the product?
It could be somewhat easier to use for a person who isn't experienced in such.
What problems is the product solving and how is that benefiting you?
Matching our data services with potential clients and storing said data.
Snowflake review
What do you like best about the product?
It is very fast to query data. It has lots of integrations.
What do you dislike about the product?
The ability to save worksheets could be better. The syntax is a little confusing.
What problems is the product solving and how is that benefiting you?
data storage
Snowflake and it's integration with other tools like Clari, Salesforce & Tableau
What do you like best about the product?
Snowflake is a DB , where I can have all the relevant data in the form of tables at one place, and it not only allows me to write SQL in an efficient way to analyze data, but it has additional features like - intelligent suggestion, saving queries as worksheets, which I like the most. On top of that it's easy to integrate tools like salesforce, tableau and clari with it.
What do you dislike about the product?
Though it's one of the best RDBMS out there, but it doesn't allow to have code blocks in single worksheet, and hence if I'm having 2 or more SQL statements in same worksheet, and I've to run one of them, I have to select whole query and press run, if we would have option to have code blocks, it would be more easier.
What problems is the product solving and how is that benefiting you?
Snowflake is one stop solution to store and analyze the data. If one is good with SQL, then snowflake allows us to get deep insights for sales and marketing performance of the organization.