Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Snowflake On Demand - Standard

Snowflake | 12.04

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

497 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Information Technology and Services

Snowflake - Speed on the Cloud!

  • November 20, 2019
  • Review verified by G2

What do you like best about the product?
Snowflake is a database and a storage warehouse on the cloud. Since it's scalable on demand, retrieving data through Snowflake Warehouses is lighting fast. All the computing power required to run the SQL queries are taken care by the Warehouse size we choose. If a query is taking too long to run a quick switch to a bigger warehouse does wonders. Migrating and loading data into Snowflake is a breeze too via Snowflake Stages and COPY TO commands.
What do you dislike about the product?
Snowflake doesn't enforce constraints, especially primary keys. So, care should be taken while doing INSERTs and UPSERTs to maintain data integrity. This lack of this feature is understandable since it's projected more as a storage warehouse.
What problems is the product solving and how is that benefiting you?
Maintaining on-premise database systems is expensive and maintenance heavy. Moving to a cloud database like Snowflake cuts down costs and is easy to maintain also. Since Snowflake supports a variety of flat file formats as sources, it becomes easier to bulk load data as flat files in storage spaces like AWS S3. Migrating data from cloud storage to Snowflake becomes much more easier.
Recommendations to others considering the product:
Companies with on-premise database systems moving to Snowflake cloud database is a no-brainer.
Snowflake has command line tools which help in rapid data loading. Snowflake supports multiple data sources and various flat file types.


    Marcia g.

Store massive quantities of data with Snowflake

  • November 11, 2019
  • Review provided by G2

What do you like best about the product?
Snowflake has some rugged archive features that make it run easily. It makes reporting questions run on our production environments for a relatively short time. Also, Snowflake comes with a DBA feature that's very helpful for maintenance tasks of a project, such as patches and constant updates. It is easy to customize and it makes operating loads easy to handle from online stores.
What do you dislike about the product?
In Snowflake, questions don't get a limit size, since the computer power grows with the search volume, implying that we have greatly increased the things that we can check into.
What problems is the product solving and how is that benefiting you?
Snowflake is an ideal way to store massive quantities of data. It offers us all the valuable tools and strong features in the most common secure data processing system, as it gives us the capability to increase or decrease the storage date based on the workload. For the portal and the user interface reports, Snowflake has allowed us to make some good progress, generally with the responses.
Recommendations to others considering the product:
I would recommend Snowflake for any company that needs a key instrument for evaluating the experimental workload. There are other possibilities for evaluating quantitative and real-time procedures, but Snowflake is definitely one of the best in the market right now, as it offers a great expenditure, which is crucial in how productively the database server will be used. Also, the Data Warehouse as a Service concept by Snowflake eliminates management optimization activity typically undertaken by programmers.


    Brady A.

Snowflake: a great substitute to Redshift

  • November 06, 2019
  • Review provided by G2

What do you like best about the product?
Snowflake has an interesting architecture that embraces structured and semi-structured data, as it offers ready-to-use applications that include semi-structured data like JSON, ORC, and XML. This will allows you to concentrate more on information management rather than regression testing with the designed-in database engine. The interface is more similar to the other SQL query structures which I have used and is pretty easy to use since there's a way to see connection entre the tables efficiently. It allows us to solves many market issues, from the delivery of our products through to the payment process.
What do you dislike about the product?
In rather complicated queries, the hit times are quite high. Although SSIS is linked to the ODBC, retrieving information from the snowflake can be a bit sluggish. Also, the correlated sub-queries are not supported.
What problems is the product solving and how is that benefiting you?
A couple of years ago, Snowflake was deployed in my company as a substitute to Redshift for the SQL level, which enables us to query data. Snowflake is used as a tool for storing data in the most common data browsers in Standard SQL language. It makes easy processing and computer removal of resources, easy expansion, and reduction with simulated stores while keeping a safe data transfer, something no other suppliers offer with instant funds and auto-balancing.
Recommendations to others considering the product:
If you need a highly scalable cloud-based storage system, then Snowflake will be the perfect tool for you. It will enable software engineers to concentrate more on the technical assignments that will traduce in the growth of your


    Eliza R.

The main web-based data center is Snowflake

  • November 05, 2019
  • Review provided by G2

What do you like best about the product?
Snowflake offers a great virtual storage space, providing workload, virtual storage and a great general usability. It allows our team to take the initial MS SQL document query from the OLTP databases, transform it into a Snowflake SQL format and operate in seconds or minutes the same request on Snowflake.
What do you dislike about the product?
In several respects, it is required to use SQL language varies from Redshift, so your team must have some knowledge about it. Also, it often shows some syntax issues and, if you contact the customer support, they are usually pretty slow. Snowflake really needs to improve their technical help for client-identified mistakes.
What problems is the product solving and how is that benefiting you?
Snowflake is the main web-based data center for my company. It deals with the need to merge diverse sources of data in one data source and to identify ideas of our business in an easier way than with other platforms. The Snowflake server is operated by the IT staff, so they take care of occurred views to automate search storage and load.
Recommendations to others considering the product:
Snowflake is the perfect tool for data warehouse. It is specially suitable if you need a huge number of data fragments, as it's able to offer more reliable data exposure and fast queries, which ensure the data can be accessed much more easily. While the benefits and drawbacks of optimizing the efficiency of similar cloud data storage systems are not fully realized by Snowflake. In general, snowflake is less likely to mean knobs and leakage with configuration.


    Sherri W.

World-class database quality with Snowflake

  • October 31, 2019
  • Review provided by G2

What do you like best about the product?
When we have all the various data sources in a database warehouse, Snowflake allows us to start looking for connections between both the data sources and the multiple business units. We do this in order to connect all our data quick and effectively. The main cloud architecture provides straightforward integration with many other cloud-centered technology tools, including storage duplication brokers. Also, it comes with very clear documents to support.
What do you dislike about the product?
The internet front-end is all very well, but if they could add back-end GUI it will boost the Snowflake service even more. Also, when many applications are concurrently in the performance, the probability of lose data rises.
What problems is the product solving and how is that benefiting you?
Snowflake is used in the IT department of our business for Dataware, as it is currently the main requirement of our organization. We use this as the primary data base for all of our SaaS product's, as well as to make internal analysis and ad-hoc application analysis. It provides world-class database quality and the ability to easily query data for themselves and to produce reports in a short amount of time, making it way better than any other conventional digital storage solution.
Recommendations to others considering the product:
Snowflake is a great tool for storage of statistical information. If your company works from the SQL environment or uses a cloud storage service, Snowflake will be a great fit for you. However, you must consider its price, as Snowflake is generally more expensive than other technologies.


    Debera R.

Collect data about various aspects of the company with Snowflake

  • October 25, 2019
  • Review provided by G2

What do you like best about the product?
With a really efficient database system, it allows us to spend little time collecting information regarding our data and providing real results without the criteria to build and manage databases, instead of wasting time handling and preserving the solution. Also, it allows us to see when a client has been identified, if an item has been ordered, when it has been demanded and what are the most efficient processes to enhanced our products.
What do you dislike about the product?
in Snowflake popular table expressions are not supported. We take full advantage of encryption, however we feel there is room for growth here. It is also not often easier to comprehend the error messages, particularly if transient tables are added, all of which is supposed to be done with a new database.
What problems is the product solving and how is that benefiting you?
Snowflake enables us to proactively consult our information to collect data about various aspects of the company and the actions of our users. We can also test JSON quickly by copying the S3 cubes using Snowpipe without requiring transformation. Also, we use it to improve engine knowledge, as it allows researchers to collect information that may be unable to access.
Recommendations to others considering the product:
The Snowflake system is an excellent tool because large quantities of information are processed quickly. It is very efficient for companies that want to get automated balancing on major searches, so you just charge for the resources you really use. However, I would not recommend it for any form of output approach for OLTP.


    Matt L.

A big step forward for data warehouses

  • October 08, 2019
  • Review verified by G2

What do you like best about the product?
The auto scaling functionality, and instant flex-ability with 0 down time are amazing. Their query profiler and reliability is also the best we have found. The ability to share data with read only accounts is also very useful to us.
What do you dislike about the product?
A few issues with the .Net ODBC connector around timeouts of long running queries.
What problems is the product solving and how is that benefiting you?
We are utilizing Snowflake to load and report on data for several hundred enterprise customers using our software.
Recommendations to others considering the product:
Auto-scaling warehouses are the way of the future, if not snowflake, make sure the provider you use is auto-scaling.


    Accounting

Its used in the FA for inquiring data and other analytical financial related work

  • October 03, 2019
  • Review provided by G2

What do you like best about the product?
Being fresher in the SQL it guide us how to use the snowflake , eventually month of time help me inquiring data from DB and quite easy to connect any DB to extract financial details for further working.
What do you dislike about the product?
As of now not identified major dislike , but like to highlight for the improvements , were we start coding it as show pop like google next character or symbol to be used, so it will more helpful for beginner.
What problems is the product solving and how is that benefiting you?
by creating schma , we can load the data and extract any time of past details which has very strong analytical background will create for taking financial decision
Recommendations to others considering the product:
yes for small industry were not able to effort SAP/Oracle an all they can easily adopt this software


    Rakesh K.

Snowflake is Faster & Reliable

  • October 01, 2019
  • Review verified by G2

What do you like best about the product?
It takes almost no time to provide the result, The results show us Faster than Instant Noodles.
What do you dislike about the product?
Nothing as of now. The user experience is really good that I don't find any negative experience to share with, Hoping this will continue to work like this.
Just wanted to continue with Snowflake until we find any error in it, The Snowflake team, for now, all seems good if there is any requirement when the team contacts them they provide a proper solution within a short period of time that.

My SQL was so slow if we awere working them prodivicity was going down as uploading in that & Querying was a very bad experience since the team was looking for a better solution after a lot of analyzing the team figure out Snowflake will be the best option for an organization like Swiggy
What problems is the product solving and how is that benefiting you?
Pulling the data through a query in MySql was giving a very bad end result we were waiting for more as that was taking more time to pull, however, this has helped us to save time, As in the corporate world Time this Cost to company.
Recommendations to others considering the product:
If the COmpany is looking for cutting down waiting time through Query or uploading the data faster to provide a hassle-free end-user result then this is the best solution for the Company.

Data synchronization is also faster than other tool.


    Food & Beverages

SDM-snowflake data Management

  • September 27, 2019
  • Review verified by G2

What do you like best about the product?
the best thing about snowflake is it uses smaller disk space and easy to implement in work space and it offer better data quality with good structure and it consists schema is in logical model and also it is web support one can access with minimum internet anywhere any time.
What do you dislike about the product?
snowflake is having few dislike as well one is complexity to source query joins,and limitations in data export you can extract up to certain MB,Real time refreshing is required and having single table dimensions.
What problems is the product solving and how is that benefiting you?
it helps to solve the business problem and could data management will help perform a better reporting and proper structured of puling data via query to save manpower and timely work getting done it will helps to every organisations for a balanced data management.