Data Source Types
Redshift

Intro

Find out more about Redshift here.

Necessary Credentials

  • Hostname

    • The server where your database lives

    • Example: rds.amazonaws.com

  • Port

    • The port the database server uses

    • Example: 5439

  • Database name

    • Name of the database you are connecting Explo to
    • Example: acme_production
  • Authentication

    • Scheme you want to use (options below)

Authentication Options

Username and Password

  • Credentials:

    • Username

    • Password

AWS IAM Authentication

  • Make sure your created IAM user has the necessary privileges in your database to let Explo read your tables.
  • To create an IAM user, see here
  • Credentials:
    • Username
    • AWS Region
    • AWS Access Key ID
    • AWS Secret Key
    • SSL Cert

Whitelisting Explo’s IPs

You may need to whitelist our Explo IP’s 54.211.43.19, 52.55.98.121, 3.214.169.94,and54.156.141.148

SSH Tunnels

You can connect to Postgres databases via an SSH tunnel if necessary. Check out this section on SSH tunnels to see how.

Finding Redshift Credentials

You can find your Redshift cluster details via the AWS console. The Endpoint section gives you the hostname and port all in one. You’ll need to get the database name and a username/password from whoever set up the Redshift cluster.

Questions?

Please reach out to the Explo team at support@explo.co if you have any questions.