RVR-SNFS-402

1. 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.

2. Action 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 be associated with the appropriate schemas and columns within your database.

   • Validate Role and Schema: Confirm that the correct role is being used 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 that the target and source rivers are configured correctly to enforce these masking policies, if such an option is available in the Data Integration settings.

3. External References:

   • For more information on how to manage and apply masking policies in Snowflake, please refer to the Snowflake documentation: Snowflake Masking Policies.
   • Data Integration documentation on connecting with Snowflake and managing permissions: Data Integration Snowflake Connection.

If the issue persists or you need further assistance, please open a ticket with Data Integration support.