<aside> 🌐 REMEMBER TO ALLOWLIST OUR 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

</aside>

To setup a new database connection, go to ⚙️ Settings —> Warehouse Setup —> Add Source +

After selecting Snowflake, the following information is required:

• Account Identifier - the ID of your Snowflake Account.
  • If your snowflake url is https://[**en54071.us-east-2.aws**](<http://en54071.us-east-2.aws>).snowflakecomputing.com/, then you account identifier is en54071.us-east-2.aws.
  • You can easily find your Snowflake account ID by typing CURRENT_ACCOUNT() into a Snowflake worksheet.
• User - the Snowflake 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.
  • Snowflake usernames are case sensitive!
• Password - password for the above user.
• Warehouse - the Snowflake warehouse that AirOps will connect to.
• Database - database within the above Snowflake Warehouse.

Setup user and role

Setup OAuth client (Optional)