> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oleria.ai/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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=f14734913a6b34502c7b61b56ddff408" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=280&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=8e0c9990e212cf385af81eae3f4d8e58 280w, https://mintcdn.com/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=560&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=be60085ffc7dc63c8cc575712697ace5 560w, https://mintcdn.com/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=840&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=e5ca7044976f51c892ac76e2f39d515e 840w, https://mintcdn.com/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=1100&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=480d5fcac278422bf77317cd3624f2ea 1100w, https://mintcdn.com/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=1650&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=fb3d7b216a8ab5e37fb992f81e71c99b 1650w, https://mintcdn.com/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-1.png?w=2500&fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=677a67bded3e3da61675d6cc3c634b75 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-2.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=6a6b49f321bbc5c762b76b7027b23b36" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-3.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=6423a74fcb1ef61baf686fff39531915" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-4.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=c629b267ae947236c71d52bb0b88e8ed" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-5.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=6f2f1495ceb3f81361f1156166e1c9d2" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-6.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=13f2c9da7c5d0e0539e0a61e29dd0b08" 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/dev-oleria/gdgGSpwV1qJdY5tb/images/integrations/snowflake/step-7.png?fit=max&auto=format&n=gdgGSpwV1qJdY5tb&q=85&s=7eda8816da3134ec66e0b72b419692b9" 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).
