Redshift is a petabyte scale data warehouse tool. Its a fully managed service from AWS, makes it a simple and cost effective way to analyze data using standard SQL queries. It also allows you to use your existing BI tools to query the database using standard SQL queries and perform reporting like a standard database.
Amazon Redshift also includes Redshift Spectrum, allowing you to directly run SQL queries against exabytes of unstructured data in Amazon S3. No loading or transformation is required, and you can use various open data formats, Redshift Spectrum automatically scales query compute capacity based on the data being retrieved hence resource constrains are not a concern.
AWS redshift also supports AWS Database Migration Service.
Connecting a Redshift from a local machine:
8. In case, the option for New profile doesn't pop up, Click on the Create new connection on the Select connection profile. And the above option will be populated. This also helps to save the connection details
9. Click on the Create new connection on the Select connection profile.
10. The following details needs to be filled:
a) The group name can be modified to make it more meaningful like DEV, Staging, QA, Production.
b) The new profile option can be replaced with a more relevant name like SQL1 , SQL2 etc.
c) Download the AWS JDBC driver from here and set the path of driver accordingly.
d) The URL is the URL of the redshift. This can be found in the AWS console.
e) Username: Type the username for the redshift.
f) Password: Type the password for the supplied username.
11. Press the save button above to save the connection settings.
12. The SQL workbench should be able to connect to the database provided there is not other issue.
a) Ensure the appropiate security groups are modified for the access.
13.The connectivity can be confirmed by the connection details here.
14. You can write the SQL query here in the tabs.
15. Additional tabs, or DB explorer can be opened by right clicking the statement tab.