RVR-LSNF-105
Issue summary
- The error
RVR-LSNF-105indicates "Invalid authentication credentials" with the Snowflake data connector in Data Integration. This error typically arises when there is a mismatch or incorrect configuration in the connection details used to authenticate with Snowflake.
Action steps
To resolve the error, follow these 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.
- Ensure that the username and password provided are correct. Note that Snowflake passwords must adhere to specific restrictions, and special characters like
- 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 Data Integration 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.
External references
- For more detailed guidance on setting up Snowflake connections and managing credentials, refer to Data Integration official documentation: Data Integration Snowflake Connection Guide.
- For more information on setting up authentication and network policies in Snowflake, visit: Snowflake - Key-Pair Authentication.
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.
