Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Snowflake

Python Connector for Snowflake is a connectivity solution for accessing the Snowflake data cloud from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows and Windows Server.

Using the connector

To retrieve data from a database:

Import the module.

import devart.snowflake

Connect to a database using the connect() module method and obtain a connection object.

my_connection = devart.snowflake.connect(
    Domain="your_instance;",
    UserId="your_username",
    Password="your_password",Database="your_database;"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/snowflake/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/snowflake/activate-a-license.htm

What's new

Python Connector for Snowflake 1.2

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_snowflake_connector-1.2.0-cp313-cp313-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_snowflake_connector-1.2.0-cp313-cp313-win32.whl (5.4 MB view details)

Uploaded CPython 3.13 Windows x86

devart_snowflake_connector-1.2.0-cp312-cp312-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_snowflake_connector-1.2.0-cp312-cp312-win32.whl (5.4 MB view details)

Uploaded CPython 3.12 Windows x86

devart_snowflake_connector-1.2.0-cp311-cp311-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_snowflake_connector-1.2.0-cp311-cp311-win32.whl (5.4 MB view details)

Uploaded CPython 3.11 Windows x86

devart_snowflake_connector-1.2.0-cp310-cp310-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_snowflake_connector-1.2.0-cp310-cp310-win32.whl (5.4 MB view details)

Uploaded CPython 3.10 Windows x86

devart_snowflake_connector-1.2.0-cp39-cp39-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_snowflake_connector-1.2.0-cp39-cp39-win32.whl (5.4 MB view details)

Uploaded CPython 3.9 Windows x86

devart_snowflake_connector-1.2.0-cp38-cp38-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_snowflake_connector-1.2.0-cp38-cp38-win32.whl (5.4 MB view details)

Uploaded CPython 3.8 Windows x86

devart_snowflake_connector-1.2.0-cp37-cp37m-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_snowflake_connector-1.2.0-cp37-cp37m-win32.whl (5.4 MB view details)

Uploaded CPython 3.7m Windows x86

File details

Details for the file devart_snowflake_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 55f9eae1640144f1eeeee966cb5aa968e5c343ecf8a3af5455874137bdb27acd
MD5 dbaade18812f08eea4740870b233a512
BLAKE2b-256 54561b1208d99d1c606d513eea7ca19e02b0661dac092bcac2f16ee922bcac19

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 3924a2ddd50296fb67826d66027b1b79aa1b445c1ade7046371e586321386d52
MD5 f8a1909742d673e314b56cd51749d9f1
BLAKE2b-256 ebd98917bbb00d72c01e5223d74f7e3d0ee6ca3b90324f837d9f97645d8697e1

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 54b0e79d3a90cc11107e0e6ac01afd03c9069bea44cf3ad59dad7f4899974a57
MD5 98d6141f7a8a2c5f2e230df3002e1f43
BLAKE2b-256 ae43fc46d6311fa952d261d438b1834a807195b51a767eaf4489f125523069d2

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 6c0c488261508f5efd421b3d498ef872bd4f3ae0424f07a825c24892db0470dd
MD5 a5c5dcf46552988c032e02d07ef1d8ea
BLAKE2b-256 6430f1fda62ea48092bd8c7d15ea34b42ea89a25fed2c87a99c121e333d797c3

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 0c2f3a07be6f91c7b89206ad49ab2a0a52486378e3d4ffe06f6e131c9d97c247
MD5 a34999952cf9674e751a5ec241bb5018
BLAKE2b-256 e5e3aad43a6f079acaa7f17a405497475f0573050c55d59003b9bd963f869b56

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 80da019befd2b43951b6e0cc4bc2fef2fc4d69cc6dc7246cf54316a83e18cff4
MD5 48c0dee341426f831bd02ddfa92430be
BLAKE2b-256 bfe3cb822a3cb35947f0c6c9c1ac631da510d3ca7ccf7057b846fa4b3586cad9

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 3ca3544fa0eec0e340f3ef138ec2a3f32f4f7389f27b0f1817c18477344cb7f8
MD5 937db8186d5dedb711a909ba171132d2
BLAKE2b-256 2ce9b592fae6b0f69f80313c959dd723f5d1cba475c64fc6415a72ef446570c9

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 810659d0e1b802b0734c0de8aff3c665ee92b44d86fdb1896c2d2f6a130c8ed9
MD5 524cc59c7cf2044a8499c1ccdbb724ed
BLAKE2b-256 1fd20d42cc34f76aa46474eef53447d77d788c75d8b413e8273f4472d5c1b447

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 20c6232747952c812c4e4792a442f7d28f0d02b9d59216905c850918814b3709
MD5 739d322875775c510c23c9dc9fcc1fe0
BLAKE2b-256 31e470962230191cc69121303cd0339b39b9cb25d4c983e8c5fd1ac260d7ec7d

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 4d628e85a2479f57273b42c29f4224924d1e0efaa7e0fcd9f2685a84e65a496d
MD5 ab03216812fdea7c576cb5deb6db3c84
BLAKE2b-256 64f5bd97cb449a3a9369b1ebceacb11e3cb33aaed90c7cd8be4ec4c278fb495e

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 bb70a64f55bcda5ee6e1679602235c6238f4acee5168997ce526bd93da5252ac
MD5 6b832c548362f0f9f3369ef9d5cf58ea
BLAKE2b-256 0514aacd6e33a26f6943d8cfb8a8f684c6abba8b69771b351338eb335713bf38

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 301bba2ea9564e10948685630b5f6d32cb3db5490f262cbb141dcceccca03912
MD5 7fc4b52e16fdc091ec8d0096d45172cb
BLAKE2b-256 8881da5263e4fb5feb771b5861e46896f1d1e7a75330508081e7f5746c8c2a72

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 351314852c10d60a729987fa2ed636bde79b9564509e08d330fc9ca789447675
MD5 826450fe65d0167a3c4b95d6f7b534ee
BLAKE2b-256 559601eb2f9a233cc3600f12fdaa10269b1f0a6ac60850febb2fd79e290ea182

See more details on using hashes here.

File details

Details for the file devart_snowflake_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_snowflake_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 bfb4a155f4c2e8a771ad59ac281e3e74689ade5546e8a879023355a66895c4af
MD5 376034a9c1e68e4057be1c3a77fec99b
BLAKE2b-256 3c53994965040b074a908c75b3f9068bf2d15367f2429de8ebdf62fb7bb3de6c

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page