# Snowflake Integration

The following guide helps to integrate and configure Snowflake on Sprinto to manage users' access.

### How does this integration help

The integration helps sprinto in the following ways:

* Access management: The integration enhances access control by validating user accounts from the Snowflake against defined access criteria. Sprinto identifies and flags unauthorized or invalid access, triggering checks to revoke inappropriate permissions and maintain system security.

#### Sprinto checks for Snowflake

Below are the Sprinto checks for the following integration types: 

* Access management: Sprinto checks for users' access monitoring

| Sprinto check                                          | Reference procedure                                                                                                                                                                                                       |
| ------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Snowflake access should be removed for offboarded user | [How to fix](https://docs.sprinto.com/monitors/authentication-and-access-monitors/resolve-sprinto-check-for-removing-access-for-offboarded-users)                                                                         |
| User should be identified                              | [How to fix](https://docs.sprinto.com/data-library/access/dashboard-actions/view-and-map-staff-access)                                                                                                                    |
| User access to critical system should be valid         | <p><a href="../../data-library/access/dashboard-actions/view-and-map-staff-access">How to fix</a></p><p>Note: The user access to the critical system becomes valid if the respective Org role is added to the system.</p> |

### Before you begin

* Log in on Sprinto as administrator.
* Ensure you have admin access to the Snowflake account to grant Sprinto the required permissions.

### Integrate Sprinto with Snowflake

Follow the below applicable procedure:

#### Access management:

Note: [Truto](https://www.truto.one/) is our integration partner for Snowflake for user access monitoring.

1. Get the Client ID and Secret from the Snowflake account.

* Log in to your [Snowflake](https://www.snowflake.com/login/) account using your credentials.
* Copy your Snowflake account URL and account locator details and save them securely. For detailed instructions, refer to the guide on [Finding Account URL and Locator](https://connectaccount.wiki/integration-guides/snowflake/#finding-account-url-and-account-locator).
* Create a new Client ID and Client Secret from the Snowflake account. For detailed instructions, refer to the guide on [Create Your Client ID and Secret](https://connectaccount.wiki/integration-guides/snowflake/#create-your-client-id-and-client-secret).
* Save the generated credentials securely. We will need these details on Sprinto to build integration.

2. Integrating Snowflake with Sprinto.

* From the Sprinto admin portal, navigate to Settings > Integration and select the Available tab.&#x20;
* Click Connect next to Snowflake.

  <figure><img src="https://3220032727-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEsyn5VMU6e0OyGjRtKgx%2Fuploads%2FfVtjJ2fI0XhlzvqdnECg%2FScreenshot%202025-09-25%20at%2015.16.47.png?alt=media&#x26;token=02ff9aca-548d-43d2-a93c-73e1b1a7e916" alt="" width="563"><figcaption></figcaption></figure>
* Read the on-screen instructions, then click Next.<br>

  <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873977/original/A9n8M0t63LjfoipPjzGShwC0mXl1FC_vyw.png?1723051846" alt="" width="375"><figcaption></figcaption></figure>
* Select the acknowledgment checkbox, then click Connect to Snowflake.

Note: Ensure you have a pop-up window enabled on your browser.

<figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873980/original/jjIMOKg8fkzyVeksvuOJN8CI6PLcNgT0Cg.png?1723051846" alt="" width="375"><figcaption></figcaption></figure>

* Enter the Client ID, Secret, Snowflake Account URL, and Account Locator from Step 1, then click Connect.<br>

  <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873979/original/UeH-fNjyHHYNIQHMzrCTxdTKuAW2J1fY7g.png?1723051846" alt=""><figcaption></figcaption></figure>

3. Configure Snowflake for access monitoring.

* From the Sprinto admin portal, navigate to Data Library > Access, select the Overview tab, and click + Add Critical System.
* Select Snowflake from the critical system library, then click Add Systems. If integration is built successfully from the previous section, "Connected" will be highlighted next to Snowflake.<br>

  <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873984/original/HzOzrBUQTiFVxijm7rrUExjH1m9cS7f6bw.png?1723051847" alt=""><figcaption></figcaption></figure>
* From the[ Access Overview](https://app.sprinto.com/app/admin/accessControl/overview) page, select Snowflake from the critical systems list.
* Click Configure or Manage from the Summary tab.
* Click Configure or Edit next to Access monitoring.<br>

  <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873976/original/iqFweaCW7o6Gbl5LET6i-gpXcPtW41ozSg.png?1723051846" alt=""><figcaption></figcaption></figure>
* Define the valid user access type for Snowflake.<br>

  <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72109873982/original/WccdasQ-OZCEb3XT4xPhVR0OmGn8zFIsDg.png?1723051847" alt=""><figcaption></figcaption></figure>

\
Please get in touch with [Sprinto Support](mailto:www.support@sprinto.com) if you have any queries related to the integration or need assistance.