Snowflake

Last Updated:

 

February 4, 2025

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 deep integrate your Snowflake into the Oleria platform. This document provides step-by-step guidance for integrating Snowflake with your Oleria workspace.

Pre-requisites:

  • The user granting these permissions must have Accountadmin role

Note: Standard integrations are configured with read-only permissions.

Step 1: Copy Account Identifier Log in to your Snowflake instance and ensure the role set to accountadmin. Navigate to account as shown in the following picture and copy account identifier. 

Step 2: Integrate Snowflake with Oleria Workspace

 2.1.  Log in to your Oleria workspace, navigate to  Integrations, and select Snowflake. A side page opens. Propvide account identifier and click Continue.A script is generated. Copy the script.

Note: Do not close this window.

Step 3: Execute the script in Snowflake

  3.1. Open the snowflake console, create a new SQL worksheet, copy the scrip copied in step 2.2 and click Run All.

Step 4: Complete the authentication in the Oleria workspace
  4.1. Login to Oleria workspace, select the checkbox and click authenticate.

  4.2. You can find a newly integrated Snowflake instance in the connected integrations.

How can a comprehensive identity
security solution empower your team?