Skip to main content

A column lineage parser and dashboarding tool

Project description

dbt-colibri header

PyPI version Python Support License: MIT

A lightweight, developer-friendly CLI tool and self-hostable dashboard for extracting and visualizing column-level lineage from your dbt projects.

Built for data teams who want transparent, flexible lineage tracking without vendor lock-in or complex enterprise tooling.

Why dbt-colibri?

  • 🔍 Complete visibility: Easy UI, track how every column flows through your dbt transformations
  • ⚡ Fast & lightweight: Generate reports in seconds from your existing dbt artifacts
  • 🏠 Self-hosted: No cloud dependencies or external services required

Documentation site: https://www.docs.colibri-data.com

dbt-colibri dashboard

Quick Start

Installation

# Using uv (recommended)
uv add dbt-colibri

# Using pip
pip install dbt-colibri

Basic Usage

  1. Run dbt to generate the required artifacts:

    dbt compile
    dbt docs generate
    
  2. Generate lineage report:

    colibri generate
    
  3. View results: Open dist/index.html in your browser

That's it! Your column lineage dashboard is ready. Note you can also use dbt run/build, to generate the manifest.json.

Documentation

CLI Commands

colibri generate

Generates column lineage reports from your dbt project.

colibri generate [OPTIONS]

Options:

  • --manifest: Path to dbt manifest.json (default: target/manifest.json)
  • --catalog: Path to dbt catalog.json (default: target/catalog.json)
  • --output-dir: Output directory (default: dist/)
  • --help: Show help message
  • --light: For very big dbt projects, excludes attributes like compiled SQL and returns smaller HTML file.

Output Files

  • colibri-manifest.json: Lineage data
  • index.html: Interactive (standalone) visualization dashboard

Project Structure

your-dbt-project/
├── target/
│   ├── manifest.json    # Generated by dbt
│   └── catalog.json     # Generated by dbt docs generate
└── dist/                # Generated by colibri
    ├── index.html       # Interactive dashboard
    └── colibri-manifest.json

Advanced Usage

CI/CD Integration

The easiest way to deploy your static html is through github/gitlab pages (if you are on enterprise license you can do this privately)

You can find the full example workflow at docs/github_pages_example.yml.

General idea

  1. After every change to the production dbt code (push the main branch), GitHub Actions will:
    • Set up Python and install dependencies with uv.
    • Compile and generate docs needed for colibri.
    • Run colibri generate to build the static HTML report in the dist/ folder.
  2. The dist/ folder is uploaded as an artifact and deployed natively to GitHub Pages using the official actions/deploy-pages action.
  3. The result is available at your repository’s Pages URL.

Gitlab has similar functionality. Other options are writing the file to a bucket and mount it into a web server container (nginx).

Technical Details

Requirements

  • Python: tested on versions 3.9, 3.11, 3.13

  • Supported dbt Adapters:

    • Snowflake,
    • BigQuery,
    • Redshift,
    • duckDB,
    • Postgres
    • Databricks (limited to SQL models)
    • Athena
    • Trino
    • SQL Server (TSQL)
    • ClickHouse
    • Oracle

dbt Compatibility

dbt-core Version Status
1.8.x ✅ Tested
1.9.x ✅ Tested
1.10.x ✅ Tested

Architecture

dbt-colibri leverages:

  • SQLGlot for SQL parsing and column lineage extraction
  • dbt artifacts (manifest.json, catalog.json) for metadata
  • Static HTML/JS for zero-dependency dashboard deployment

Contributing

We welcome contributions! Raise an issue or request a feature, if you are open to contribute you can let us now in the issue.

Development Setup

# Clone the repository
git clone https://github.com/your-org/dbt-colibri.git
cd dbt-colibri

# Install development dependencies
uv sync --dev

# Run tests
pytest

# Format code
ruff format

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

This project builds upon excellent open source work:


Project details


Download files

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

Source Distribution

dbt_colibri-0.3.3.tar.gz (1.2 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

dbt_colibri-0.3.3-py3-none-any.whl (1.2 MB view details)

Uploaded Python 3

File details

Details for the file dbt_colibri-0.3.3.tar.gz.

File metadata

  • Download URL: dbt_colibri-0.3.3.tar.gz
  • Upload date:
  • Size: 1.2 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.11.9 {"installer":{"name":"uv","version":"0.11.9","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for dbt_colibri-0.3.3.tar.gz
Algorithm Hash digest
SHA256 1f04e13bc7ed2e90519ab3bd1fdffc5b79bb718cb97e3aabb81e379cf235e469
MD5 1f58e72ced8573a21525476f270610b7
BLAKE2b-256 d76e8aa71bfdf39775bbe868d3ea8768078e2adb29d827c4fdd31a6a9dabd3f0

See more details on using hashes here.

File details

Details for the file dbt_colibri-0.3.3-py3-none-any.whl.

File metadata

  • Download URL: dbt_colibri-0.3.3-py3-none-any.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.11.9 {"installer":{"name":"uv","version":"0.11.9","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for dbt_colibri-0.3.3-py3-none-any.whl
Algorithm Hash digest
SHA256 4e9abccdd2d91a3b3ce011350e64546e3f5bdf0957f3cac9a7d2d1a45a34b82f
MD5 01ac815fb27705f3f2fa112e0d4730ad
BLAKE2b-256 d2e10f0f55116207ebce8c80c87e6857e2af7d3e92575cdeda3e7324e7a4b26e

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page