Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

Connecting to Redshift

  1. Click Manage Connections in the top center of the app. Screenshot of managing your connections

  2. Click New Connection in the Manage Connections modal in PopSQL. Screenshot of creating a new connection in PopSQL

  3. For Nickname, enter something a descriptive name for your connection, like Marketing Analytics.

  4. For Type, choose Redshift.
  5. For Hostname, enter the hostname of your database server.
  6. For Port, use the default 5439, or enter the port used by your server.
  7. For Database, enter the name of your database.
  8. For Username and Password, enter the username and password for Redshift. These are optional.
  9. Hit Connect and you're all set! Screenshot of a sample Redshift connection in the New Database Connection modal in PopSQL

Happy querying! 🍭

AWS RDS IAM

If you need to use AWS IAM to sign into your RedShift database, we support that on our Enterprise plan. Please get in touch with us if this applies to you.

Once enabled, you will be able to select "Amazon RDS IAM Credentials" or "Amazon RDS IAM Profile" as the connection method for RedShift. When using the credentials method, you will be asked for the Region, AWS Access Key ID, AWS Secret Access Key, and optionally the AWS Session Token, which should provided by your administrator. For the profile method, you will be asked for your Profile which corresponds to the named profile you have configured within the AWS CLI.

For both methods, you will also be asked for a Username corresponds to the DB user you wish to use to connect to the database. This user should be granted the rds_iam permission within the database. For example, to create a new user for IAM, you would do the following:

-- Create a new database user
CREATE USER iam_user;
-- Grant permission to use RDS IAM to that user
GRANT rds_iam TO iam_user;

This authentication mechanism only works with direct connections, so please make sure your computer can reach RDS (i.e. you may need to configure need to configure the RedShift VPC to allow your IP address).

Ready for a modern SQL editor?