Snowflake

Snowflake has been a game changer

Kommentare: Snowflake has been a game changer for us. It has enable all kinds of new architectures due to it's fast and low-cost performance. It has eliminated the need for so many maintenance tasks that used to be such a hassle.

Vorteile:

Snowflake is super fast, requires virtually no maintenance (no logs, indexes, tuning, etc.) and the pay per use price model scales perfectly with cyclical workloads which are common in data warehouse applications.

Nachteile:

It does not natively support any real constraints such as uniqueness or referential integrity which requires the user to explicitly check all these things via stored procedures. The SQL worksheet GUI still has remove to improve but they have been rapidly enhancing it. It's not too uncommon to have brief outages but they are usually resolved within a few hours.

Transformed our Data Warehousing Process

Kommentare: Snowflake has been wonderful. It completely transformed our operations when we migrated from SQL Server to Snowflake. It's so much faster, cheaper, and easier to maintain.

Vorteile:

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

Nachteile:

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.

Data Storage, Processing & Analytics Program of All Times

Kommentare: It is effective to store, share, model and analyze data with this program.

Vorteile:

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

Nachteile:

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

How snowflake is different from other data warehouses present in the market.

Kommentare: Used for monitoring large amount and data and also use for analysis purposes for taking business decisions for the companies.

Vorteile:

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.

Nachteile:

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.

A cloud based Data platform

Vorteile:

Ease to access because of its cloud based platform Roles can be easily assigned

Nachteile:

UI when we scroll to the bottom of the results and go to a different worksheet and come back the page displays the top of the results which is very annoying