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
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.
dbcat is distributed as a python application.
python3 -m venv .env
pip install dbcat
dbcat catalog add-sqlite --name sample --path <path to sqlite db>
dbcat catalog scan --source-name sample
The following databases are supported:
- AWS Redshift
- AWS Athena