Troubleshooting
Problem
Customers may encounter a failure when using the Snowflake Database connector, where the connector is unable to establish a successful connection and returns a 405 error.
Symptom
- Connector shows a failed status
- Connection attempts to Snowflake fails
- Error message observed:{"errorCode":405,"errorMessage":"java.lang.NullPointerException"}
Cause
The problem is that Snowflake is deprecating basic username/password authentication and is now requiring OAuth 2.0/SSO logins to meet enhanced security and enterprise identity‑compliance standards.
The current Datalink setup supports programmatic access tokens, which can replace a password for Snowflake connections. By entering the PAT in the password field, the connection succeeds and authentication occurs via token‑based access rather than the traditional password method.
Note: This approach is a temporary workaround until Apptio delivers a permanent fix.
Diagnosing The Problem
To identify the issue, follow these steps:
Navigate to the Datalink application.
Open the Snowflake Database Connector.
Run the connector.
Observe the following error during execution:
{"errorCode":405,"errorMessage":"java.lang.NullPointerException"}
This confirms a connector execution failure and indicates a connectivity or authentication issue.
Resolving The Problem
Configure the connector to use Programmatic Access Tokens (PATs):
Generate a PAT in Snowflake with the required access permissions.
Link: https://docs.snowflake.com/en/user-guide/programmatic-access-tokens#label-pat-use-p
Open the Snowflake Database Connector configuration.
Enter the PAT in the Password field.
Save the configuration and test the connection.
Run the connector to validate successful execution.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
20 February 2026
UID
ibm17260064