etlhelper is Python ETL library to simplify data transfer into and out of databases.
etlhelper is a Python ETL library to simplify data transfer into and out of databases.
ETL Helper makes it easy to run SQL queries via Python and return the results. It takes care of cursor management, importing drivers and formatting connection strings, while providing memory-efficient functions to read, write and transform data. This reduces the amount of boilerplate code required to manipulate data within relational databases with Python.
ETL Helper is available on PyPI.
pip install etlhelper
Database driver packages are not included by default and should be specified in square brackets.
Options are oracle (installs oracledb), mssql (installs pyodbc) and postgres (installs psycopg2).
Multiple values can be separated by commas.
pip install etlhelper[oracle,postgres]
See the individual database driver configuration pages for any OS-level dependencies.
ETL Helper was created by and is maintained by British Geological Survey Informatics.
See CONTRIBUTING.md for details on how to contribute.
ETL Helper is distributed under the LGPL v3.0 licence. Copyright: © BGS / UKRI 2019
FAQs
etlhelper is Python ETL library to simplify data transfer into and out of databases.
We found that etlhelper demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 3 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.