How has it helped my organization?
We mainly used SQL scripts and provided a solution for different owners who want to query a database but have several tables. Typically, it is not an easy task to read several tables, so we provided our client with a very crisp data model where they can get results in a very quick manner. We implemented distribution as well as weekly partitioning.
What is most valuable?
The relational piece and how one dimension relates to another just by using a key is the solution's most valuable aspect. We are managing everything by using simple relations. It's all about the relationships between dimensions.
What needs improvement?
Right now, we need to write code, but if they could create a version of Snowflake that was more drag and drop for those managers that don't know how to code, it would be great for our business.
The solution could improve the user interface and add functionality to the system.
For how long have I used the solution?
I've used the solution for two years.
What do I think about the stability of the solution?
The solution is stable. We bring in incremental loads into Snowflake. There are pipelines that daily seed data from Oracle to a data warehouse. It's a prebuilt code and it allows for great stability.
What do I think about the scalability of the solution?
It's very easy to scale because Azure cloud's own data warehouse gives us that capabilities to scale up or down at any time we want. There are a great number of users on the solution, but it differs from client to client. One client, for example, has about 30,000 users.
How are customer service and technical support?
We've never been in touch with technical support.
How was the initial setup?
The initial setup is straightforward. You just need to follow the documentation.
What about the implementation team?
We handled the implementation ourselves. I've handled two or three projects previously, so I'm comfortable with the solution. We don't need assistance because we handle the consulting part.
What other advice do I have?
The solution is deployed on the cloud using Azure, where there's a data warehouse. We primarily use SQL scripts.
For those considering implementing, I'd advise that they understand the business very deeply first. Not every business would have a demand for Snowflake, so it's not for everyone. It's important to understand the requirements and then, if it makes sense, to implement Snowflake.
I'd rate the solution eight out of ten. I'd rate it higher if it had a better user interface.