Finding your database credentials is essential for connecting to your Redshift database, either through code, or in a tool like BaseDash. It can be tricky to find your credentials when your database is hosted on AWS Redshift—we're here to make it simple.
Your database credentials are comprised of five main properties:
All this information is accessible on the AWS dashboard, with the exception of the username and password, which are not displayed anywhere—you'll only get temporary access to this when you first create your database, so make sure to copy them down.
Go to https://console.aws.amazon.com/redshiftv2 to open your Redshift dashboard. From here, select the cluster you'd like to connect to.
Once your cluster is selected, you'll be able to see your Endpoint. This value contains your host, port, and database name, all in one.
Once you have your endpoint, you can break it down into its components. For example, let's break down the following endpoint: "redshift-cluster.ckniu46p0s98.us-east-2.redshift.amazonaws.com:5439/basedash"
The host is everything before the ":" (redshift-cluster.ckniu46p0s98.us-east-2.redshift.amazonaws.com in this example)
The port is the number between the ":" and "/" (5439 in this example)
Finally, the database name is everything after the "/" (basedash in this example)
Your database username and password aren't available on the AWS dashboard—these will be generated when you create your database.
By default, AWS creates a master username which you can use to connect to your database: "awsuser". For security reasons, it's best to create a new database user to prevent others from attempting to connect to your database without permission.
Before connecting to your Redshift database from an external app or tool, you'll first need to add an inbound TCP rule on the security group associated with your database.
The security group associated with the Redshift instance needs to have an inbound TCP rule that gives access to connect to your database. To do this first go to the security group settings.
Next click Edit inbound rules and add the IP address of the tool or server you're connecting to as an inbound TCP rule. For BaseDash, this IP address is 220.127.116.11/32. This is also shown during the Connect data source flow in the app.
When selecting the Type of the inbound rule, select Redshift.
Enter the IP address you're trying to connect from. Take special notice that you must include /32 at the end of the IP address since that is the format that AWS expects.
BaseDash is an internal tool that lets anyone on your team safely view and edit data from your database. It's simply the best way for teams to manage data, with powerful features like edit history, no-code filtering, and real-time collaboration.
Now that you have your credentials, you can easily connect your database to tools like BaseDash. If you don't have an account yet, sign up for free and create a shared workspace for your company.
To add your database, click "Connect data source" in the sidebar. Select your database type, then select "AWS" as your hosting provider, then enter a human-readable name for your database. After that, we'll show you the IP address you need to add as an inbound rule on AWS (18.104.22.168/32).
Finally, you can enter your credentials and successfully connect your database to BaseDash! We pre-fill some information based on your database type to save you some time.
We include video guides in the form to help you through the process. If you're still having trouble connecting your database, you can contact us for help.