Fix Snowflake OperationalError 250003 after requests 2.24.0 release

TL;DR

Connections started failing with snowflake.connector.errors.OperationalError: 250003: Failed to execute request right after requests 2.24.0 shipped, because the connector was not yet compatible with it. Pin requests back: pip install 'requests==2.23.0'.

snowflake.connector.errors.OperationalError: 250003: Failed to execute request

Steps

1. Connections started failing with snowflake.connector.errors.OperationalError: 250003: Failed to execute request right after requests 2.24.0 shipped, because the connector was not yet compatible with it. The maintainer confirmed the connector did not support requests 2.24.0 at the time. Pin requests back: pip install 'requests==2.23.0'. Longer term, upgrade to snowflake-connector-python v2.3.8 or newer, which vendors requests and urllib3 so the environment's requests version no longer matters.
2. Everything broke the day requests 2.24.0 came out with 250003: Failed to execute request. The connector team confirmed on the thread that requests 2.24.0 was unsupported. Pinning requests==2.23.0 fixed it immediately for me. If you cannot pin, upgrade the connector itself to 2.3.8+, which vendors its own requests and urllib3 so a new requests release cannot break it again. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/324

Expected: The maintainer confirmed the connector did not support requests 2.24.0 at the time.

When to use

You are seeing this: The maintainer confirmed the connector did not support requests 2.24.0 at the time. Use this skill when you run into "Fix Snowflake OperationalError 250003 after requests 2.24.0 release".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: requests 2.24.0, requests 2.23.0, v2.3.8, 2.3.8. If you are on something much newer or older, the details may have shifted.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://github.com/snowflakedb/snowflake-connector-python/issues/324

Question asked in the thread: Connections started failing with snowflake.connector.errors.OperationalError: 250003: Failed to execute request right after requests 2.24.0 shipped, because the connector was not yet compatible with it. The maintainer confirmed the connector did not support requests 2.24.0 at the time. Pin requests back: pip install 'requests==2.23.0'. Longer term, upgrade to snowflake-connector-python v2.3.8 or newer, which vendors requests and urllib3 so the environment's requests version no longer matters.

Verified answer: Everything broke the day requests 2.24.0 came out with 250003: Failed to execute request. The connector team confirmed on the thread that requests 2.24.0 was unsupported. Pinning requests==2.23.0 fixed it immediately for me. If you cannot pin, upgrade the connector itself to 2.3.8+, which vendors its own requests and urllib3 so a new requests release cannot break it again. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/324

Thread: https://vectle.com/threads/thr_Ku3SrkawNw5NQGjBRpapNA