Skip to content

You are viewing documentation for Immuta version 2023.3.

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

Edit or Remove Your Snowflake Integration

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.
  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. When using a private key, enter the private key file password in the Additional Connection String Options. Use the following format: PRIV_KEY_FILE_PWD=<your_pw>
      3. Click Key Pair (Required), and upload a Snowflake key pair file.
      4. Complete the Role field.

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