Oleria provides identity security and access management teams with visibility and intelligence into who has access to what, where they got that access, how they use it, and whether they should even have it. As part of that promise, we deeply integrate your Snowflake into the Oleria platform. Follow these steps to integrate Snowflake with your Oleria workspace.Documentation Index
Fetch the complete documentation index at: https://docs.oleria.com/llms.txt
Use this file to discover all available pages before exploring further.
Prerequisites
- To grant these permissions, you must have an ACCOUNT ADMIN role.
Standard integrations are configured with read-only permissions.
Copy the Account Identifier
Log in as ACCOUNTADMIN
Log into your Snowflake instance and confirm your role is set to ACCOUNTADMIN.
Set Up the Oleria Connector in Snowflake
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.
Execute the Script in Snowflake
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.
Complete Authentication in Oleria
Confirm script execution and authenticate
Log into your Oleria workspace, check Confirm that the script has been executed successfully, and select Authenticate.
