DWOPT - Datawarehouse Operator

Dwopt is a Python package that attempts to streamline the insight generation process when working with database tables.

The interface between databases and python can often be unstreamlined. Does one read in millions of rows before doing anything, or run sql elsewhere and copy some CSVs around, or write up some embedded sql in the middle of a python script?

Dwopt allows frictionless running of sql codes/scripts, default credentials on the system keyring, simple query generation via code, making & running common summary queries, DDL, DML statement via pre-built templates. It also logs the sql used along the way.

All together, for common analytics, an Excel-pivot table or dataframe summary function like experience on large database tables could be effortlessly achieved, see examples in the Features & the Walk Through section.

Table of contents

• Overview
  • Installation
  • Features
  • Walk Through
• API Reference
  • The Set-up Functions
  • The Database Operator Class
  • The Query Class