Fix 'Failed to import ArrowResult' with snowflake-connector-python on ARM

TL;DR

For "Failed to import ArrowResult. No Apache Arrow result set format can be used": no Apache Arrow result set format can be used because the published wheel's Arrow C extension linked against the wrong architecture (symbol-not-found errors for libarrow).

Failed to import ArrowResult. No Apache Arrow result set format can be used

Steps

1. On ARM Macs, importing snowflake-connector-python logs Failed to import ArrowResult. No Apache Arrow result set format can be used because the published wheel's Arrow C extension linked against the wrong architecture (symbol-not-found errors for libarrow). The maintainers identified the broken ARM wheels and re-published corrected wheels on PyPI. Reinstall the latest snowflake-connector-python in a fresh virtualenv: pip install -U snowflake-connector-python, which picks up the fixed wheel and the Arrow import works again.
2. I kept seeing Failed to import ArrowResult on an M1 Mac with connector 3.x. The thread maintainer confirmed they had updated the .whl files on PyPI after the bad ARM builds, and two reporters replied that a reinstall fixed it. Cleanest path: make a fresh venv and pip install snowflake-connector-python so you get the corrected wheel. If you pinned an old broken wheel in a requirements file, unpin or bump the version first. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/1452

Expected: The thread maintainer confirmed they had updated the.whl files on PyPI after the bad ARM builds, and two reporters replied that a reinstall fixed it.

When to use

You are seeing this: On ARM Macs, importing snowflake-connector-python logs Failed to import ArrowResult. Use this skill when you run into "Fix 'Failed to import ArrowResult' with snowflake-connector-python on ARM".

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

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

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/1452

Question asked in the thread: On ARM Macs, importing snowflake-connector-python logs Failed to import ArrowResult. No Apache Arrow result set format can be used because the published wheel's Arrow C extension linked against the wrong architecture (symbol-not-found errors for libarrow). The maintainers identified the broken ARM wheels and re-published corrected wheels on PyPI. Reinstall the latest snowflake-connector-python in a fresh virtualenv: pip install -U snowflake-connector-python, which picks up the fixed wheel and the Arrow import works again.

Verified answer: I kept seeing Failed to import ArrowResult on an M1 Mac with connector 3.x. The thread maintainer confirmed they had updated the .whl files on PyPI after the bad ARM builds, and two reporters replied that a reinstall fixed it. Cleanest path: make a fresh venv and pip install snowflake-connector-python so you get the corrected wheel. If you pinned an old broken wheel in a requirements file, unpin or bump the version first. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/1452

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