Hello everyone, it’s been a while since I am not updating this blog. Recently I learned about Amazon Redshift. It is one of the most popular Amazon AWS services that has been used by millions of users out there. I am not going to explain about Redshift. You may read the article that explains Redshift very well at the end of this post. In this article, I will show you how to connect to Amazon Redshift Database from a Mac. I am using Macbook Pro M1 to connect to my Amazon Redshift.
I assume you have the Amazon Redshift up and running. There are various ways to connect to Redshift from Mac.
A. Redshift Query Editor v2
Redshift comes with a built-in query editor called Query Editor v2. There are some basic features that come with this query editor. We don’t have to install any software in order to use this editor. Not many features but still can be a good alternative. To open Redshift Query Editor v2, go to the Amazon Redshift page, and then on the left tab, click Query Editor v2
Here is the interface of Query Editor v2
B. Navicat Premium
Navicat Premium is the one-stop solution for database management software. It supports many databases including Amazon Redshift. Navicat is available for macOS, Windows, and Linux. It is not free but if you are looking for complete database management software, Navicat Premium is right for you. To connect Amazon Redshift to a Mac using Navicat, you can follow the steps below.
- Open Navicat Premium
- Create a new connection by clicking Connection | Amazon AWS | Amazon Redshift
- Give the new connection a name
- Enter the Endpoint. You can copy the Redshift endpoint from the Amazon Redshift cluster general information.
- Type the port. The default port is 5439
- Type the initial database
- Enter the username and password.
- Click Test Connection to make sure the connection is successful
Now we can start using Navicat to manage our Redshift database
Similar to Navicat, dBeaver is a database manager for Windows, Mac, and Linux. We can get the free community version. It supports almost any database including Amazon Redshift.
It’s not as good as Navicat (IMHO) but dBeaver is available for free and we can use it to manage our Amazon Redshift from Mac.