arrow-left
All pages
gitbookPowered by GitBook
1 of 1

Loading...

Edit or Remove Your Snowflake Integration

circle-exclamation

Deprecation notice

Support for editing or deleting the Snowflake integration using this legacy workflow has been deprecated. Instead, manage your connection settings or deregister your connection.

To edit or remove a Snowflake integration, you have two options:

  • Automatic: Grant Immuta one-time use of credentials with the following privileges to automatically edit or remove the integration:

    • CREATE DATABASE ON ACCOUNT WITH GRANT OPTION

    • CREATE ROLE ON ACCOUNT WITH GRANT OPTION

    • CREATE USER ON ACCOUNT WITH GRANT OPTION

  • Manual: Run the Immuta script in your Snowflake environment as a user with the following privileges to edit or remove the integration:

    • CREATE DATABASE ON ACCOUNT WITH GRANT OPTION

    • CREATE ROLE ON ACCOUNT WITH GRANT OPTION

hashtag
Edit a Snowflake integration

Select one of the following options for editing your integration:

  • : Grant Immuta one-time use of credentials to automatically edit the integration.

  • : Run the Immuta script in your Snowflake environment yourself to edit the integration.

hashtag
Automatic edit

  1. Click the App Settings icon in the navigation menu.

  2. Click the Integrations tab 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

hashtag
Manual edit

  1. Click the App Settings icon in the navigation menu.

  2. Click the Integrations tab 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. Click edit script

hashtag
Remove a Snowflake integration

Select one of the following options for deleting your integration:

  • : Grant Immuta one-time use of credentials to automatically remove the integration and Immuta-managed resources from your Snowflake environment.

  • : Run the Immuta script in your Snowflake environment yourself to remove Immuta-managed resources and policies from Snowflake.

hashtag
Automatic removal

  1. Click the App Settings icon in the navigation menu.

  2. Click the Integrations tab and click the down arrow next to the Snowflake integration.

  3. Click the checkbox to disable the integration.

  4. Enter the Username, Password, and

hashtag
Manual removal

circle-exclamation

Cleaning up your Snowflake environment Until you manually run the cleanup script in your Snowflake environment, Immuta-managed and Immuta policies will still exist in Snowflake.

  1. Click the App Settings icon in the navigation menu.

  2. Click the Integrations tab and click the down arrow next to the Snowflake integration.

  3. Click the checkbox to disable the integration.

  4. Click cleanup script to download the script.

MANAGE GRANTS ON ACCOUNT WITH GRANT OPTION
CREATE USER ON ACCOUNT WITH GRANT OPTION
  • MANAGE GRANTS ON ACCOUNT WITH GRANT OPTION

  • APPLY MASKING POLICY ON ACCOUNT WITH GRANT OPTION

  • APPLY ROW ACCESS POLICY ON ACCOUNT WITH GRANT OPTION

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

  • Click Save.

  • to download the script, and then run it in Snowflake.
  • Click Save.

  • Role
    that was entered when the integration was configured.
  • Click Save.

  • Click Save.

  • Run the cleanup script in Snowflake.

  • Automatic
    Manual
    Automatic
    Manual
    roles