Tableau is able to connect successfully using the old password and even using a PAT as long as the user is a Legacy user type in Snowflake. However, once we convert the same user to a SERVICE user type in Snowflake, Tableau starts reporting connection errors while editing the connection. Despite this, Snowflake logs show the connection as successful, which is confusing.
To validate this, we created a new data source using the same SERVICE credentials and PAT, and the connection worked perfectly. We were able to retrieve data without any issues. Even more strangely, for an existing data source that shows a failure when editing the connection using a PAT (via the three dots outside the data source), if we instead edit the entire data source from inside Tableau
and update it with the SERVICE PAT, it works fine. This inconsistent behavior strongly points to a Tableau-side issue, possibly related to caching or how Tableau handles user types.
Has anyone experienced this before or might know a solution to this?
#Tableau Cloud #Nonprofit #Snowflake