BigQuery

Instructions for connecting a postgres database to AirOps.

🌐

Important

Remember to allowlist our IP Address 52.71.87.39

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

  1. Go to the Google Cloud Platform Console.
  2. Click on the project dropdown and select the project that contains your BigQuery dataset.
  3. Navigate to the IAM & Admin page, and then click Service accounts.
  4. Click + CREATE SERVICE ACCOUNT at the top of the page.
  5. Enter a name for your service account and click Create.
  6. On the Grant this service account access to the project page, select the BigQuery Data Viewer and BigQuery Job User roles.
  7. Click Continue, and then click Done.

2. Generate a JSON key for the service account

  1. In the Service accounts page, find the service account you just created.
  2. Click the Actions menu (three vertical dots) and select Create key.
  3. Select JSON as the key type, and click Create.
  4. Save the generated JSON key file to your computer.

3. Enter the JSON key file content in AirOps

  1. Open the JSON key file with a text editor.
  2. Copy the entire content of the JSON key file.
  3. 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.