The database administrators, who are well-versed with relational database constructs find it easy to create and provision new Amazon Redshift nodes and clusters. However, when you load data to Amazon Redshift, writing manual SQL scripts can make the loading hard to be agile and adapt to rapidly change the requirements from business stakeholders.
The following are the use cases:
Batch Data Integration
Streaming Data into Amazon Redshift
Mass Ingestion task to upload data to Amazon S3 and Amazon Redshift