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 Rivery. This problem typically arises due to either permission issues or configuration settings within Snowflake that prevent Rivery from accessing the required masking policies.

2. Action Steps:

   • Check Permissions: Verify that the Snowflake user account used by Rivery 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.

   • Rivery Configuration: In the Rivery platform, ensure that the target and source rivers are configured correctly to enforce these masking policies, if such an option is available in the Rivery 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.
   • Rivery's documentation on connecting with Snowflake and managing permissions: Rivery Snowflake Connection.

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