Data Catalog for Databases and Data Warehouses
Overview
dbcat scans and maintains metadata from all your databases and data warehouses. dbcat also stores metadata generated by other data governance applications such as PIICatcher and Lineage Engine. dbcat is typically used alongside other applications. It can also be used stand-alone to generate a very simple data catalog using the CLI or API.
dbcat stores the catalog in a Postgresql or SQLite database. By default, the catalog is stored in a SQLite
database in ~/.config/tokern/catalog.db
The catalog can be exported to Datahub or Amundsen. This is very useful to export PII tags or column lineage generated by PIICatcher or Lineage Engine. Check documentation for detailed instructions to set PII tags and column-level lineage.
Quick Start
dbcat is distributed as a python application.
python3 -m venv .env
source .env/bin/activate
pip install dbcat
dbcat catalog add-sqlite --name sample --path <path to sqlite db>
dbcat catalog scan --source-name sample
Documentation
For advanced usage refer documentation Catalog Documentation.
Supported Technologies
The following databases are supported:
- MySQL/Mariadb
- PostgreSQL
- AWS Redshift
- BigQuery
- Snowflake
- AWS Athena
Release files for dbcat 0.15.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbcat-0.15.0.tar.gz | 26.2 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbcat-0.15.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 59.2 kB
Release files / dbcat-0.15.0.tar.gz
| Download URL | dbcat-0.15.0.tar.gz |
|---|---|
| Size | 26.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
a1f547ed1e0845bf9e3fd45ab58a8d7ec3e40daf7153d2f4a52adaad1ed60a59
|
|
BLAKE2b-256 checksum How to use checksums |
0007f02ce063b329a48c07adf77f844f979901748f53d1b25ebc3510d711173f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.2.2 CPython/3.8.18 Linux/6.2.0-1012-azure
|
Release files / dbcat-0.15.0-py3-none-any.whl
| Download URL | dbcat-0.15.0-py3-none-any.whl |
|---|---|
| Size | 33.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
8a1970b84ebd778ae2ab22a96959c7b9544a20a371830940066ae47c13daa6c0
|
|
BLAKE2b-256 checksum How to use checksums |
57264ccff21b2112992116436ecdcf1f35e0ec8ab7bb8cfd3ecdb8b8aeaf13e1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.2.2 CPython/3.8.18 Linux/6.2.0-1012-azure
|
