Snowflake

Avantages

Ability to read automatically from CSV/Json, wide variety of connectors and ease of setup are some best features

Inconvénients

I haven't disliked anything yet, best part is company working on this regularly to improve

Avantages

Ease of use, reliability, speed of new feature roll-out, general quality of product.

Inconvénients

Certain use cases are more difficult when it is not part of the "walled garden" approach. Cost can be high if not configured correctly.

Alternatives envisagées 

Pourquoi choisir Snowflake 

Logiciel antérieur 

Pourquoi passer à Snowflake

Avantages

The best thing is snowflake is a cloud based Warehouse system.and it’s completely based on shares nothing architecture so its gives faster performance during analysis.one more thing i like about this warehouse that the amount of time that you use the main warehouse here for that specific period of time you have to pay other than the warehouse is off for normal queries.particularly in dml statement mainly its uses the warehouse.so its manage automatically weather to use warehouse or not so it is very much good for saving money That’s why now big giants company are shifting towards snowflake for cost effective purposes and the smarter and faster performance it gives.and it also provides a feature call time travel where you can back up your all deleted data in a period of 90 days.

Inconvénients

There are two things I don’t like about the snowflake is it’s doesn’t support unstructured data loading it’s only support the structure and semi structure data. And other one is it’s only support the bulk loading files so it’s difficult for a small size files loading or adding some few columns on it.

Avantages

Great data warehouse system with a robust SQL application. Easy to use for any data solutions needed!

Inconvénients

I feel like sometimes the links I save don't get me exactly to the query that I want to use, but I can easily search it in the application.

Avantages

Easy maintenance, fast performance, low cost usage-based pricing model, and easy data sharing.

Inconvénients

It can be cumbersome to administer multiple Snowflake accounts within the same company if needed. It's most cost effective for large, bulk type query transactions not thousands of small queries spread throughout the day.

Alternatives envisagées 

Pourquoi choisir Snowflake 

Logiciel antérieur 

Pourquoi passer à Snowflake

Avantages

Snowflake data warehousing capabilities are robust which makes it easy to store and analyze data in real-time.

Inconvénients

Snowflake does not have on-premise solution for tracking data status.

Avantages

Easy and intuitive interface. All you need to do is type SQL. Python is also available.

Inconvénients

There was nothing particularly bad about it.

Avantages

1. Exceptional design on dashboard and easy controls
2. No maintenance (Logs, Tuning etc) required
3. Pay per use model

Inconvénients

1. Expensive indeed
2. UI navigation needs to improve
3. Should be more flexible for integrations

Avantages

Security it offers for the workspace to import the data that we want

Inconvénients

The pricing is fairly high and few technical glitches while shifting workspace from private to public domain.

Avantages

Easy to store your queries and with some guide non te hnical user can easy navigate

Inconvénients

This software js great and i donot think there is any issue

Avantages

It is feature packed and easy to use. Terraform package is well managed hence giving team access to IaC.

Granular RBAC provides a lot of opportunity for customisation and security governance.

Inconvénients

Bill is costly if warehouse cost is not monitored and alerts are not set.

Avantages

I love how you can setup aour dashboards, it is critical for us to have appropriate data

Inconvénients

The software is very complex so onboarding tutorials would have helped.

Avantages

The feature I like the most in snowflake is it's ease of use and excellent support.

Inconvénients

Sometimes the response time of portal increases which anyone hates.
Understanding the data-structures is not always easy.

Avantages

The computation power and storage capacity in decoupled (pay for what you want)
it provides a good query history and query analysis feature,
and also query metadata help's us in understanding the performance issues if any
the support team responds quick and good,
they have a good web UI workbench to work on and it auto stores our work,
the provide a snowflake outage dashboard which can show the down time of snowflake if any

Inconvénients

some syntax's are different from psql, could have been the same so that the migrations wold have been easier
the web UI workbench is bit slow in initial page load time,
some times we face some issues not frequently , but the support team tries to resolve it immediately,
and the support team notifies us if there are any known outages that are about to happen

Avantages

The "Time Travel" aspect of Snowflake, being able to pick a point in time and see the state/contents of nearly any table is astonishing. Very useful and impressive feature.

What is equally as impressive is the overall performance of the platform. I've worked with Oracle, DB2, MySQL, Vertica, Teradata, ParAccel, and others. Maybe not always in the most optimal configurations, but Snowflake's performance has been overall the best in my experience.

Inconvénients

As a newer platform, there are certain convenience elements that Snowflake lacks.

- No auto-complete of object names.
- No "easy" import wizard to import data.
- Some bugs with the browser-based interface (worksheets did not properly save).
- Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large.

Avantages

This is a cloud database and warehousing service, the syntax of snowflake is like psql,

they have a good community support and good documentations for all the queries,

they are faster than traditional databases, and the are charged separately for compute power and the storage space , which makes it usable in a flexible cost effective manor,

good support team, always respond and try to resolve the issues if any was reported, and also helped us identify any cost saving scope

Inconvénients

The System esoterically shows outage, these type of outages are informed to use by the support team, and they resolve it quickly,

a minute potion of the syntax of sql is slightly different from psql, which makes it hard to migrate the application from different psql service providers

Avantages

High PerformanceSecuredEncryption and Data Masking FeaturesMany new SQL Functions

Inconvénients

Client Tool to Query Data needs to be improved

Avantages

Snowflake's Worksheets interface is easy for SQL novices to figure out because it's simple and straightforward, which is exactly the opposite of many competitors. On other platforms, novices are easily intimidated because of the complexity, but Snowflake does a great job of keeping it simple and clean. Their documentation is also good, but it's not as novice-friendly as I would like.

Inconvénients

Script error messages could be more specific and helpful with identifying errors and troubleshooting. For example, linking directly to the relevant section of their documentation, based on the type of error. Again, this is something that advanced users probably wouldn't mind too much, but for novice or even intermediate users, this can be the difference between spending a few minutes troubleshooting versus hours of head-scratching.

Avantages

Processing is very fast, as someone who switched over from Microsoft Sql server this works very fast and has the same documentation.
The documentation library is also very helpful and the forums are always readily available to compare commands from SSMS vs Snowflake

Inconvénients

It doesn't let you customize column order after the results have been generated.
It also downloads a csv everytime you want see the output which just creates more work.

Avantages

We use Snowflake to capture some of our larger third party data exports that won't fit into Google Sheets. The process of uploading data is straightforward and keeps our business reporting streamlined despite lean engineering resources on our end.

There is a SQL interface to make modifications to data before final exports and data viz.

Inconvénients

The UI is clunky and not the most intuitive. The error messages could be more detailed and expanded.

The support for Mac seems to be more limited. Encountered issues with data produced via Mac and support took months to fully resolve.

Avantages

Snowflake is incredibly flexible and versatile. There are numerous ways to get data into Snowflake, even if there is not already an API built out for the source. The tool has many pre-built integrations as well.

Inconvénients

Though it is very flexible, one thing that Snowflake does not handle is unstructured data. This can be a problem if your sources heavily rely on this type of data. They say they are going to support it in the future, but as of right now, they do not.

Avantages

It's fast. It's simple. It's scalable. And best of all, we saved forty percent from switching off of redshift.

Inconvénients

You can't connect easily from a sql editor outside of their browser or the command line. That makes it less convenient.

Avantages

Snowflake is a FAST alternative to a software like microsoft sql server. The data is well organized in the cloud, which allows you to pull from it quickly. SQL queries that used to take 20 minutes now only take 10 seconds. The interface is user-friendly and looks great.

Inconvénients

There are a couple of nuances that you need to know when you start using Snowflake. If you have someone to help you learn the few things that are unique about writing code with snowflake, you won't have a problem.

Avantages

The way snowflake supports integration with multiple data sources has made data migration very easy.
The time travel feature lets you move to the previous stage of the data it has helped me a lot in many situations. Most importantly the service is very cost-effective and runs very fast in any browser.

Inconvénients

There are no negatives I have noted till now all the features are top-notch up to the industry mark.

Avantages

Web UI
Virtual Warehouses
Secure Product
Auto-Scaling
S3 integration
Public Cloud Hosting
Forward thinking vendor

Inconvénients

Would be good if there was a RESTful API interface with ability to query tables returning JSON format