--- id: adbc-driver-snowflake version: "1.11.0" license: Apache-2.0 license_treatment: permissive maintenance: active --- # adbc-driver-snowflake — An ADBC driver for working with Snowflake. License: permissive · Maintenance: active · Downloads: 144.5K/mo ## 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 above — 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 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 - License: Apache-2.0 (permissive) - Python support: supports_current - Install friction: medium - Maintenance: active - Downloads: 144.5K/month (top 15,000 on PyPI) - Known vulnerabilities: none known ## Tags snowflake database driver python, adbc snowflake connector, dbapi 2.0 snowflake, python snowflake client, arrow adbc snowflake, snowflake, arrow-adbc, dbapi [View on SkillFed](https://skillfed.io/packages/adbc-driver-snowflake) · [View on PyPI](https://pypi.org/project/adbc-driver-snowflake/)