Skip to content

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.

Additional Tutorials Contents:

  • Update a Snowflake Instance
  • Remove a Snowflake Instance

Migrate from not Using Snowflake Governance Features to Using Snowflake Governance Features (Public Preview)

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 Preview Features in the left panel.
  3. Scroll to the Native Snowflake Governance Controls modal and check the checkbox.
  4. Using the credentials entered to enable the Snowflake integration, fill out the Username, Password, and Key Pair.
  5. Click Save.
  6. Click Confirm.

Migrate Back from Using Snowflake Governance Features to not Using Snowflake Governance Features (Public Preview)

Please consult your Immuta professional.

Migration back to using the Snowflake integration without Snowflake 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 Snowflake Governance Features to prevent users from having access to the raw tables.

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

Additional Tutorials

  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. Enter Username, Password, and Role.

    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

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