Registry / database / adbc-driver-snowflake

adbc-driver-snowflake

library1.11.0pypypi✓ verified 84d ago

An ADBC (Arrow Database Connectivity) driver for Snowflake, enabling high-performance data transfer using Apache Arrow. Version 1.11.0 requires Python >=3.10.

database data serialization

pip install adbc-driver-snowflake

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · ADBC-DRIVER-SNOWFL

adbc-driver-snowflake

databasepythonv1.11.0

Install

2.8s avg

Import

30ms

Disk

100MB

Pass rate

5/ 10

Env Coverage5 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v1.11.0 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

build_error

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 2.8s · import 0.030s · 107MB

100MB installed

● package 100MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

adbc_driver_snowflake

✓ import adbc_driver_snowflake

✗ import adbc_driver_snowflake.dbapi

Wrong submodule path; top-level import provides dbapi via adbc_driver_snowflake.dbapi

Connect to Snowflake using ADBC and fetch an Arrow batch converted to pandas.

import adbc_driver_snowflake.dbapi conn = adbc_driver_snowflake.dbapi.connect( 'snowflake://user:pass@account/database/schema?warehouse=warehouse_name' ) cur = conn.cursor() cur.execute("SELECT 1 AS col") print(cur.fetch_arrow_batch().to_pandas())

Debug

Known issues

breakingThe driver is not a DB-API 2.0 module directly; you must use the .dbapi submodule. Direct import of adbc_driver_snowflake does not expose connect()

fix

Use from adbc_driver_snowflake import dbapi, then dbapi.connect()

affects: >=0.1.0

gotchaConnection string must include warehouse as a query parameter; omitted warehouse may lead to errors about virtual warehouse not specified.

fix

Append ?warehouse=my_wh to the Snowflake URL.

affects: >=0.1.0

gotchaThe driver only supports Arrow data; fetching results via .fetchall() returns a list of Arrow arrays, not plain Python objects. Use fetch_arrow_batch() to get a RecordBatch.

fix

Use .fetch_arrow_batch() or .fetch_arrow_table() for pandas conversion.

affects: >=0.1.0

Errors

Common errors & fixes

ImportError: cannot import name 'connect' from 'adbc_driver_snowflake'

Trying to import connect from the top-level module instead of submodule dbapi.

fix

Use: from adbc_driver_snowflake import dbapi; conn = dbapi.connect(...)

Exception: No suitable driver found

Missing ADBC driver manager or incorrect installation of the Snowflake driver.

fix

pip install adbc-driver-manager adbc-driver-snowflake

pyarrow.lib.ArrowNotImplementedError: Unsupported cast from string to int64 using function cast

Incompatible schema or types between Snowflake and Arrow; often due to NULL handling.

fix

Ensure Snowflake columns are typed appropriately; use CAST in SQL if needed.

Upgrade

Version history

1.11.0latest on PyPI · released Apr 7, 2026

Audit

Dependencies

pyarrowrequiredRequired for Arrow data handling and ADBC interface

adbc-driver-manageroptionalOften needed to manage driver loading

Agent activity

55 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/apache/arrow-adbc ↗

packagehttps://pypi.org/project/adbc-driver-snowflake/ ↗

homepagehttps://arrow.apache.org/adbc/ ↗