Explo home page
Search...
⌘K
Ask AI
Take a tour
Request free trial
Request free trial
Search...
Navigation
Data Source Types
Redshift
Documentation
API Reference
Case Studies
Security Trust Center
Changelog
Home
Explo Help Desk
FAQ
Customers
Overview
Customer Hierarchy
Group Tags
Data
Connecting to Data Sources
Connectivity Regions
SSH Tunnels
AWS PrivateLink
Data Source Types
Athena
Azure SQL DB
BigQuery
Clickhouse
CockroachDB
Databricks
Materialize
Microsoft SQL Server
MotherDuck
MySQL
Parade DB
Postgres
Redshift
SingleStore
Snowflake
Supabase
Timescale
Data Sources and Schema
Data Library
Building your data model
Data Connector (FIDO)
Dashboards
Creating Dashboards
Dashboard Features
Report Builders
Creating Report Builders
Report Builder Features
Embedding Documentation
Add Explo Domains To CSP
Allowlisting your domain
Embed secrets (JWTs)
Dashboard Embedding
Report Builder Embedding
Iframe vs Web Component
Troubleshooting Your Embed
Data Share
Overview
Getting Started
S3 Setup
AI Features
AI Feature Acknowledgement
Context Setting
General Features
Version Control
Analytics Reporting
Internationalization
Timezones
Custom JS Events
Embed ID Page
Exporting Features
Managing Permissions
Data Visibility Groups
User Roles
Security
Security FAQs
Rate Limits
Caching Layer
On this page
Intro
Necessary Credentials
Authentication Options
Allowlisting Explo’s IPs
SSH Tunnels
Finding Redshift Credentials
Questions?
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
Allowlisting Explo’s IPs
You may need to allowlist egress IPs for your
Connectivity Region
.
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
[email protected]
if you have any questions.
Postgres
SingleStore
Assistant
Responses are generated using AI and may contain mistakes.