Python Connector for Snowflake
Python Connector for Snowflake icon

Python Connector for Snowflake

by Devart
$74.95
Python Connector for Snowflake boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server
System Requirements
Python 3.10 to 3.15. Windows or Windows Server, 32-bit or 64-bit. A Snowflake account. Internet access for subscription license checks
File Size
20.37 MB
Release Date
10/22/2026
Last Updated
11/18/2026
1 views 0 downloads
DB API 2.0 Python connector for Snowflake on Windows, with OAuth and key pair

Devart Python Connector for Snowflake: A DB API Driver for Snowflake on Windows

Devart Python Connector for Snowflake is a paid Python database module, $74.95 a year for one developer, that runs SQL against the Snowflake data cloud from Python 3.10-3.15 on Windows only. It follows the Python DB API 2.0 standard, signs in with a password, OAuth 2.0 or a key pair, and adds connection pooling, local caching and batched updates.

Snowflake publishes its own free, open-source Python connector, which runs on Windows, macOS and Linux and is what most Snowflake teams use. Devart's connector is aimed at Windows shops that already standardize on Devart's drivers and want the same connection style, licensing and support for Snowflake as for their other databases.

Quick facts

  • Version: 1.4.0, released October 22, 2026; first released April 25, 2024
  • Developer: Devart
  • Package: pip install devart-snowflake-connector, or wheel files from Devart's download page (20.37 MB for Windows)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Platforms: Windows and Windows Server, 32-bit and 64-bit; no macOS or Linux build
  • Sign-in: user name and password, OAuth 2.0, or key pair (OAuth and key pair added in 1.4)
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription, and PyPI and Devart's download page both showed version 1.4.0 with Windows-only wheels, on November 18, 2026. We didn't connect it to a Snowflake account

Download Free Trial Buy Now

Overview

You import devart.snowflake and call connect() with your account's Domain, UserId, Password and Database, then work with a cursor as in any DB API module. For OAuth, snowflake.signin() with a client ID and secret returns a refresh token that you pass to connect(Authentication="OAuth", ...); for key-pair sign-in you pass Authentication="KeyPair" with the private key and its passphrase.

Queries use standard SQL, including Snowflake's functions, operators and conditional expressions, with ? placeholders for parameters. The connector maps Snowflake data types to Python types, with options to adjust the mapping.

Features

Three ways to sign in

Python Connector for Snowflake supports basic user-and-password sign-in, OAuth 2.0 with a client ID, secret and refresh token, and key-pair authentication with an optionally encrypted private key. Version 1.4, released October 2026, added OAuth and key pair.

Pooling, caching and batches

Python Connector for Snowflake pools connections to cut connection time, caches data locally for repeat reads, and sends several update statements to Snowflake as one batch to speed up writes.

Standard SQL and full type support

Python Connector for Snowflake supports Snowflake's standard SQL syntax, functions and conditional expressions, and every Snowflake data type, with options to control how they map to Python types. It's Unicode-compliant, so multilingual data reads and writes correctly.

Same API as Devart's other connectors

Python Connector for Snowflake uses the same connect, cursor and license calls as Devart's Python connectors for PostgreSQL, SQL Server, Oracle and others, so code and habits carry over between databases.

Benefits

  • Modern sign-in. Key pair and OAuth keep passwords out of scheduled scripts.
  • Faster repeat work. Pooling and local caching help scripts that query the same data again and again.
  • One vendor for all drivers. One licensing model and support desk across a company's Python database connectors.

Real-World Uses

  • Scheduled Windows reports. A Task Scheduler job on a Windows server pulls daily figures from Snowflake with key-pair sign-in.
  • Loading results back. A Python script batches thousands of UPDATE statements into Snowflake after a calculation.
  • Mixed-database scripts. A script reads from SQL Server and Snowflake with Devart connectors that share the same calls.

Who It's For, and Who Should Skip It

The connector suits Windows-based data teams that already license Devart's Python connectors and want Snowflake under the same license and support contract.

Skip it if you work on macOS or Linux, or deploy to Linux containers: there's no build for them. Most other Snowflake users are better served by Snowflake's own free connector, which also brings pandas integration and Snowflake's own support for new features.

Usage Guide

  1. Install with pip install devart-snowflake-connector on Windows, or download the wheel for your Python version.
  2. After buying, activate with devart.snowflake.license.activate("<key>") using the key from the order email or customer portal.
  3. Connect: conn = snowflake.connect(Domain="<account>.snowflakecomputing.com", UserId="...", Password="...", Database="SALES"), or use OAuth or KeyPair authentication.
  4. Query: cur = conn.cursor(), cur.execute("SELECT * FROM orders WHERE region = ?", ["EU"]), cur.fetchall().
  5. Turn on pooling for web services or frequent scripts.

Before you buy

This connector runs only on Windows. If any part of your pipeline runs on Linux, such as Airflow, Docker or a cloud function, it can't use this connector there. The subscription license also needs internet access to activate and check its status.

Where it falls short

  • Windows only. No macOS or Linux wheels.
  • Free official alternative. Snowflake's own Python connector is open source and cross-platform.
  • No asyncio API. It's a synchronous DB API 2.0 driver.
  • Per-developer licensing. A team of up to four needs the Team license.

Comparisons

Devart vs. Snowflake's own Python connector

Snowflake's connector (snowflake-connector-python) is free, open source, runs everywhere and supports pandas and Snowflake-specific features first. Devart's costs $74.95 a year, runs only on Windows, and offers Devart's common API, pooling, local caching and vendor support. For most teams Snowflake's own connector is the default.

Python connector vs. Devart's ODBC driver for Snowflake

Devart's ODBC driver for Snowflake also serves Excel, Power BI and any ODBC tool, as well as Python through pyodbc. If Python is the only consumer, the Python connector costs less; if reports and scripts both need Snowflake, the ODBC driver covers both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
Team$189.95On the order pageUp to 4 developers at one company site
Site$339.95On the order pageUnlimited developers at one company site

Buy Now opens the order for Python Connector for Snowflake with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.

FAQs

Does Python Connector for Snowflake run on macOS or Linux?

No. Python Connector for Snowflake is distributed only as Windows wheels for 32-bit and 64-bit Python, on Windows and Windows Server.

Does Python Connector for Snowflake support key-pair authentication?

Yes. Python Connector for Snowflake 1.4, released October 2026, added key-pair authentication and OAuth 2.0 alongside user-and-password sign-in.

Which Python versions does Python Connector for Snowflake support?

Python Connector for Snowflake 1.4 supports Python 3.10 to 3.15.

Does the subscription keep working offline?

No. Python Connector for Snowflake's subscription license needs an internet connection to activate and check its status. The perpetual license doesn't need a running subscription.

Can I ship the connector inside an application I sell?

Only with an OEM license. Python Connector for Snowflake's Single, Team and Site licenses cover developing and deploying your own scripts within one company.

Can I get a refund on Python Connector for Snowflake?

Possibly. Python Connector for Snowflake's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

System Requirements

  • Python 3.10 to 3.15, 32-bit or 64-bit, with pip
  • Windows or Windows Server, 32-bit or 64-bit
  • A Snowflake account reachable over HTTPS
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for Snowflake makes sense for a Windows-only team that already standardizes on Devart's Python connectors and wants Snowflake under the same license, API and support. For almost everyone else, Snowflake's free, cross-platform connector is the better buy, and its Windows-only build rules it out for Linux pipelines. If it fits, try it against your own account with the 30-day trial.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.