Snowflake Reviews & Product Details

No need to setup the infrastructure, With just 3-4 clicks, you get the account in your Cloud and get $400 credit for next 60 days. This enables all the functionality and we play with any functionality on this trial version. Native support for loading semistructured data Data is automatically encrypted at rest and in transit Automatic partitioning and Clustering and compression Automatic versioning, Time Travel, and Fail-Safe Provides Cross Cloud replication

Snowflake is still in the very early phase of supporting the Delta table functionality. Moreover in Replication, we are supposed to replicate one Database at a time, But what if we have multiple databases in Account we need to replicate each and every Database manually. Account level replication should be there. Also Snowpipe is there but near real-time , waiting for snow pipe streaming.

Working closely with Business stakeholders and drawing from our strong Expertise in Snowflake, we defined our focus, determined the data migration strategy and advised Snowflake as Cloud Warehouse because of the following benefits: Scalable Storage layer: Store data such as Amazon S3 bucket. This ensures data scaling, and availability without any management by customers. Automated Zero Administration: Snowflake supports Auto-Scaling, Auto-Suspend, Sharing, query management, optimization, security automatically. Lower Cost: Snowflake works on Pay Per Use model. Pricing depends on the amount of data stored and the compute hours used. High availability: Replicating the data across three availability zones in the event of node failures. Query resiliency: If a single compute instance fails within a virtual warehouse, Snowflake automatically replaces that instance and completes the query without disruption

The easy and quick away to change the compute power for your SQL queries. I don't think there is anything like this on the market. Unlimitted storage makes Snowflake THE data lake on the market.

The new query interface. I'm not sure what Snowflake was thinking here. I always go back to the original UI. The new one is way too confusing. New features are not always well communicated. I wish there were a page in the account where we can get a summary of new elements and which one is available and active for the current account.

Building Data Warehouse solution. We use Fivetran and Airbyte for data integration to bring any data source to Snowflake. We then build a dimensional model to transform data and provide our clients with faster BI reporting capability. We then use DBT to automate the data transformation and implement our dimensional models.

User-interface and easy to work with an environment

if we have standalone software it could be usefull

data migration and process of data

My organisation consumes Snowflake as the leading service for storing and analysing data points collected from customers and clients. It provides a spotless and straightforward user interface. The ability to work on multiple tabs and queries is wholesome. It also supports different databases users need to select for querying the data point. It also has a separate canvas showing the status of query progress and SQL tree structure of the query with the amount of time each operation takes. Once the query is completed, it provides a download button to save the result. They recently introduced Snowflake Lite, which is also easy to use and valuable.

It doesn't include the feature to run multiple queries from a canvas. Sometimes the queries take longer than usual, and waiting is painful without a progress bar. There is no historical version of the canvas where the queries are written, so once it is lost, it is gone forever. There is no autocomplete feature support for table names or SQL syntax.

I am using Snowflake to store the data points collected via pipeline from customer clients to the prod database. We use two different versions of Snowflake; one is for developer testing, and another is for the production database. I can filter data points through SQL queries based on dates, types, strings, etc on the Snowflake. The SQL tree is helpful to optimise the queries as it provides a breakdown of each component consuming resources and time.

Really strong performance and speed, also easy sharing

The only thing I don't like is that you cannot collaborate with teammates on a query

It makes it easy to query data and quickly get metrics that we need

Snowflake is best for unpredictable workloads or sudden spikes in user queries. 1. Since Compute & storage are decoupled, queries don't get queued for resources. 2. Another killing feature is it has Auto Pause & auto suspend modes which stops consuming credits when no queries are running. 3. Snowflake is an apparent winner compared to AWS Redshift when it comes to maintenance. Almost zero admin tasks everything is taken care of for you. You can either change a warehouse’s size or increase the number of clusters with almost zero downtime seamlessly. 4. As already mentioned it is best in the situations where you get temporary high workloads, so you can increase the compute capacity without increasing storage. 5. Built-in support for Semistructured data like JSON is worth mentioning. 6. Lift & shift from On-prem Relational DW to Snowflake is easy compared to other cloud warehouses.

Complicated Billing. Snowflake’s On-Demand pricing model can be enticing initially, but it can be very unpredictable in the long run, and its cost increases as you go higher. As compared to Snowflake, Redshift has a simple pricing structure based on redshift clusters. Redshift also offers Reserved Instance Pricing, which allows you to unlock 75 percent savings which was the primary driver for switching from Snowflake to ASW redshift for one of our customers.

Highly scalable Data Warehousing solution which can serve organizations' BI, Analytics & Decision support needs. Highly useful for unprecedented /workloads which need instant scaling. Helps quick migration from On-prem relational data warehouse(Oracle) to scalable cloud snowflake warehouse. Flexibility to choose any public cloud storage be it AWS/Azure or GCP.

Data sharing, zero-copy cloning, time travel

There is nothing to be disliked about it

Data Ingestion/Processing with separate storage and processing capabilities through virtual warehouses

Easy to understand through user guide. Nice gui. Fast results. Additional feature snowsight is an amazing add on.

Every feature i have used so far is great

Database querying -results are fast The result table can b directly copied without downloading.

I enjoy how easy it is to search up different tabs that I'm working on. Another feature I find helpful is Snowflake highlighting the specific syntax or part of the query causing the query to run unsuccessfully.

Snowflake's documentation on its syntax and the examples provided can be confusing and hard to follow. I want Snowflake to provide more detailed and broken-down SQL queries with the matching results for more complicated functions.

Using Snowflake, I've run a distribution analysis and set target goals for an incentive program rolling out for the company's Customer Service representatives.

It is seamless to integrate data from multi-cloud and on-premise repositories. Automatically prepare, model and visualize data.

I am fully satisfied with Snowflake in terms of features coverage and customization.

I relish a lot with Snowflake from saving time, finances to unlocking actionable insights on data.