> For the complete documentation index, see [llms.txt](https://docs.sprinto.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sprinto.com/integrations/overview/snowflake-integration.md).

# 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](/monitors/authentication-and-access-monitors/resolve-sprinto-check-for-removing-access-for-offboarded-users.md)                                                    |
| User should be identified                              | [How to fix](/data-library/access/dashboard-actions/view-and-map-staff-access.md)                                                                                               |
| User access to critical system should be valid         | <p><a href="/pages/NCqV9BepFyI4nXfJArP4">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="/files/7kI0iklZJ23bsg9vYzfW" 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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sprinto.com/integrations/overview/snowflake-integration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.