Snowflake Analytics Reviews

There are a lot of use cases for Snowflake. We can use it to build data pipelines. We can also use it to process terabytes of data to generate real-time analytics.

The computational power of Snowflake is very good. We get results very fast. Snowflake also has very good connectors for building pipelines. It makes it easy to connect to different cloud solutions.

Snowflake should include a WHERE clause for building data pipelines. When we create pipelines, Snowflake does not provide the WHERE clause. So the data transformation does not take place. We have to dump data as it is and transform it into the pipeline. If the WHERE clause is included, it will be very beneficial in the future.

I have been using Snowflake for around two years.

Snowflake is a stable product.

Snowflake is a scalable solution.

Snowflake’s technical support is good.

The initial setup was very straightforward. It is not very complex. If you are building something which requires customized queries or stored procedures, it is a little complex.

Initially, we faced some syntactic problems during setup. Then, there were some concerns about the WHERE clause. Apart from these, we did not face any other problems.

I went through the product documentation and deployed the solution myself. The deployment took one or two days. There were many different phases in the deployment strategy. I joined the team during deployment.

Using Snowflake, we can dump data through data pipelines and generate analytics. I do not belong to the sales team, so I do not know about the pricing information of Snowflake. I rate Snowflake an eight out of ten.

We use Snowflake Analytics to organize data. We create a fact and dimension table, relate it using its cardinality, load it from the source and use it for reporting.

It helps with business intelligence by providing analytics that can be reported.

There are issues while loading data from Snowflake Analytics to the Power BI reporting, and it doesn't get loaded directly. Sometimes we need to use queries to fix it, but it affects our reporting. Snowflake Analytics should be easily loaded into the reporting tool because it is the final end tool.

We have been using this solution for four months.

I cannot speak to stability because our data is not yet 100% loaded. It is a continuous ongoing process.

It is a scalable solution. In my organization, about four people, along with our clients, use Snowflake Analytics. So about four to eight people are using it. So far, it is not difficult to maintain the solution.

The initial setup was straightforward, neat, understandable and clear. We did the deployment in-house.

I do not have details about the licensing costs.

We did not review any other solution before Snowflake Analytics.

I rate this solution an eight out of ten. It is a wonderful tool. It easily organizes data, makes it accessible, loads it from the pipeline and helps with reporting.

One advantage is that installation is unnecessary since it's cloud-based. You subscribe to a Snowflake instance, configure it, and start using it. It's very user-friendly and allows you to scale up or down based on usage.

I don't see many drawbacks with Snowflake Analytics, but it's not as mature as other tools. It is evolving and needs to integrate various features, like data loading and analytics, better. These components are not fully connected, so the tool should become a more integrated application.

The solution is costlier than Azure or other tools like Pentaho, which are cheaper but require more effort in ETL or ELT development and integrating all the tools.

Snowflake Analytics integrates well with the data, keeping everything within the same network and premises, eliminating network latency, and ensuring fast performance. Scalability is a strong point, as the compute and storage layers are separate, allowing independent scaling. This elasticity means that as more users or developers work on it, Snowflake can handle any load by leveraging CPU and GPU capacity.

I rate the overall solution an eight out of ten.