Snowflake Connector for Python

.

Related Topics

.

Related Info

For a tutorial on using the Snowflake Connector for Python, see the following page:

For information about changes in the latest version of the Snowflake Connector for Python, see the following page:

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 Python 3.6, 3.7, 3.8, or 3.9 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.

Note

The Snowflake Connector for Python does not currently support multiprocessing (e.g. the multiprocessing Python package), due to problems with multiple processes accessing the Online Certificate Status Protocol (OCSP) cache at the same time.

Next Topics: