Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Lightning Fast & instantly Scalable Warehouse
What do you like best about the product?
Snowflake is best for unpredictable workloads or sudden spikes in user queries.
1. Since Compute & storage are decoupled, queries don't get queued for resources.
2. Another killing feature is it has Auto Pause & auto suspend modes which stops consuming credits when no queries are running.
3. Snowflake is an apparent winner compared to AWS Redshift when it comes to maintenance. Almost zero admin tasks everything is taken care of for you. You can either change a warehouse’s size or increase the number of clusters with almost zero downtime seamlessly.
4. As already mentioned it is best in the situations where you get temporary high workloads, so you can increase the compute capacity without increasing storage.
5. Built-in support for Semistructured data like JSON is worth mentioning.
6. Lift & shift from On-prem Relational DW to Snowflake is easy compared to other cloud warehouses.
1. Since Compute & storage are decoupled, queries don't get queued for resources.
2. Another killing feature is it has Auto Pause & auto suspend modes which stops consuming credits when no queries are running.
3. Snowflake is an apparent winner compared to AWS Redshift when it comes to maintenance. Almost zero admin tasks everything is taken care of for you. You can either change a warehouse’s size or increase the number of clusters with almost zero downtime seamlessly.
4. As already mentioned it is best in the situations where you get temporary high workloads, so you can increase the compute capacity without increasing storage.
5. Built-in support for Semistructured data like JSON is worth mentioning.
6. Lift & shift from On-prem Relational DW to Snowflake is easy compared to other cloud warehouses.
What do you dislike about the product?
Complicated Billing. Snowflake’s On-Demand pricing model can be enticing initially, but it can be very unpredictable in the long run, and its cost increases as you go higher. As compared to Snowflake, Redshift has a simple pricing structure based on redshift clusters. Redshift also offers Reserved Instance Pricing, which allows you to unlock 75 percent savings which was the primary driver for switching from Snowflake to ASW redshift for one of our customers.
What problems is the product solving and how is that benefiting you?
Highly scalable Data Warehousing solution which can serve organizations' BI, Analytics & Decision support needs.
Highly useful for unprecedented /workloads which need instant scaling.
Helps quick migration from On-prem relational data warehouse(Oracle) to scalable cloud snowflake warehouse.
Flexibility to choose any public cloud storage be it AWS/Azure or GCP.
Highly useful for unprecedented /workloads which need instant scaling.
Helps quick migration from On-prem relational data warehouse(Oracle) to scalable cloud snowflake warehouse.
Flexibility to choose any public cloud storage be it AWS/Azure or GCP.
Best cloud database service provider
What do you like best about the product?
Easy to understand through user guide. Nice gui. Fast results. Additional feature snowsight is an amazing add on.
What do you dislike about the product?
Every feature i have used so far is great
What problems is the product solving and how is that benefiting you?
Database querying -results are fast
The result table can b directly copied without downloading.
The result table can b directly copied without downloading.
Snowflake: Iconic and Full-featured Data Virtualization Tool
What do you like best about the product?
It is seamless to integrate data from multi-cloud and on-premise repositories.
Automatically prepare, model and visualize data.
Automatically prepare, model and visualize data.
What do you dislike about the product?
I am fully satisfied with Snowflake in terms of features coverage and customization.
What problems is the product solving and how is that benefiting you?
I relish a lot with Snowflake from saving time, finances to unlocking actionable insights on data.
Snowflake is the best interface out there
What do you like best about the product?
Built in geospatial functions in Snowflake, easy way to search the db, easy way to see parsed json in one click before querying, and all around intuitive to use.
What do you dislike about the product?
I don't like if you are working and accidentaly swipe to the left it kicks you back to the login screen. Super annoying. Also, when i work in snowsight to share queries when I save it and try to share with someone else it's still blank.
Also stop trying to push snowsight on users. Snowsight has bugs (memory issues limits on big querys) and hidden stuff (uploading data), I just want a direct log in to the classic console.
Also stop trying to push snowsight on users. Snowsight has bugs (memory issues limits on big querys) and hidden stuff (uploading data), I just want a direct log in to the classic console.
What problems is the product solving and how is that benefiting you?
querying data for adhocs, build pipelines for visuals in Tableau or other products, and keep data organized, help with geospatial queries to identify lat/long within geometries
Recommendations to others considering the product:
Dig in and play around. Use the built in geospatial functions.
Data Warehouse can't be better than this
What do you like best about the product?
- Excellent user interface and navigation features in the web portal.
- Easy to log in via SSO (Single Sign-On)
- Users can create unlimited worksheets and works are auto-saved for future use.
- Easy to run SQL queries just by highlighting the portion to execute.
- On the sidebar, we can find database objects like tables present in the dev/prod database.
- When executing complex queries, you can monitor running performance on each node.
- Another app version called Snowsight is available which also includes all features.
- Easy to log in via SSO (Single Sign-On)
- Users can create unlimited worksheets and works are auto-saved for future use.
- Easy to run SQL queries just by highlighting the portion to execute.
- On the sidebar, we can find database objects like tables present in the dev/prod database.
- When executing complex queries, you can monitor running performance on each node.
- Another app version called Snowsight is available which also includes all features.
What do you dislike about the product?
- Whenever you want to execute a query you have to select it before running.
- Once a worksheet is deleted it's hard to find it back.
- Not easy for fresh eyes. Requires learning or background knowledge before using it.
- It will be really good to have a one-liner description pop-up when we hover a mouse on any button in UI.
- Once a worksheet is deleted it's hard to find it back.
- Not easy for fresh eyes. Requires learning or background knowledge before using it.
- It will be really good to have a one-liner description pop-up when we hover a mouse on any button in UI.
What problems is the product solving and how is that benefiting you?
I am using Snowflake for collecting logs and stats data from customers cluster. For the development and testing I prefer to use dev version and for publishing final data we use Prod version and create tables to store/query on data. The SQL query also supports all operations which I use to filter the results and store the output on aws for sharing with team. Depending on the role of user, we can set their limitation to acces the prob db tables and data.
Strategic Finance Manager
What do you like best about the product?
Easy usage for non-data savvy users and readers
What do you dislike about the product?
The setup is not as straightforward as the usage
What problems is the product solving and how is that benefiting you?
Using SQL to analyze financial and customer data
Best Data Warehouse Tool
What do you like best about the product?
Snowflake is the best data warehousing tool in the market it gets all the features as one connects to any cloud Environment like AWS, Azure or GCP to store its data plus the virtual warehouse is pretty fast and its internal micro partitioning feature is also pretty handy.
What do you dislike about the product?
As it is pretty new to the market there are very few documentation or training to learn this tool also they can add new cloud environment like oracle cloud to the snowflake.
What problems is the product solving and how is that benefiting you?
We do all the ETL stuff with snowflake and now using snowflake we can easily migrate our existing project to any cloud environment. it is very cot effective supports all the major clouds one connects to multiple languages using different connectors are all of the benefits of a snowflake.
Recommendations to others considering the product:
just go for it
The Best Product in Cloud Warehouse market
What do you like best about the product?
Everything about it is amazing. It is super fast, computes queries so fast. Can get you more than 6 million rows in less than 5 seconds.
It has the feature of time traveling which lets you go back to a previous stage of your data and it is very helpful.
Since it has the storage and compute separated, it lets you query in a very fast way and maintains different warehouses.
Is very cost-effective as well.
It handles so many things together, handles the security of the data also in the best way.
One should just go for the migration to Cloud and should choose Snowflake
It has the feature of time traveling which lets you go back to a previous stage of your data and it is very helpful.
Since it has the storage and compute separated, it lets you query in a very fast way and maintains different warehouses.
Is very cost-effective as well.
It handles so many things together, handles the security of the data also in the best way.
One should just go for the migration to Cloud and should choose Snowflake
What do you dislike about the product?
I haven't come across anything till now which I dislike about the product. Although it does not seem to handle unstructured data as of now but seems like it will be included in the future. If that will also be covered, other than semi-structured and structured, it'll be simply awesome!
What problems is the product solving and how is that benefiting you?
We migrated the data from DB2 to Snowflake as we wanted easier deployments, better security and wanted to move to the cloud for higher performance and cost-effectiveness as well. Snowflake fulfilled everything we were aiming for.
Recommendations to others considering the product:
Just go for it. If you do decide to move to Cloud, Snowflake is simply amazing!
High-powered, feature rich, cloud data warehouse enabling all kinds of new possibilities
What do you like best about the product?
I like the power and capability of Snowflake, as well as its aesthetic user interface. It's not only a database - with SQL and all you'd expect there - but it also provides tremendous functionality for sharing and controlling access. We've made row-access policies, for instance, to even let clients into their data and only their data. I like the concept of roles which allow us to easily specific access levels to specific pieces of data, I like how we can visualise items from a query within the console, and many, many other things. In short, working in Snowflake is quite pleasant and enjoyable with a great user interface.
What do you dislike about the product?
I wish the worksheet editor allowed us to search and replace - it seems a little basic this is missing.
I also wish the product would make warehouse recommendations - for clarity, Snowflake pricing is based on the warehouse you use for your work, with a warehouse essentially being CPU, RAM, etc. So, an extra small warehouse is the lowest amount of compute power and, correspondingly, the lowest price. Yet, it's possible for some newcomers to inadvertently run their work in (say) a large warehouse when this costs more money. Or, conversely, maybe we're too worried about cost and we're causing a complex query to take excessive time to run. It'd be nice if Snowflake itself gave some advice around queries - e.g. you run it, and it says "hey, if you did this on a small warehouse it would have taken only 0.2ms longer but would have been cheaper" or "this query took 25s to run. If you used an XL warehouse it would have completed in under 2s" or something like that.
It'd also be nice if Snowflake SQL supported string concatenation with the + symbol like T-SQL.
I also wish the product would make warehouse recommendations - for clarity, Snowflake pricing is based on the warehouse you use for your work, with a warehouse essentially being CPU, RAM, etc. So, an extra small warehouse is the lowest amount of compute power and, correspondingly, the lowest price. Yet, it's possible for some newcomers to inadvertently run their work in (say) a large warehouse when this costs more money. Or, conversely, maybe we're too worried about cost and we're causing a complex query to take excessive time to run. It'd be nice if Snowflake itself gave some advice around queries - e.g. you run it, and it says "hey, if you did this on a small warehouse it would have taken only 0.2ms longer but would have been cheaper" or "this query took 25s to run. If you used an XL warehouse it would have completed in under 2s" or something like that.
It'd also be nice if Snowflake SQL supported string concatenation with the + symbol like T-SQL.
What problems is the product solving and how is that benefiting you?
We're using Snowflake as a cloud-based data warehouse to aggregate data across all our many diverse databases and products. We have applications using AWS and Azure, with databases in SQL Server, MySQL, and others, and with some apps using multi-tenanted databases and others using one database-per customer. We have thousands of databases across products and clouds and DBMS engines - so ingesting all our relevant data (for reporting purposes) into Snowflake allows us to make awesome reports in one place, for all customers, across all products.
Snowflake or Nothing
What do you like best about the product?
It could churn through data so fast, which is nice in a data warehouse tool. I wasn't the only one either in our company there were probably 20 analysts or more doing simlar things to what I was doing and it rarely missed a beat.
What do you dislike about the product?
The thing that I didn't like about it was the fact that the only interface that we had to interact with it with was online. There were other ways but they were build directly from snowflake.
What problems is the product solving and how is that benefiting you?
Being able to pull a ton of data, and check results so that we can publish the data to our BI Tool. This is used for reporting purposes to see how the company was doing.
showing 141 - 150