Prerequisites
- To grant these permissions, you must have an ACCOUNT ADMIN role.
Standard integrations are configured with read-only permissions.
Copy the Account Identifier
1
Log in as ACCOUNTADMIN
Log into your Snowflake instance and confirm your role is set to ACCOUNTADMIN.
2
Copy the account identifier
Navigate to ACCOUNT ADMIN → Account → your account number. Copy the account identifier.
Set Up the Oleria Connector in Snowflake
1
Open the integration and provide connector details
Log into your Oleria workspace, navigate to Integrations, and select Snowflake. A side panel opens. Provide the following information and select Continue:
-
Account Identifier - copied above, in the format
<org-name>.<account-name> -
User Name - default is
oleria_connector_user. Change if preferred. -
Role Name - default is
oleria_connector_role. Change if preferred. -
Warehouse Name - default is
oleria_connector_warehouse. Change to use an existing one if desired.
2
Copy the generated script
A script is generated. Copy the script.
Do not close this window.
Execute the Script in Snowflake
1
Run the script in a SQL Worksheet
Open the Snowflake console and navigate to SQL Worksheet. Create a new SQL worksheet, paste the script you copied, and select Run All.
2
Confirm completion
The script creates the database, tables, and tasks. These tables store policies and integration metadata that Oleria uses to generate risks and SAML SSO insights. The task is scheduled to run hourly to keep the tables up to date.
Complete Authentication in Oleria
1
Confirm script execution and authenticate
Log into your Oleria workspace, check Confirm that the script has been executed successfully, and select Authenticate.
2
Confirm the connection
Navigate to Connected Integrations to find the newly integrated Snowflake instance.