Snowflake

What differentiates Snowflake from other similar products?

Snowflake is easy to deploy or scale, and since it's all cloud-based, there's nothing stopping anyone interested from using it. The SQL-based approach makes it easy to manage and query data lakes, and the cloud-native setup ensures everything runs smoothly. Therefore, you can count on optimal performance even when dealing with heavy data workloads.

What is your favorite aspect of this product?

Its continued stability, made possible by a well-designed architecture that easily handles massive data demands, is excellent. Additionally, the ability to time travel helps us with data recovery and error debugging. We can send data to monitor the change of SCD and it is failsafe for disaster recovery.

What do you dislike most about this product?

Many open source tools cannot be used natively. Materialized views are limited to a single table.

What recommendations would you give to someone considering this product?

Snowflake is ideal for cloud-based analytical data warehouse type workloads, where the data is large and query access patterns are well established. It can be your common tool for extracting data and creating tables as SQL is a basic and easy-to-use data science language without the need to fully understand the data type.

What differentiates Snowflake from other similar products?

Snowflake scales better than other cloud manager data warehousing tool. The pricing model is separate for compute and object store can be used as storage .

What is your favorite aspect of this product?

Snowflake works well with all the major clouds and snowflake has good offerings for machine learning with offerings like Snowpark ML which allows you to build and deploy ML models.

What do you dislike most about this product?

The snowflake ui is difficult to get used to , the classic console is easier to keep the most used queries right in the front. The cost can be high if data used is very high , this is a challenge where every user is able to query any volume of data and high number of queries are executed every day

What recommendations would you give to someone considering this product?

If your data warehouse consists of data warehouse with preaggregated tables , and you want to build a fast data visulations then using snowflake is one of the best decisions as it will give you very fast performance with keeping the cost also in control as raw data scans will be lower

What differentiates Snowflake from other similar products?

Cloud based data warehousing tool. capable to process huge volume of data and complex calculations. provide features such as safe fail, role based access. Automatically manage all part of data storage process. Easy integration with different BI reporting tools as power BI, Qlik, TCRM etc.

What is your favorite aspect of this product?

Unique capabilities FOR DATA recovery, Safe fail for data recovery. separation of storage and computation. Dynamic scaling of servers,

What do you dislike most about this product?

Unstructured data is not supported, in snowflake, Also data model need to build in optimized way else cost could be even more compare to other tools (Redshift).

What recommendations would you give to someone considering this product?

provide a single platform for datwarehousing, data lake, data engineering.. Able to process huge volume and complex data model. Multiple layers can be created to maintain EDW and ETL layers.