adbc-driver-snowflake

What it is and what it does

This package wraps the Apache Arrow ADBC Snowflake driver to expose a standard DBAPI 2.0 (PEP 249) interface for Python applications connecting to Snowflake. It sits on top of the adbc-driver-manager and provides familiar cursor and connection objects that developers expect from Python database libraries.

The driver is maintained as part of the Apache Arrow project and supports current Python versions (3.10+). It is distributed as precompiled wheels for common platforms (macOS, Linux, Windows across x86_64 and ARM architectures), though building from source requires the native Snowflake driver library and an environment variable to be set. It has no known security vulnerabilities and receives active maintenance.

Use it for:

• Execute SQL queries against Snowflake from Python using standard DBAPI 2.0 cursor and connection patterns
• Integrate Snowflake data access into ETL pipelines or data processing workflows that expect a DBAPI-compatible database driver
• Build applications that need to switch between multiple databases by using a standardized interface
• Fetch and process Snowflake query results in Python data analysis or reporting scripts

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a DBAPI 2.0-compatible interface to Snowflake via the ADBC driver manager, enabling standard Python database operations against Snowflake warehouses.

Yes, if you need to connect to Snowflake from Python and prefer a DBAPI 2.0-compatible interface. The package is actively maintained, has no known vulnerabilities, and is distributed as precompiled wheels for most platforms. Medium install friction is mainly a concern if building from source; prebuilt wheels are straightforward. Suitable for production use in applications requiring Snowflake connectivity.

Install

adbc-driver-snowflake on PyPI

pip install adbc-driver-snowflake

uv add adbc-driver-snowflake

poetry add adbc-driver-snowflake

Installing adbc-driver-snowflake

Before you install

Medium install friction due to precompiled wheels for multiple platforms (macOS x86_64/arm64, Linux x86_64/aarch64, Windows) and a requirement to set ADBC_SNOWFLAKE_LIBRARY environment variable during build from source. Maintenance is active with recent commits and no known vulnerabilities.

License in practice

Licensed under Apache-2.0 (permissive), allowing use in most commercial and open-source projects with minimal restrictions.

Quickstart

pip install adbc-driver-snowflake

import adbc_driver_snowflake.dbapi
conn = adbc_driver_snowflake.dbapi.connect(uri='snowflake://...')
cursor = conn.cursor()
cursor.execute('SELECT * FROM table')
results = cursor.fetchall()

Requires Python >=3.10. Building from source requires setting ADBC_SNOWFLAKE_LIBRARY environment variable to the path of the Snowflake driver library before pip install.

Verify before relying

• Whether PyArrow is required or optional for the DBAPI 2.0 interface
• Specific Snowflake authentication methods and credential handling supported
• Performance characteristics and connection pooling capabilities

Package facts

Evidence: adbc_driver_snowflake-1.11.0-py3-none-macosx_10_15_x86_64.whl; adbc_driver_snowflake-1.11.0-py3-none-macosx_11_0_arm64.whl; adbc_driver_snowflake-1.11.0-py3-none-manylinux1_x86_64.manylinux_2_28_x86_64.manylinux_2_5_x86_64.whl; adbc_driver_snowflake-1.11.0-py3-none-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl; adbc_driver_snowflake-1.11.0-py3-none-win_amd64.whl

Tags

More Database packages