Redshift amazon code#

In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In terms of technical features, it is a complete solution.' 'Their strategy is just to leverage what you've got and put Snowflake in the middle. Pricing was the only thing that we didn't like about Snowflake.

Redshift amazon code#

So, you have to write complex code for it.' 'Its pricing or affordability is one of the big challenges. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. A lot of functions are missing in Snowflake, so we have to find a workaround for those. 'There is a need for improvements in the documentation, this would allow more people to switch over to this solution.' 'The solution needs more connectors.' 'There are a lot of features that they need to come up with.

As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure.' 'The initial setup is very simple.' Everything is essentially under the hood, and the engine takes care of it all. It is also good in terms of managing and improving performance, indexing, and partitioning.

Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. The way the shared model is built and the way it exploits the power of the cloud is very good. We can connect it with multiple source systems.' 'The way it is built and designed is valuable. It has good security, and we can easily integrate it. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution.

The inbound and outbound share features are also very useful for sharing a particular database. When you run a query, its performance is very good. 'Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.' 'The technical support is pretty good, particularly if you are a more technical user.' 'The Mbps they have established is quite a bit faster than any other data warehouse.' 'The solution is very easy to use.' 'For us, the virtual warehousing is likely the most valuable aspect.' 'Its performance is a big advantage.