What do you like best about the product?

Snowflake makes it easy to dive in and start loading, querying, and analyzing your data with minimal setup. Unlike with some competitors ' solutions, there's no infrastructure as code to write. Data sharing is extremely powerful and has virtually eliminated the lift of vendor data integration. Scaling up the warehouse is as easy as a few lines of SQL or a few clicks in the UI.

What do you dislike about the product?

Worksheets are convenient to write SQL quickly, but these quickly get out of hand. Ideally these could be synced with a Git repository so we don't have to reach for DBT.

What problems is the product solving and how is that benefiting you?

Snowflake, through their data exchange and secure data shares, allows us to integrate data from vendors with virtually no integration effort.

What do you like best about the product?

The best part about snowflake is the security and compliance in my opinion. Snowflake being compliant with various security standards such as HIPAA, GDPR and others kinda makes it reliable and secure and moreover considering Snowflake's service of total management where a user doesnt have to worry about infrastructure, management and tuning of the data accordingly.

Time Travel and Cloning is just icing to the high performance and speed snowflake offers. Additionally, Colloboration and secure data sharing makes it so easy for lot of software engineers to collab.

What do you dislike about the product?

The pricing primarily is very unpredictable even though it is cost effective due its scalable features but it can get really expensive when is not montiored properly. Since the users pay for compute time and storage seperately, unexpected spikes in queries, large data ingestion, or poor optimization can result in higher bills. The learning curve for the new users gets complicated in terms of Sql extensions and virtual warehousing sizing because it took me some time to understand the sizing and it was more like a trial and error because it lead me either under provisioning or over provisioning the resources.

What problems is the product solving and how is that benefiting you?

Mainly my understanding is that it is targeted to solve critical problems of data management and analytics specially where large and complex datasets are being handled. There are many scaling issues with on-prem and various cloud based data warehouses. They keep facing issues as the datasets grows which leads to performance bottlenecks and slow query times but snowflake's architecture allowed me to sclae storage and compute resourcres independently which lead to my company paying for onlu what we used which actually benefitted us in the long run.

What do you like best about the product?

Ease of usage
Fast in memory querying
Fast query response
Seamless integration with dbt [data build tool]
Easy to learn and understand
Easy to implement with existing data engineering pipelines and solutions
Support is very fast and effective
can be used across multiple teams concurrently daily

What do you dislike about the product?

Trial period usage is very less, although credits given for trial period is more than enough to develop and tes any usecase but validity is vvery less of 30 days.

What problems is the product solving and how is that benefiting you?

Snowflake is solving our cloud data warehouse needs by giving complete autonomy to developres and business teams. We are using snowflake with dbt [data build tool] for our business modelling. Snowflake best suits with dbt for data modelling. Snowflake solves our access controll and data governance by easy implementation of user groups and roles.

What do you like best about the product?

Snowflake is a cloud-based data warehouse that offers scalability, performance, cost-effectiveness, ease of use, and security. It's designed to handle large datasets and complex analytics workloads.

What do you dislike about the product?

Snowflake's downsides include higher costs for large-scale deployments, vendor lock-in, potential performance limitations, complexity, and limited infrastructure control.

What problems is the product solving and how is that benefiting you?

Snowflake solves scalability, performance, cost, and complexity challenges in data warehousing. This benefits you by enabling faster insights, improved efficiency, reduced costs, enhanced security, and accelerated time to market.

What do you like best about the product?

You can easily scale warehouses based on requirements, saving credit usage. Query profile is a very good feature of snowflake enabling users to get insights where the credits are being used and how to optimise the code. Its is also very easy to implement and navigate the UI.

What do you dislike about the product?

Data migration efforts are large to trasfer everything from on premises to cloud. Machine learning features are also very limited

What problems is the product solving and how is that benefiting you?

I was a data warehouse developer using snowflake and it was very easy for me to learn the concepts and use it. It also makes the entire ETL process easy. Snowflake also has query profile feature which help us to analyse the code and optimise it.