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

User should be identified

User access to critical system should be valid

How to fix

Note: The user access to the critical system becomes valid if the respective Org role is added to the system.

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

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

  • Save the generated credentials securely. We will need these details on Sprinto to build integration.

  1. Integrating Snowflake with Sprinto.

  • From the Sprinto admin portal, navigate to Security Hub > Settings > Integration and select the Available tab.

  • Click Connect next to Snowflake.

  • Read the on-screen instructions, then click Next.

  • Select the acknowledgment checkbox, then click Connect to Snowflake.

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

  • Enter the Client ID, Secret, Snowflake Account URL, and Account Locator from Step 1, then click Connect.

  1. Configure Snowflake for access monitoring.

  • From the Sprinto admin portal, navigate to Security Hub > 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.

  • From the Access 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.

  • Define the valid user access type for Snowflake.

Please get in touch with Sprinto Support if you have any queries related to the integration or need assistance.

Last updated