Instructions for connecting a postgres database to AirOps.
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 +
Add the following details:
- Project ID - The ID of your Google Cloud Platform project containing your BigQuery dataset.
- JSON Key - The JSON key file content for the Google Cloud Platform service account with access to your BigQuery dataset.
- GCP Region - The Google Cloud Platform region where your BigQuery dataset is located.
Setup Google Cloud Platform service account and grant access
In order to add a Google BigQuery Data Warehouse as a Data Source on AirOps, we recommend using a Google Cloud Platform service account with read access to the datasets and tables you would like to access from AirOps.
If you're creating a new service account, you can follow the below instructions:
1. Create a Google Cloud Platform service account
- Go to the Google Cloud Platform Console.
- Click on the project dropdown and select the project that contains your BigQuery dataset.
- Navigate to the IAM & Admin page, and then click Service accounts.
- Click + CREATE SERVICE ACCOUNT at the top of the page.
- Enter a name for your service account and click Create.
- On the Grant this service account access to the project page, select the BigQuery Data Viewer and BigQuery Job User roles.
- Click Continue, and then click Done.
2. Generate a JSON key for the service account
- In the Service accounts page, find the service account you just created.
- Click the Actions menu (three vertical dots) and select Create key.
- Select JSON as the key type, and click Create.
- Save the generated JSON key file to your computer.
3. Enter the JSON key file content in AirOps
- Open the JSON key file with a text editor.
- Copy the entire content of the JSON key file.
- In AirOps, paste the JSON key file content into the JSON Key field.
Now, your Google BigQuery Data Warehouse should be connected and ready for use within AirOps.
Updated 2 months ago