This project is archived. Its data is read-only.

Long runs cause the authentication token to expire

See https://gitlab.com/meltano/analytics/-/jobs/118555756

snowflake.connector.errors.ProgrammingError: 390114 (08001): Authentication token has expired.  The user must authenticate again.

This is pretty bad, as the raised exception gives us no chance to explicitly catch it and try a new login. I think we'll have to catch all and compare with the error code.

@iroussos do you have any idea how to implement a token refresh with the snowflake connector? Should we simply re-create the engine? Should that be handled by snowflake-sqlalchemy?

Assignee Loading
Time tracking Loading