Skip to content

You are viewing documentation for Immuta version 2022.5.

For the latest version, view our documentation for Immuta SaaS or the latest self-hosted version.

cancel

Manage Your Snowflake Integration

Audience: System Administrators

Content Summary: This page details how to manage the Snowflake integration.

To install the Snowflake integration, see Snowflake Installation Introduction.

Migrate from not Using Snowflake Governance Features to Using Snowflake Governance Features

Migration Troubleshooting
  • If multiple Snowflake integrations are enabled, they will all migrate together. If one fails, they will all revert to the Snowflake Standard integration.
  • If an error occurs during migration and the integration cannot be reverted, the integration must be disabled and re-enabled.
  1. Click the App Settings icon in the left sidebar.
  2. Click Native Integrations in the left panel.
  3. Scroll to the Snowflake Governance Features modal under Native Integration Settings and check the checkbox.
  4. Using the credentials entered to enable the Snowflake integration, fill out the Username and Password or Key Pair.
  5. Click Save.
  6. Click Confirm.

Migrate Back from Using Snowflake Governance Features to not Using Snowflake Governance Features

Please consult your Immuta professional.

Migration back to using the Snowflake integration without governance features is only intended to resolve any issues that occur during migration and regain utility of Immuta. Please consult your Immuta professional.

Access must be revoked.

Access to the Snowflake tables must be revoked when migrating back to using the Snowflake integration without governance features to prevent users from having access to the raw tables.

  1. Click the App Settings icon in the left sidebar.
  2. Click Native Integrations in the left panel.
  3. Scroll to the Snowflake Governance Features modal under Native Integration Settings and uncheck the checkbox.
  4. Using the credentials entered to enable the Snowflake integration, fill out the Username and Password or Username and Key Pair.
  5. Click Save.
  6. Click Confirm.

Edit a Snowflake Integration

Immuta requires temporary, one-time use of credentials with specific permissions.

When performing edits to an integration, Immuta requires temporary, one-time use of credentials with the following permissions:

  • CREATE DATABASE ON ACCOUNT WITH GRANT OPTION
  • CREATE ROLE ON ACCOUNT WITH GRANT OPTION
  • CREATE USER ON ACCOUNT WITH GRANT OPTION
  • MANAGE GRANTS ON ACCOUNT WITH GRANT OPTION
  1. Click the App Settings icon in the left sidebar.
  2. Navigate to the Native Integrations section and click the down arrow next to the Snowflake Integration.

  3. Edit the field you want to change or check a checkbox of a feature you would like to enable. Note any field shadowed is not editable, and the integration must be disabled and re-installed to change it.

    Snowflake Integration Editing

  4. From the Select Authentication Method Dropdown, select either Username and Password or Key Pair Authentication:

    • Username and Password option: Complete the Username, Password, and Role fields.

    • Key Pair Authentication option:

      1. Complete the Username field.
      2. Click Key Pair (Required), and upload a Snowflake key pair file.
      3. Complete the Role field.

    Snowflake Integration Editing Credentials

    Alternatively, you can download the Edit Script and run it in Snowflake.

  5. Click Validate Credentials.

  6. Click Save.
  7. Click Confirm.

Remove a Snowflake Integration

  1. Click the App Settings icon in the left sidebar.
  2. Navigate to the Native Integrations section and click the down arrow next to the Snowflake Integration.

  3. Click the checkbox to disable the integration.

    Disable Snowflake Integration

  4. Enter Username, Password, and Role that was entered when the integration was installed.

    Alternatively, you can download the Cleanup Script and run it in Snowflake.

  5. Click Validate Credentials.

  6. Click Save.
  7. Click Confirm.