Please share with the community what you think needs improvement with Snowflake.
What are its weaknesses? What would you like to see changed in a future version?
We would like Snowflake to be able to do inter-cloud migrations. That would be great. I want to be able to switch clouds.
It is difficult in some cases to perform ETL and this is something that should be included. As it is now, I use Informatica PowerCenter to load data from on-premises to the Snowflake cloud-based data warehouse. If this could be done by Snowflake directly, without an external integration tool, then it would become a full package. It would be awesome. They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in. We would like to be able to just write an SQL query and do our work.
The recovery process is very simple and very user-friendly as well. The constraint files could be improved. But the most important things are there. Also, the interface is good to work with and user-friendly. If I had to say what needs improvement, in my experience is that the availability is a problem. Availability should be high and has to be enhanced. I still have not explored all of the existing features. Because I have not been deeply involved with using the program it is hard to say what else is missing or what I would need.
The company is constantly working to improve the product. Now they have a focus on data sharing, which is really great. We already share data with others who do not have Snowflake. That alone is already great. But if the other counterparts also have Snowflake, then it is extremely easy to share data. You can control access at low levels and even on the cell level. It is very secure. With the improvements they continue to make, there is nothing now that I would say I miss or features that need to be added. Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.
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.
The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template. The integration capabilities could be improved.
I would like to have a tool where you can easily see the price because they need clarity of pricing. Support needs improvement, as it can take several days before you get some initial support. Integration could be the key to provide an optimal solution. In the near future, I would like to see a built-in basic analytics solution that can be embedded for testing purposes, so you can see data not only in tables but also in a graphical way in order to better prepare data for analytics. Embedded analytics would be nice.
It would be helpful if implementation could be handled more on the user-side. We need to train the users on best practices and how to use the solution properly. It's a cost issue. If they don't run it properly then it'll end up costing more money. There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.
* Snowpipe auto-ingest should be automatic. * A better client UI or command line tool: I think SnowSQL is a little awkward.
Snowflake has to improve their spatial components since it doesn't have much in terms of geo-spatial queries.