Remember to allowlist our IP Address
If your database is protected by a firewall, remember to allow inbound access to AirOPs IPS address over your database port.
To set up a new database connection, go to ⚙️ Settings —> Warehouse Setup —> Add Source +
- Host - The hostname or IP address of your PostgreSQL server.
- Port - The port on which your PostgreSQL server is listening. Default is
- User - The PostgreSQL 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 - The PostgreSQL database that AirOps will connect to.
In order to add a PostgreSQL database as a Data Source on AirOps, we recommend using an existing user, or creating a user with read access to the tables and schemas you would like to access from AirOps.
If you're creating a new user, you can follow the below instructions:
CREATE USER airops_user WITH PASSWORD '<secure-password>';
Replace andwith the appropriate schema and table names that you would like AirOps to interact with.
GRANT USAGE ON SCHEMA "<schema>" TO airops_user; GRANT SELECT ON TABLE "<schema>"."<table>" TO airops_user;
If you want to grant access to multiple tables, you can run the
GRANT SELECT statement for each table or run
GRANT SELECT ON ALL TABLES.
If you want to grant access to all future tables in a schema, you can use the following command. Replace with the appropriate schema name.
ALTER DEFAULT PRIVILEGES IN SCHEMA "<schema>" GRANT SELECT ON TABLES TO airops_user;
Updated about 1 month ago