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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 |
a5da1d7dfc4f393c81c9531e3248b35d2fd8bc03dd8b322383e69d459f87f267
|
|
MD5 |
51d8489697b82f4655e92bf10161246a
|
|
BLAKE2b-256 |
973b0f43f5453f508fd3e58c5a9b5f408cb0f8f7222c0296572136ea538dbd54
|
File details
Details for the file denodo_sqlalchemy-2.0.4-py3-none-any.whl
.
File metadata
- Download URL: denodo_sqlalchemy-2.0.4-py3-none-any.whl
- Upload date:
- Size: 40.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.11.2
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 |
4a88851a07cb727240815e1ef1fe70f14c0ed32868e8aadd65476ac8acb3bcf9
|
|
MD5 |
7b8cbe6d365dc3af91e850374102de65
|
|
BLAKE2b-256 |
302dc1ae7d9590916fc954b026b1c3ac95cdb6b2df5d315bec40bc520eb2adf1
|