After our project starts, we would need a permanent license."Īmazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud.
REDSHIFT VS SNOWFLAKE TRIAL
"Currently, we have a trial account, so we don't need a license.
![redshift vs snowflake redshift vs snowflake](https://www.immuta.com/wp-content/uploads/2021/09/Cover-Image-Cloud.jpg)
Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue." It was just to maintain the cost or the KPI regarding the cost of connectivity by users. "We used Snowflake to see if it is cheaper than using BigQuery.Now, if you were starting from scratch, it might be cheaper to go a different way." It doesn't make it expensive because most of the organizations already have reporting tools. Their strategy is just to leverage what you've got and put Snowflake in the middle. We didn't have the scale of data like a much larger company to consume more credits. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. "The price of Snowflake is quite reasonable."."The price of Snowflake is very reasonable."."Pricing is approximately $US 50 per DB."On average, with the number of queries that we run, we pay approximately $200 USD per month.".
![redshift vs snowflake redshift vs snowflake](https://i1.wp.com/blog.happyfox.com/wp-content/uploads/2020/10/Snowflake-vs-Redshift.png)
If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues." "The pricing of the solution should be much easier to calculate or find by yourself." "We would like to see more security including more masking and more encryption at the database level."
![redshift vs snowflake redshift vs snowflake](https://sarasanalytics.com/wp-content/uploads/2020/08/Snowflake-vs-Redshift-3.jpg)
For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. It seems that they are working on this feature, and they are yet to release it. It would be a huge advantage if you can write your stored procedures using SQL. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. There have been some challenges." "Portability is a big hurdle right now for our clients. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, Snowflake itself, we don't set it up. With those errors, you don't have permissions." "There is a need for improvements in the documentation, this would allow more people to switch over to this solution." "Their UiPath, the workspace area, needs some work." "I would like to see a client version of the GUI." "The complexity of the initial setup of Snowflake depends on the use case. "These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently." "The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed." Ease of use is a big thing in Snowflake." "The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. There are simple SQL and UI, and people are able to use this solution easily. You just onboard the user, and you are done with it. I don't need to ramp up any user, and its onboarding is easier. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. It doesn't require much DBA involvement because it doesn't need any performance tuning. Separating compute and storage gives you flexibility. The elastic compute is another big feature. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem." "Great scalability and near zero maintenance." "Time travel is one feature that really helps us out." "Working with Parquet files is support out of the box and it makes large dataset processing much easier." "The technical support on offer is excellent." "Data sharing is a good feature. I have been able to completely copy databases.
![redshift vs snowflake redshift vs snowflake](https://sonra.io/wp-content/uploads/2021/06/word-image-25.png)
"The cloning functionality has been the most valuable.