Skip to main content
Feedback

RVR-SNFS-402

Issue summary

  • The error code RVR-SNFS-402 with the message "Snowflake Session get_masking_policies failed" indicates an issue with retrieving masking policies from Snowflake within Data Integration. This problem typically arises due to either permission issues or configuration settings within Snowflake that prevent Data Integration from accessing the required masking policies.

Action steps

To resolve the error, follow these steps:

  • Check Permissions: Verify that the Snowflake user account used by Data Integration has the necessary permissions to access masking policies. Specifically, ensure that the user has CREATE and APPLY MASKING POLICY permissions on the relevant schemas within Snowflake. Use the following Snowflake SQL commands to grant these permissions:

    GRANT CREATE MASKING POLICY ON SCHEMA `<schema_name>` TO ROLE `<role_name>`;
    GRANT APPLY MASKING POLICY ON ACCOUNT TO ROLE `<role_name>`;

  • Ensure Enterprise Edition: Make sure that your Snowflake account is on Enterprise Edition, as masking policies are available only on this edition.

  • Review Configuration: Double-check that masking policies are correctly configured and exist in the Snowflake environment. They should relate to the appropriate schemas and columns within your database.

  • Validate Role and Schema: Confirm that the correct role is in use when attempting to access these policies, and that the database and schema are correctly specified and accessible.

  • Data Integration Configuration: In the Data Integration platform, ensure you configure target and source Data Flows correctly to enforce these masking policies, if such an option is available in the Data Integration settings.

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.

On this Page