# SQLAlchemy Dremio
A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.
<!--ts-->
* [Installation](#installation)
* [Usage](#usage)
* [Testing](#testing)
* [Superset Integration](#superset-integration)
<!--te-->
Installation
------------
From pip:
-----------
`pip install sqlalchemy_dremio`
Or from conda:
--------------
`conda install sqlalchemy-dremio`
To install from source:
`python setup.py install`
Usage
-----
Connection String example:
Dremio Software:
`dremio+flight://user:password@host:port/dremio`
Dremio Cloud:
`dremio+flight://data.dremio.cloud:443/?Token=<TOKEN>UseEncryption=true&disableCertificateVerification=true`
Options:
Schema - (Optional) The schema to use
TLS:
UseEncryption=true|false - (Optional) Enables TLS connection. Must be enabled on Dremio to use it.
DisableCertificateVerification=true|false - (Optional) Disables certificate verirication.
WLM:
https://docs.dremio.com/software/advanced-administration/workload-management/#query-tagging--direct-routing-configuration
routing_queue - (Optional) The queue in which queries should run
routing_tag - (Optonal) Routing tag to use.
routing_engine - (Optional) The engine in which the queries should run
Superset Integration
-------------
The ODBC connection to superset is now deprecated. Please update sqlalchemy_dremio to 3.0.2 to use the flight connection.
Release Notes
-------------
3.0.4
-----
- Addressing issue #34 and #37: Add driver name to dialects
3.0.3
-----
- Add back missing routing_engine property.
3.0.2
-----
- Add implementations of has_table and get_view_names.
3.0.1
-----
- Made connection string property keys case-insensitive
- Fix incorrect lookup of the token property
- Fix incorrect lookup of the DisableCertificateVerification property
Raw data
{
"_id": null,
"home_page": "https://github.com/narendrans/sqlalchemy_dremio",
"name": "sqlalchemy-dremio",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "sqlalchemy_dremio",
"author": "Naren",
"author_email": "me@narendran.info",
"download_url": "https://files.pythonhosted.org/packages/5c/6d/5f88c84e5c4c616c6c25b3ab44e91487272baaa8c701365ccec09267c916/sqlalchemy_dremio-3.0.4.tar.gz",
"platform": null,
"description": "# SQLAlchemy Dremio\r\n\r\n\r\n\r\n\r\n\r\nA SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.\r\n\r\n<!--ts-->\r\n * [Installation](#installation)\r\n * [Usage](#usage)\r\n * [Testing](#testing)\r\n * [Superset Integration](#superset-integration)\r\n<!--te-->\r\n\r\nInstallation\r\n------------\r\n\r\nFrom pip:\r\n-----------\r\n\r\n`pip install sqlalchemy_dremio`\r\n\r\nOr from conda:\r\n--------------\r\n`conda install sqlalchemy-dremio`\r\n\r\nTo install from source:\r\n`python setup.py install`\r\n\r\nUsage\r\n-----\r\n\r\nConnection String example:\r\n\r\nDremio Software:\r\n\r\n`dremio+flight://user:password@host:port/dremio`\r\n\r\nDremio Cloud:\r\n\r\n`dremio+flight://data.dremio.cloud:443/?Token=<TOKEN>UseEncryption=true&disableCertificateVerification=true`\r\n\r\nOptions:\r\n\r\nSchema - (Optional) The schema to use\r\n\r\nTLS:\r\n\r\nUseEncryption=true|false - (Optional) Enables TLS connection. Must be enabled on Dremio to use it.\r\nDisableCertificateVerification=true|false - (Optional) Disables certificate verirication.\r\n\r\nWLM:\r\n\r\nhttps://docs.dremio.com/software/advanced-administration/workload-management/#query-tagging--direct-routing-configuration\r\n\r\nrouting_queue - (Optional) The queue in which queries should run\r\nrouting_tag - (Optonal) Routing tag to use.\r\nrouting_engine - (Optional) The engine in which the queries should run\r\n\r\nSuperset Integration\r\n-------------\r\n\r\nThe ODBC connection to superset is now deprecated. Please update sqlalchemy_dremio to 3.0.2 to use the flight connection.\r\n\r\nRelease Notes\r\n-------------\r\n\r\n3.0.4\r\n-----\r\n- Addressing issue #34 and #37: Add driver name to dialects\r\n\r\n3.0.3\r\n-----\r\n- Add back missing routing_engine property.\r\n\r\n3.0.2\r\n-----\r\n- Add implementations of has_table and get_view_names.\r\n\r\n3.0.1\r\n-----\r\n- Made connection string property keys case-insensitive\r\n- Fix incorrect lookup of the token property\r\n- Fix incorrect lookup of the DisableCertificateVerification property\r\n",
"bugtrack_url": null,
"license": "Apache Software License",
"summary": "A SQLAlchemy dialect for Dremio via the Flight interface.",
"version": "3.0.4",
"project_urls": {
"Homepage": "https://github.com/narendrans/sqlalchemy_dremio"
},
"split_keywords": [
"sqlalchemy_dremio"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5c6d5f88c84e5c4c616c6c25b3ab44e91487272baaa8c701365ccec09267c916",
"md5": "191ee259e952005c3a3f4f64e7f6e1cd",
"sha256": "346048c611c42bfd15ced3219100f0f334efbf203729d28eb0ededce892b2f12"
},
"downloads": -1,
"filename": "sqlalchemy_dremio-3.0.4.tar.gz",
"has_sig": false,
"md5_digest": "191ee259e952005c3a3f4f64e7f6e1cd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 16133,
"upload_time": "2024-06-19T07:20:14",
"upload_time_iso_8601": "2024-06-19T07:20:14.777096Z",
"url": "https://files.pythonhosted.org/packages/5c/6d/5f88c84e5c4c616c6c25b3ab44e91487272baaa8c701365ccec09267c916/sqlalchemy_dremio-3.0.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-19 07:20:14",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "narendrans",
"github_project": "sqlalchemy_dremio",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlalchemy-dremio"
}
JSON
