Vena's ETL Python Interface

Introduction

vepi is a lightweight Python library designed to make automating you ETL processes simple and efficient. Whether you want build automation script to extract data or need a reliable way to load your data into Vena with minimal setup.

What is supported

The python library currently supports a range of powerful ETL and job management capabilities:

• Data Import: Load data from multiple sources, including:
  • Directly from a pandas.DataFrame
  • From CSV files
• Data Export: Retrieve processed data with custom page sizes
• Dimension Hierarchy: Access and inspect dimension hierarchies
• Job Management: Run and manage jobs with ease:
  • Execute jobs with template IDs.
  • Full control with step-by-step job creation, submission, status checks, and completion handling.
  • Cancel running jobs.
• Error Handling: Comprehensive error handling for invalid credentials, missing fields, API communication issues, data validation errors, and job-related failures.

Installation

Install vepi from PyPI:

pip install vepi

Basic Requirements

Python: 3.7 or higher Operating System: Works on Windows, macOS, and Linux

Links

PyPI: https://pypi.org/project/vepi/

GitHub Repository: https://github.com/venasolutions/vena-etl-python-interface

The full source code can be found at the links above. Feel free to report issues or request features here