Connecting to Snowflake

For information on the available WHL and TAR.GZ files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Snowflake can be installed and used in various Python 3.8, 3.9, 3.10, and 3.11 distributions.

Snowflake Version Support

The connector enables standards-based access to all Snowflake editions. You can authenticate with a Snowflake user, SSO, or SSL client authentication. After authenticating, you can execute standard SQL queries to Snowflake tables or set QueryPassthrough to use any of the available Snowflake SQL syntax. For example, you can use extended projection to project columns over semistructured data.

See Also

• Using the Connector: Establish connections and query Snowflake through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with Snowflake data using mapped classes and Sessions.