Snowflake
Connect to a Snowflake data warehouse in AirOps
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 IP address over your database port.
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 your account identifier isen54071.us-east-2.aws
.You can also find your Snowflake account ID by typing
CURRENT_ACCOUNT()
into a Snowflake worksheet and running it.
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 (for New Users)
To add a Snowflake database as a Data Source on AirOps, use an existing user or create a user with read access to the tables, views, and schemas you would like to access from AirOps:
1. Create AirOps Role
2. Create AirOps User and Assign Role
3. Grant USAGE privileges to AirOps role
Last updated