Overall Satisfaction with Amazon Redshift
Amazon RedShift is used in all departments and accounts. This tool is newly integrated into the system so as to work with the data on the cloud. There are various projects which are moving from SQL servers to ARS because of its capacity of working and managing the data in the cloud.
- We can connect with multiple servers and can fetch the data easily from one server to other.
- It supports the syntax of the bots of the SQL servers, MS SQL and Oracle SQl. This makes it pretty handy to use.
- Here we use views instead of tables, so we can clearly see the flow of data.
- It works very slow in the cloud environment.
- No statistical inbuilt functions are available within the tool.
- Its user interface is not very attractive.
- Often it goes into deadlock state, which kills the running jobs.
- As of now, there are no results on the ROI, as we have just deployed this tool about a year ago. But this is a good tool to use as it is the advanced version of the data reporting platform.
- With the help of Amazon RedShift, we can properly use our server spaces which in result gives a proper ROI as with the limited storage capacity we can store enough data.
- It tends to work very slow, so it reduces the efficiency of the employees who are using it. Hence this is the major challenge with the employees.
It works on the cloud and we use the platform Dbeaver which is very unique and easy to maintain. There are very limited tools of this kind but the security issues are pretty high within those tools.