Manage Snowflake Connection Settings

Manage Snowflake integration and connection settings

Run object sync

1. Navigate to the connection or connection-backed object.
2. Click Run Object Sync.

Edit the connection details

1. Click the Edit button in the Connection details box.
2. Edit the field you want:

   1. Host
   2. Port
   3. Warehouse
   4. Role: If you edit the role, ensure the new role has the required privileges to see the data objects.
   5. HTTP Proxy
   6. Authentication Method: If you are editing the authentication method to be a different system account user, grant the new system user the connection role and the role created from the setup script.
   7. Object Synchronization: Use the dropdown to select a new Start Time or Run Frequency.
3. Select Validate, and once the validation is successful, select Save.

Edit the policy settings

1. Click the Edit button in the Policy settings box.
2. Opt to enable or disable Impersonation.

   1. Enter the Impersonation Role.
3. Opt to edit to Exclude User Group Pattern.

   1. Enter a comma separated list of users and roles to exclude from policy.
4. Select Validate, and once the validation is successful, select Save.

Edit the audit settings

1. Click the Edit button in the Audit settings box.
2. Opt to enable or disable Query Audit: If you enable audit, ensure the system account has the required permissions for audit.
3. Select Validate, and once the validation is successful, select Save.

Edit the object settings

1. Click the Edit button in the Object settings box.
2. Opt to enable or disable Policy Synchronization: When policy sync is enabled, all child objects will be represented by Immuta data sources and policies will be applied to the data sources.
3. Opt to Add Users and Groups as data owners:

   1. Start typing in the text box and select the user or group from the dropdown.
   2. Click Add Owners.
4. Click Save.