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.

The connector is a native, pure Python package that has no dependencies on JDBC or ODBC. It can be installed using pip on Linux, macOS, and Windows platforms where a supported version of Python is installed.

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.

SnowSQL, the command line client provided by Snowflake, is an example of an application developed using the connector.

Next Topics: