Redshift
Connect to Redshift databases from Airplane tasks and runbooks.
The Redshift resource allows tasks and runbooks to connect to a Redshift database. For a high-level
introduction to resources, see the resources page.
Creating a Redshift resource
To create a new Redshift resource, visit
resources for your team, click the "New" button,
and select the Redshift resource type. Enter your connection details in the form:

Name should be a human-readable name for your resource. You'll use this name to later reference
this resource in tasks.
Host should be the IP address or DNS name of your database. Unless you're connecting to this
database behind a self-hosted agent (see Private Networking below), this should be the public IP
address and/or the public DNS name of the database. You can find this in the
AWS Redshift console under the Configuration
section.
IP whitelisting
If your database has restrictions on incoming network connections, you'll need to ensure the
Airplane IP addresses are whitelisted:
- 34.121.89.145
- 34.68.100.27
- 34.72.182.225
Private networking
To connect to a database inside a private VPC, you can self-host the agent and
run the agent within your own VPC. Since tasks and SQL queries run on agents, these tasks will run
from within your network and be able to connect.