SNOW-2452663: Increased query latency from OCSP JWT auth requests

[colin-rogers-dbt]

When running dbt Core with snowflake-connector-python==3.12.1 we see an average query runtime of 1.24 versus 1.53s using 3.18.0 this difference appears to be a lot of calls to validate JWT tokens via AWS STS service. This impact is 2x greater the first time a thread makes a call but a small but consistent increase in latency persists.

Is there any known issue or configuration update we need to make on our end? Why are we making these AWS auth calls?

[sfc-gh-dszmolka]

hey @colin-rogers-dbt due to the WIF authentication method, we do have some extra calls. There's an AWS envvar to turn this off, or even in Snowflake Python driver 3.17.2 and up there's an internal param.
Please see both on the issue reported to dbt ;) dbt-labs/dbt-core#12011 (comment)
If this would be exposed to the users, they can hopefully easily mitigate. It's already exposed in the Snowflake drivers' connection configuration.

If you observe an entirely different issue, would you be able to please provide a minimal reproduction, or logfiles done with DEBUG level in Snowflake driver?

[sfc-gh-dszmolka]

closing due to inactivity