RVR-SNFS-403

Issue summary

The error "Snowflake Session set_masking_policies_on_table failedError Code: RVR-SNFS-403" suggests a failure in applying or setting masking policies in Snowflake while using Data Integration. This error could relate to inadequate permissions, incorrect configuration, or issues with the masking policy itself.
From the Data Integration documentation, using the "Enforce Masking Policy" feature involves specific prerequisites and permissions in Snowflake. It is essential to ensure that your account isset up correctly with the appropriate permissions, and you are operating under Snowflake Enterprise Edition.

Action steps

To resolve the error, follow these steps:

Verify Permissions: Ensure that the Snowflake user has the required permissions to create and apply masking policies. The user should have permissions such as CREATE MASKING POLICY and APPLY MASKING POLICY on the relevant schema and account.
Check Snowflake Version: Make sure your Snowflake account is under the Enterprise Edition as the masking policy features might be limited in other versions.
Confirm Existing Masking Policy: Ensure that the masking policy you are trying to enforce is correctly defined and exists within the Snowflake database and schema you are working with. This is crucial because if no masking policy relates to the target table, the operation will fail.
Run Necessary Commands: Use Snowflake’s securityadmin role to grant necessary permissions using the following commands:
```
use role securityadmin;
grant create masking policy on schema `<schema_name>` to role `<role_name>`;
grant apply masking policy on account to role `<role_name>`;
```
Replace <schema_name> and <role_name> with your actual schema and role names【4:0†Data Integration Documentation 202408 (2).pdf】.

External references

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.