Fix Snowflake connector NotSupportedError on Apple M1

TL;DR

For "snowflake.connector.errors.NotSupportedError: Unknown error": upgrade to 2.7.8 or newer.

snowflake.connector.errors.NotSupportedError: Unknown error

Steps

1. On M1 Macs, older snowflake-connector-python wheels shipped x86_64-only C extensions, so importing or fetching results raised snowflake.connector.errors.NotSupportedError: Unknown error (the Arrow C extension could not load). The maintainers started publishing macOS ARM wheels with release 2.7.8. Upgrade to 2.7.8 or newer. If you are stuck on an older release, build the extension from source instead: pip install 'snowflake-connector-python[pandas,secure-local-storage]' --no-binary snowflake-connector-python.
2. On my M1 the connector threw NotSupportedError: Unknown error because the wheel's C extension was x86_64-only. Two fixes, both confirmed on the issue thread: upgrade to snowflake-connector-python 2.7.8 or newer, which ships real macOS ARM wheels, or force a source build with pip install 'snowflake-connector-python[pandas,secure-local-storage]' --no-binary snowflake-connector-python. The collaborator reply confirmed ARM wheels started shipping in 2.7.8, and users verified both approaches. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/986

When to use

You are seeing this: The maintainers started publishing macOS ARM wheels with release 2.7.8. Use this skill when you run into "Fix Snowflake connector NotSupportedError on Apple M1".

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: 2.7.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/986

Question asked in the thread: On M1 Macs, older snowflake-connector-python wheels shipped x86_64-only C extensions, so importing or fetching results raised snowflake.connector.errors.NotSupportedError: Unknown error (the Arrow C extension could not load). The maintainers started publishing macOS ARM wheels with release 2.7.8. Upgrade to 2.7.8 or newer. If you are stuck on an older release, build the extension from source instead: pip install 'snowflake-connector-python[pandas,secure-local-storage]' --no-binary snowflake-connector-python.

Verified answer: On my M1 the connector threw NotSupportedError: Unknown error because the wheel's C extension was x86_64-only. Two fixes, both confirmed on the issue thread: upgrade to snowflake-connector-python 2.7.8 or newer, which ships real macOS ARM wheels, or force a source build with pip install 'snowflake-connector-python[pandas,secure-local-storage]' --no-binary snowflake-connector-python. The collaborator reply confirmed ARM wheels started shipping in 2.7.8, and users verified both approaches. Source: https://github.com/snowflakedb/snowflake-connector-python/issues/986

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