Product: StreamSets Transformer
Streamsets provides the stage for Amazon Redshift, By default, Amazon Redshift provides the Endpoint to make the communication.
Here is the example of the Redshift connection string which we need to use in the Streamsets Transformer Redshift stage
For example, your JDBC URL could look like this (In AWS console):-
jbbc:redshift://mycluster.us0I5nrnge4i.us-west-2.redshift.amazonaws.com:5439/dev
So the endpoint for the pipeline as below:
mycluster.us0I5nrnge4i.us-west-2.redshift.amazonaws.com:5439/dev
