Understanding the Amazon Redshift login fields

This guide will walk you through the correct process to login to Amazon RedShift with Dataslayer.

To login to AWS RedShift in Dataslayer, you need 6 fields that you can find in the Amazon console:

Host
Port
User
Password
Database
Schema

To find this information, follow these steps:

Log into Amazon Console and go to Amazon console > Amazon Redshift > Clusters > Specific cluster in which you want to insert the data.

Here you will find almost all the information needed to log in AWS RedShift in Dataslayer. Copy the following information:



1. Host: The first part of the endpoint, up to the colon (not including them).
2. Port: The four numbers found in the Database configurations.
3. User: You will also find it under Database configurations, but you can select the user of your choice.
4. Password: This password (not shown in the image above) is your user's password (the one chosen when the database/user was created).
5. Database: The database name found in the Database configurations

Finally, to find the Schema enter in the database in which you want to insert the data. Once there, select the schema where you want to insert the data and copy its name.





Log into the Dataslayer website.


Once logged in, click on Amazon RedShift destination.



Click on New Transfer.



And then on Connect with AWS.



Paste all the previous information in the corresponding fields.



Done! Once you have filled in all the fields click on connect and you are successfully logged in to AWS RedShift in Dataslayer.



As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!

Updated on: 10/04/2024