Skip to main content

Extracts data structure from various sources.

Project description

With this tool you can inspect various data sources and generate data inventory tables. Data inventory table essentially contains list of tables and table columns of a specified data source.

Inventory tables are designed to be easily readable and editable using a spreadsheet program.

Here is an example how you can generate inventory table from a CSV file:

inventory-table inspect cvs data.cvs

How to install

In order to install this tool, first you need to install Python. When you have Python installed, then install data inventory tool like this:

pip install data-inventory-tool

Generating inventory table

PostgreSQL

For PostgreSQL first you need to install PostgreSQL driver:

pip install psycopg2-binary

Then generate inventory table like this:

inventory-table inspect sql postgresql://user:password@host:port/db

MySQL

For MySQL first you need to install MySQL driver:

pip install mysqlclient

Then generate inventory table like this:

inventory-table inspect sql mysql+mysqldb://user:password@host:port/db

Troubleshooting

If you get errors like this:

Error: Database driver not found: No module named 'psycopg2'.
See: https://docs.sqlalchemy.org/en/13/dialects/index.html

That means, you don’t have a required database driver installed.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for data-inventory-tool, version 0.1.5
Filename, size File type Python version Upload date Hashes
Filename, size data_inventory_tool-0.1.5-py3-none-any.whl (9.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size data-inventory-tool-0.1.5.tar.gz (6.9 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page