PyExasol
PyExasol is the officially supported Python connector for Exasol. It facilitates handling of the massive volumes of data commonly associated with Exasol, and provides a significant performance improvement over existing ODBC/JDBC solutions in single-process scenarios involving pandas.
PyExasol provides an API to read and write multiple data streams in parallel using separate processes, which is necessary to fully utilize hardware and achieve linear scalability. With PyExasol you are no longer limited to a single CPU core.
PyExasol main concepts
-
Based on the WebSocket protocol
-
Optimized for minimum overhead
-
Easy integration with pandas through HTTP transport
-
Compression to reduce network bottleneck
For more information, documentation, and source code, visit the PyExasol repository on GitHub.