Just wondering if anyone else has had this issue after upgrading server to 2025.2.
We updated our server to 2025.2 last week. Since the update, we have noticed that the Snowflake bulk uploader using OAuth will throw a credential error at approximately 23 mintues and stop the workflow.
Here is the error:
Error SQLDriverConnect: The user you were trying to authenticate as differs from the user tied to the access token.[Snowflake][Snowflake] (17) 2 invalid keys are found in the connection string: Method Staging
We have been running these workflows in desktop designer (also version 2025.2) and all but one of them will run on desktop designer. This one workflow will run for approximately 23 mintutes, throw the same credential error as we are seeing on server, and stop the workflow. The only way we can get this ro run on desktop designer is to cache the data at the last tool prior to the output tool and then run the workflow using the cached data.
Note....other tools such as Stop Until Done, Control Containers do not stop the crediential error. We still see the credential erro at approximately 23 mintues and the workflow stops.
It's clearly not the OAUTH tokens, as we are using the same tokens for all the Snowlfake data pulls and pushes. The tokens are working in other workflows with no issues.
I've submitted a ticket with support, who says we must use the SIMBA driver or they can't help us. Every time we've used the SIMBA driver, it has been very unreliable. Snowflake recommends using their driver and that is what we use.
I am testing the SIMBA driver, to see if anything has changed there.
