> ## 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.

# Snowflake

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.

## Prerequisites

* To grant these permissions, you must have an ACCOUNT ADMIN role.

<Note>Standard integrations are configured with read-only permissions.</Note>

## Copy the Account Identifier

<Steps>
  <Step title="Log in as ACCOUNTADMIN">
    Log into your Snowflake instance and confirm your role is set to **ACCOUNTADMIN**.
  </Step>

  <Step title="Copy the account identifier">
    Navigate to **ACCOUNT ADMIN** → **Account** → your account number. Copy the account identifier.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=c4dc6bf3dc35a105af8abccf7dde9aca" alt="Navigate to ACCOUNT ADMIN > Account > your account number. Copy the account identifier." data-og-width="879" width="879" data-og-height="349" height="349" data-path="images/integrations/snowflake/step-1.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=280&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=7a81a9ea3977ce0ef7f9f2baf3691293 280w, https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=560&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=663f34316f55ee2591460da49e4225c5 560w, https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=840&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=908d87dfbc9a93f906912852412b821a 840w, https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=1100&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=fe13d54ebd9090a74bab2098e7b9d22d 1100w, https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=1650&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=bb8466e753df323e0161ebc213e45d36 1650w, https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-1.png?w=2500&fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=dc621ad1443a0c68e32a97ebcc1cc74c 2500w" />
  </Step>
</Steps>

## Set Up the Oleria Connector in Snowflake

<Steps>
  <Step title="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.

          <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-2.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=c7559b10071e4567725820bec9185516" alt="Oleria Snowflake integration setup script with configurable connector names" width="1520" height="748" data-path="images/integrations/snowflake/step-2.png" />
  </Step>

  <Step title="Copy the generated script">
    A script is generated. Copy the script.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-3.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=08cd623e40668a34f745133f70322c52" alt="A side panel opens. A script is generated, copy the script." width="756" height="818" data-path="images/integrations/snowflake/step-3.png" />

    <Note>Do not close this window.</Note>
  </Step>
</Steps>

## Execute the Script in Snowflake

<Steps>
  <Step title="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**.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-4.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=eca7cc5b4268e1208b1ce547a77b2f4d" alt="Snowflake SQL Worksheet with Oleria setup script pasted and ready to run" width="879" height="327" data-path="images/integrations/snowflake/step-4.png" />
  </Step>

  <Step title="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.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-5.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=1722ce341c48d561a434b677c53550df" alt="Snowflake SQL Worksheet output showing successfully created database and tables" width="1186" height="674" data-path="images/integrations/snowflake/step-5.png" />
  </Step>
</Steps>

## Complete Authentication in Oleria

<Steps>
  <Step title="Confirm script execution and authenticate">
    Log into your Oleria workspace, check **Confirm that the script has been executed successfully**, and select **Authenticate**.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-6.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=bb47e1abeadf80d4f0054d35e59f27f7" alt="Oleria workspace Snowflake integration form with script confirmation checkbox" width="754" height="817" data-path="images/integrations/snowflake/step-6.png" />
  </Step>

  <Step title="Confirm the connection">
    Navigate to **Connected Integrations** to find the newly integrated Snowflake instance.

    <img src="https://mintcdn.com/oleria/qn6A7RIhybLn0JXz/images/integrations/snowflake/step-7.png?fit=max&auto=format&n=qn6A7RIhybLn0JXz&q=85&s=914a826cd6efb0abfe2660b2bc969ee6" alt="Navigate to Connected Integrations to find the newly integrated Snowflake instance." width="1217" height="613" data-path="images/integrations/snowflake/step-7.png" />
  </Step>
</Steps>

## Contact us

For questions about this integration, contact us at [support@oleria.com](mailto:support@oleria.com).
