When I was in my previous company I have been using this tool. The best part about Snowflake is that the storage and compute are completely separate. In my daily workflow, this means our data science team can run massive, heavy queries at the exact same time our business analysts are running their daily dashboards, and absolutely nothing slows down. I also love the Zero-Copy Cloning feature. It lets me create a replica of our production data for testing in just a few seconds without wasting time or storage costs. Review collected by and hosted on G2.com.

While the auto-scaling is great, you have to be really careful with setting up warehouse timeouts. If an analyst accidentally leaves a massive virtual warehouse running or sets the auto-suspend time too high, it can rack up unexpected compute costs very quickly. It requires strict monitoring. Review collected by and hosted on G2.com.

Snowflake is a really useful cloud data warehouse that has been improving over time. Recently, it improved its AI capabilities, which makes it much better to work with and, in my case, reduced query development time by about 10x. It has also helped with Python code development. I recently built a solid process to automate work using SQL and Python in a notebook, and it’s working great. Review collected by and hosted on G2.com.

Snowflake’s integrations with other platforms have improved. In their most recent comments on X (Twitter) about two weeks ago, they mentioned an upcoming integration with Salesforce that would let you take actions directly from Snowflake. I’m looking forward to that, but as of now it still isn’t supported. Review collected by and hosted on G2.com.

Last November we launched a Flash Sale promo and our transaction volume jumped 800 percent in two hours. Our old warehouse setup would have queued queries for minutes. But Snowflake's multi cluster warehouse feature is a lifesaver. We set max clusters to 5 on our Small warehouse and it automatically spin up extra clusters when the concurrency spiked.There was no failed queries and no throttling. The best part was that after the sale ended it scaled back down on its own. Review collected by and hosted on G2.com.

Debugging nested JSON parsing errors is a nightmare when you are in hurry. Last month we ingested webhook events from Stripe and some records had missing fields that caused NULL explosions in our downstream models. I spent four hours tracing it to one malformed event out of two million. Review collected by and hosted on G2.com.

We needed to restrict access based on project roles and fast. That's when i fell for dynamic masking. We applied masking policies directly on columns in Snowflake, no messing with ETL no separate staging tables. I literally wrote ALTER TABLE .... ADD MASKING POLICY and it just worked. Within two days auditors saw masked data while our BI team saw full values. The best part of it was It's all centralized in the account. Review collected by and hosted on G2.com.

At the start we actually struggled with time travel billing. We enabled 90day retention just to be safe because our legal team wanted it. Then our monthly bill spiked. Turns out restoring a table from 70 days ago costs storage even if you never query it. Nobody explained that clearly during the training. Review collected by and hosted on G2.com.

I feel the time travel feature in Snowflake is outstanding because it retains all the updates and deletions to the data for up to 90 days, allowing me to easily roll back to any previous version of the data. This feature is particularly helpful in rectifying any old data load or bad data load, especially when dealing with instances of stale data being loaded. Additionally, the Snowflake team has been really helpful during the initial onboarding and setup process, making sure everything went as smoothly as possible. Review collected by and hosted on G2.com.

I think Snowflake Openflow is a pretty new tool for data ingestion launched mid or late last year and it does not provide a very user friendly experience for creating dataflows. It has different processors and processor groups that help us achieve the necessary data transformations and loading however their configuration is still quite complicated. Another place where it lags is there is not inbuilt alerting for pipeline/dataflow failures and one has to create a work around for a simple alert. Overall, the pipeline building experience is not at all user friendly and requires a lot of effort in the process. Review collected by and hosted on G2.com.

In my capacity as a Business Analyst within the transport sector, I utilize Snowflake extensively to oversee logistics and fleet movement data. The platform's most commendable attribute is its capacity to handle substantial workloads with minimal administrative configuration. It effortlessly supports diverse data formats, including structured records and semi-structured data like JSON from our tracking systems. We typically stage our files in AWS S3, process everything within Snowflake, and subsequently export the insights to dashboards in Power BI. Furthermore, features such as automated scaling and workload isolation ensure that concurrent queries from multiple departments do not compromise system performance. The elimination of manual server management is an additional, significant advantage that streamlines our daily operations. Review collected by and hosted on G2.com.

The main challenge with Snowflake is cost management, which requires strict operational discipline. Poorly written or inefficient queries can noticeably slow processing and drive up expenses. There is also a moderate learning curve when you start working with more advanced features, such as data clustering. To help address these points, it’s important to set up multiple user roles and assign clearly defined privileges so the analytics workflow stays secure and cost-effective. That said, it’s a major advantage that manual index tuning is no longer necessary, which is a meaningful improvement compared with older, more traditional systems. Review collected by and hosted on G2.com.

the cost is less compared to other Datawarehouse's, The UI is so neat and easy to understand,the user experiance is also good, we can integrate snowflake with dbt and other tools, the query performance is also good, And the support team is always reachable, It has new ai features like cortex code , its a game changer Review collected by and hosted on G2.com.

I used snowflake polaris iceberg catalog , It can be improved Review collected by and hosted on G2.com.

Snowflake is excellent for analytical workloads. The cost is relatively transparent, and there are plenty of tools available to help optimize both cost and performance. The UI is easy to use, and integration with 3rd-party vendors is straightforward. You can also easily access data that is external to Snowflake, which helps reduce vendor lock-in risk. Review collected by and hosted on G2.com.

By the nature of being a cloud vendor, the UI has limitations in that it is browser based. This is the same story though for all cloud based data processing platforms. Review collected by and hosted on G2.com.

I find Snowflake extremely useful as a data warehousing tool because it's really fast and offers a lot of tools for processing massive data. I'm really interested in its latest feature, Cortex AI, which I believe can solve many issues my developers face. Cortex AI enables me and my team to integrate data sources and create dashboards in just minutes. It's really helpful for my team in connection with my AWS tools. Also, the initial setup of Snowflake was relatively easy, and I haven't faced any issues while working outside of my firm's compliance constraints. Review collected by and hosted on G2.com.

Nothing, love the product and have never had issues with it Review collected by and hosted on G2.com.

I really like how Snowflake is a very easy-to-use data warehouse where we can store all our data and then write queries in the notebook and do visualization right there. It's the all-in-one feature of Snowflake that stands out, combining the query notebook and visualization all in one place. It's super easy to get someone up and running with Snowflake, as opposed to having to connect a creator to the data warehouse and connecting a BI tool to it. This ease of use, just getting the team ready and working within minutes, makes Snowflake valuable. Review collected by and hosted on G2.com.

I think primarily the cost factor, it's way too expensive. Review collected by and hosted on G2.com.