Snowflake Reseñas y detalles del producto

I like that Snowflake uses a mix of novel solutions and tried and true foundations to deliver a product that they say they deliver. The main thing is the ease of use, and the speed of use.

I guess my only critique would be that I didn't fully understand how it worked when we first started using it and therefore was not able to use it to it's full power. Maybe I wasn't privy to those convos?

We are solving major ETL problems and data governance/organizational issues. In addition we are able to make apps work faster than we ever could have otherwise.

integrated to AWS and low maintenance from client side. performance

when I search on google, not much information I can get from snowflake questions

warehouse, report

Beats Redshift in performance and cost. The in-time snapshot to roll back data to a previous state is also pretty incredible. The data storage costs is very low in comparison to Redshift and the computational speed far exceeds what Redshift can handle. DUO push as a two step authentication is a bonus.

Extra fees for security and vpc. Not really a big fan of paying roughly 30-50% more for AWS VPC routing. Also there might be a need for more support hours since databases can be used 24/7 downtime can occur anytime. During a regional, but not national Holiday, most of the company was out and there wasn't any method to contact support team besides leaving a phone number and waiting it out.

Data Analysis, Big Data. Parallel queries. Reaped benefits in roughly 1/3 the cost of Redshift and in significantly improved query times.

I like the speed at which you can accomplish a task that is assigned to you by using the variety of tools provided by Snowflake.

I only dislike the fact that tables with constraints are not enforced particularly with a primary key.

We are solving Data Visualization problems and Snowflake excels at this due to its speed. The viz needs to interact with the underlying data table very quickly and we had great success with Snowflake. We are also solving ETL pipelines. We have seen Snowflake churn through TB's of data in a couple minutes which is pretty awesome and not possible with any other solution to date.

That's the fastest and the most agile DB I ever worked with. I also deeply appreciate scale-ability as you can always throw in more computational power if you need so without any hassle

Some queries are not optimized as you'd expect them to be, that leads to you writing some workarounds which work "kind of" the way you wanted them to be. Sometimes support team resolves problems, but sometimes they reply something like "it's the way it works, deal with it". I also wish the query details\profile screen was easier accessible from worksheets: the UI is sort of slow in switching from worksheet to query details and if you do that as one off - it's not a biggie, but as you do it more often - that becomes a hassle as UI getting laggy and works slow.

Big data analysis and pre-computations, kpis became easier with Snowflake. We were able to achieve our tasks of serving data in the way our customers need, with all metrics they need fast enough so they are happy

Snowflake has the best balance between price and computing power. Redshift tiers are expensive on either storage or computing, snowflake provides best of both worlds

The ecosystem is somewhat immature - you have to figure out the best ETL/data infrastructure around Snowflake

Reporting - we have massive amounts of data and using SQL our front end tool (Tableau) is getting bogged down

We have taken over all of the DBA management for our warehouse(s) without additional resources. This is because we don't have very many maintenance or configuration tasks (or issues).

Have a more robust stored procedure features will be great.

Reducing maintenance of our data warehouses (building indexes, restarting servers, etc) Meeting SLAs by moving from nightly batch processing to near-real-time micro-batching (15-30 mins). Product stability and improved performance Reducing cost

Snowflake's flexibility in the data warehouse space is amazing. The scalability and price can't be beat! Plus, I have an amazing Account Exec, Chris Li, that is always passionate about providing the best value.

I would love to see smart text when drafting SQL.

In the process of developing an Enterprise Data Warehouse (EDW). We've made a lot of progress and our internal customers can run queries that are extremely fast making it easier for them to make key decisions.

Snowflake just works! No crazy complexity required to fine tune the system, no complex spreading of data across nodes, partitioning, indexing, configuation etc. Need a separate 'box' for heavy duty BI queries? Spin one up instantly! Need a bigger resource for a big ETL job, again spin one up instantaneously and shut it down when it's done - per second billing means you don't pay for resources you don't need. You can really tell a lot of thought has gone into a complete redesign - it hasn't been 'stretched' for the cloud, but 'built' for the cloud

Nothing really! The organisation is growing rapidly, so they don't necessarily have the customer suppot teams outside of Europe. Some functions are WIP e.g. additional windowing functions, recursion.

Snowflake is acting as a data lake/warehouse for my organisation, which alleviates the need to have eg Hadoop for storage and an RDBMS for presentation. One platform makes it so much simpler.

The performance, its support for semi-structured data and the Acid back-bone. It is like having Hadoop with Transactions and fine role-base security. Data Sharing is also new to the database world. We can now share any data with our Clients without additional burden.

It would be nice to be able to self-manage the fail-safe. For instance tables from the fail-safe should be removed explicitely so no storage is vasted.

Big Data Healthcare Analytics