Snowflake Reviews & Product Details

So in our company users were creating databases and warehouses for doing poc and then they do not delete or pause the warehouses that give the higher costing. So we created specific roles and users and one common databases for all so that cost optimization can work and created a dashboard which shows which warehouse using how much credits and we set the default to xs. Review collected by and hosted on G2.com.

So far i dont find any problem now the mfa also enabled for the users so security also no issue Review collected by and hosted on G2.com.

- Simple and Modern UI.

- User management and Provisioning is much simpler once you implment the Single sign on with provisioning functionality.

- Roles and permission management is straight forward, snowflake has detailed documents for priviledges syntex etc.

- Manging databases, schema and it's objects is a breeze (be it via worksheet or via snowflake UI).

- Setting up resource monitor helps a lot to track your credits consumption and get alerts for exhausting credit quota depending on the alerts that you set.

- Dashboard and budget functionality is also there, by which getting insights of credit usage by warehouse, by role, etc. all details are easily available.

-Snowflake supports various Warehouse sizes from Xsmall to 4XL to support you ETL needs, with auto pause and clustering features. Review collected by and hosted on G2.com.

As of now everything is working fine and nothing that I dislike as of now. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

I like that Snowflake is very flexible and scalable. It can handle a lot of data processing and that makes it a highly performant data warehouse. My organization uses Microsoft Power Platform heavily and Snowflake integrates really well with this platform. Encyption of data is the other features that I like. You can do full encryption and configure roles downstream to very the cleartext. Customer support is reliable. If there is something you don't understand they are always ready to explain, clarify or provide hands-on assistance. Security features are very grandular. Review collected by and hosted on G2.com.

Snowflake can be costly. There is also a bit of a learning curve coming from a trade database to a platform like Snowflake. I don't have much dislikes for the product. Review collected by and hosted on G2.com.

The best thing that I like about Snowflake is that we can create number of database,and the feature to include AI in that really help us to integrate and make our work process easier and its very easy in implementation Review collected by and hosted on G2.com.

Sometime the query performace and the new UI feature. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Ease of use snowflake provide is top in the industry. Snowflake provide ease of implementation to implement multiple ideas which evoles around and Snowflake is very easy to integrate with other platforms such as boomi. Review collected by and hosted on G2.com.

Some time customer support did'nt provide me the expected output. Review collected by and hosted on G2.com.

Snowflake is a well designed Intelligent product that is without a doubt the best in its class. The decoupled storage and computer works perfectly, seemlessly and makes scaling simple. The micro clustering was my biggest concerns on day one but frankly it just works. You still need the odd hint here or there but compared to teradata (or high scale postgres) it's very very simple and just works Review collected by and hosted on G2.com.

Unpredictable pricing, No on-premises deployment. They are pushing hard to be more than a database. They want to be a full data science platform, which will be a stretch. Review collected by and hosted on G2.com.

Snowflake is the widely adopted tool in our organisation, as it is interoperable with many of our data sources

It has many plugins which is helpful as we need not call APIs for those

Also for specific purposes, usecases, audiences we could customise our data and create views and provide access accordingly

Identity Access Management also works as intended without glitches Review collected by and hosted on G2.com.

A few things like, when we connect to powerbi the backend working and steps applied is not being visible due to warehouse and role accesses in snowflake

Each time it requires to change role and warehouse which confuses, auto detection option if provided will be helpful Review collected by and hosted on G2.com.