Snowflake Connector for Python

The Snowflake Connector for Python provides an interface for developing Python applications that can connect to Snowflake and perform all standard operations. It provides a programming alternative to developing applications in Java or C/C++ using the Snowflake JDBC or ODBC drivers.

Starting with version 5.0, the connector is built on the Universal Core. The public interface remains the snowflake.connector module and PEP 249 Connection and Cursor objects. It can be installed using pip on Linux, macOS, and Windows where Python 3.11 or later is installed.

Note

If you are upgrading from a version before 5.0, see Upgrading to the Snowflake Connector for Python 5.0.0.

The connector supports developing applications using the Python Database API v2 specification (PEP-249), including using the following standard API objects:

  • Connection objects for connecting to Snowflake.
  • Cursor objects for executing DDL/DML statements and queries.

For more information, see PEP-249.

Note

Snowflake now provides first-class Python APIs for managing core Snowflake resources including databases, schemas, tables, tasks, and warehouses, without using SQL. For more information, see Snowflake Python APIs: Managing Snowflake objects with Python.

Next Topics: