<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:

• Project ID - the Google Cloud project that the BigQuery warehouse belongs to.
• Port - the JSON key file generated within the BigQuery project with access to the BigQuery project.
• Region - region of the BigQuery warehouse.

Google Cloud Permissions

1. Choose an existing service account or create a new one. Instructions on setting up a GCP service account can be found here.

2. Generate a JSON Key file for the service account.

1. Grant the service account the proper level of access to BigQuery. More information on BigQuery permissions can be found here.
   1. Minimally, AirOps Requires “BigQuery Data Viewer” (read only role), and “BigQuery Job User” permissions.