RVR-LSNF-105

1. Issue Summary

   • The error RVR-LSNF-105 indicates "Invalid authentication credentials" with the Snowflake data connector in Rivery. This error typically arises when there is a mismatch or incorrect configuration in the connection details used to authenticate with Snowflake.

2. Action Steps:

   • Verify the credentials used in the Snowflake connection:
     • Ensure that the username and password provided are correct. Note that Snowflake passwords must adhere to specific restrictions, and special characters like {, }, ", ?, /, #, and * are typically not allowed.
   • Confirm that the account name is correctly set. This should match the format as displayed in the Snowflake account URL, like account-name.region.cloudprovider (e.g., account-name.eu-central-1.gcp).
   • Check if the warehouse name specified in the connection is correct and exists within the Snowflake environment. Also, verify that the role assigned has access to this warehouse.
   • Test the connection in Rivery again after making any changes to ensure that the setup is correct.
   • If you are using Key-Pair Authentication, ensure the RSA public key is correctly set as part of the Snowflake user's authentication setup.

3. External References:

   • For more detailed guidance on setting up Snowflake connections and managing credentials, refer to Rivery's official documentation: Rivery Snowflake Connection Guide.
   • For more information on setting up authentication and network policies in Snowflake, visit: Snowflake - Key-Pair Authentication.

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