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
- Click the App Settings icon in the left sidebar.
- Navigate to the Native Integrations section and click the down arrow next to the Snowflake Integration.
- 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.
-
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:
- Complete the Username field.
- 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>
- Click Key Pair (Required), and upload a Snowflake key pair file.
- Complete the Role field.
Alternatively, you can download the Edit Script and run it in Snowflake.
-
-
Click Validate Credentials.
- Click Save.
- Click Confirm.
Remove a Snowflake integration
- Click the App Settings icon in the left sidebar.
- Navigate to the Native Integrations section and click the down arrow next to the Snowflake Integration.
- Click the checkbox to disable the integration.
-
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.
-
Click Validate Credentials.
- Click Save.
- Click Confirm.