data-dealer

A command line interface for the Data Dealer


License
MIT
Install
pip install data-dealer==0.0.4

Documentation

data-dealer (0.0.4)

A Python wrapper for data virtualization, ETL and serialization as a pandas dataframe.

Installation

pip install data-dealer

Integrations

  • .json and .csv file formats
  • MS SQL Server
  • AWS DynamoDB
  • AWS Redshift
  • AWS Athena (In Development)
  • AWS s3 (In Development)

Registry

In order to begin using the data dealer, you must register some suppliers. The following CLI commands will help you manage your registry

Register a new supplier

dealer registry -s test-supplier -p "dbms=mssql;host=localhost;uname=MyUsername;pword=MyPassword" add

Valid supplier properties:

  • dbms (athena, mssql, dynamo)
  • host
  • port
  • uname
  • pword
  • aws_key
  • aws_secret

Load a registry from file

dealer registry -s ~/registry.yaml load

Display current registry

dealer registry [display|show]

Remove a supplier from the registry

dealer registry -s test-supplier remove

To-Do List:

Too many things to count