Skip to main content

Denodo Dialect for SQLAlchemy

Project description

This package includes the Denodo Dialect for SQLAlchemy, which offers an easy way to connect to Denodo databases from SQLAlchemy https://www.sqlalchemy.org/

Denodo documentation and software resources are available at https://community.denodo.com

This dialect supports Denodo 8.0 and higher.

Pre-requisites

Python 3.9 or newer is needed.

This dialect requires the following Python modules:

  • SQLAlchemy 1.4.36 or higher. SQLAlchemy 2.0.x is recommended.
  • psycopg2 version 2.9.6 or higher.

These Python modules are also required dependencies in order to use Denodo Virtual DataPort's Flight SQL interface (available since Denodo 9.1):

  • SQLAlchemy 2.0.0 or higher.
  • adbc-driver-flightsql version 1.3.0.
  • pyarrow version 19.0.0.

Required dependencies will be installed automatically, in order to install dependencies for Flight SQL the flightsql extras package needs to be installed:

pip install denodo-sqlalchemy[flightsql]

Alternatively, dependency packages can be installed manually:

pip install sqlalchemy~=2.0.0
pip install psycopg2-binary>=2.9.6
pip install adbc-driver-flightsql~=1.3.0
pip install pyarrow~=19.0.0

Important: note also that psycopg2 has its own requirements for installation which need to be satisfied: https://www.psycopg.org/docs/install.html#prerequisites

Installation

The Denodo Dialect for SQLAlchemy can be installed from the public PyPI repository using pip:

pip install --upgrade denodo-sqlalchemy

Or (only for Denodo 9.1+):

pip install --upgrade denodo-sqlalchemy[flightsql]

pip automatically installs all required dependencies.

Usage

To connect to Denodo VDP Server with SQLAlchemy, the following URL pattern can be used:

denodo://<username>:<password>@<host>:<port[9996]>/<database>

This will create a connection using the default driver psycopg2, so it is equivalent to:

denodo+psycopg2://<username>:<password>@<host>:<port[9996]>/<database>

In order to create a connection using Flight SQL, you would need:

denodo+flightsql://<username>:<password>@<host>:<port[9994]>/<database>

Please note that Flight SQL connections assume SSL is enabled at the server. If not, you would need to add the use_encryption parameter set to False, like:

engine = sqlalchemy.create_engine("denodo+flightsql://<username>:<password>@<host>:<port[9994]>/<database>", connect_args={"use_encryption":"false"})

Project details


Download files

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

Source Distribution

denodo_sqlalchemy-2.0.4.tar.gz (29.4 kB view details)

Uploaded Source

Built Distribution

denodo_sqlalchemy-2.0.4-py3-none-any.whl (40.7 kB view details)

Uploaded Python 3

File details

Details for the file denodo_sqlalchemy-2.0.4.tar.gz.

File metadata

  • Download URL: denodo_sqlalchemy-2.0.4.tar.gz
  • Upload date:
  • Size: 29.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.11.2

File hashes

Hashes for denodo_sqlalchemy-2.0.4.tar.gz
Algorithm Hash digest
SHA256 a5da1d7dfc4f393c81c9531e3248b35d2fd8bc03dd8b322383e69d459f87f267
MD5 51d8489697b82f4655e92bf10161246a
BLAKE2b-256 973b0f43f5453f508fd3e58c5a9b5f408cb0f8f7222c0296572136ea538dbd54

See more details on using hashes here.

File details

Details for the file denodo_sqlalchemy-2.0.4-py3-none-any.whl.

File metadata

File hashes

Hashes for denodo_sqlalchemy-2.0.4-py3-none-any.whl
Algorithm Hash digest
SHA256 4a88851a07cb727240815e1ef1fe70f14c0ed32868e8aadd65476ac8acb3bcf9
MD5 7b8cbe6d365dc3af91e850374102de65
BLAKE2b-256 302dc1ae7d9590916fc954b026b1c3ac95cdb6b2df5d315bec40bc520eb2adf1

See more details on using hashes here.

Supported by

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