<aside> 🌐 REMEMBER TO ALLOWLIST THE AIROPS IP ADDRESS 52.71.87.39

****If you have internet access closed on your warehouse, make sure you add our IP Address to your allowlist.

For private network connections, please reach out to AirOps support at [email protected].

</aside>

To setup a new database connection, go to ⚙️ Settings —> Warehouse Setup —> Add Source +

After selecting Redshift, the following information is required:

• Host - the IP address or hostname of the Postgres database that AirOps is connecting to.
• Port - the port that the Postgres cluster has been configured to communicate over. The Default Postgres port is 5432.
• User - the database user that AirOps will connect to the database with. It is best practice to create a new user for AirOps (instructions below), but any user with SELECT privileges can be used.
• Password - password for the above user.
• Database - database within the Postgres host that AirOps will connect to.

Postgres User Permissions