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 or IP - The endpoint of your AWS Redshift cluster.
- Port - The port on which your Redshift cluster is listening. Default is
- User - The Redshift 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 Redshift database that AirOps will connect to.
In order to add an AWS Redshift 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 PASSWORD '<secure-password>';
<table> with 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.
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