1
0
Fork
You've already forked cantrip
0
A lightweight, hand-crafted, semantic layer as a library.
  • Python 99.6%
  • Shell 0.3%
Beto Dealmeida 38d53144f1
All checks were successful
Publish Docs / docs (push) Successful in 1m9s
Merge pull request 'docs: more examples for segments' ( #50 ) from segments-examples into main 
Reviewed-on: #50
2026年05月02日 04:39:52 +02:00
.forgejo/workflows Improve types 2026年04月29日 21:34:00 -04:00
docs docs: more examples for segments 2026年05月01日 22:39:27 -04:00
examples Improving style 2026年04月26日 15:40:32 -04:00
scripts Split service 2026年04月22日 12:16:18 -04:00
src/cantrip More work 2026年05月01日 18:51:19 -04:00
tests Add tests 2026年05月01日 19:29:05 -04:00
.coveragerc
.flake8
.gitignore More work 2026年04月26日 15:12:58 -04:00
.pre-commit-config.yaml
cantrip-i-cla.md
databases.yml.example
docker-compose.yml
LICENSE
Makefile Fix Makefile 2026年04月23日 16:27:28 -04:00
poetry.lock Testing 2026年04月26日 16:04:23 -04:00
pyproject.toml Testing 2026年04月26日 16:04:23 -04:00
README.md docs: derived metrics 2026年04月28日 15:48:56 -04:00
setup.cfg
TODO.md More work 2026年05月01日 18:51:19 -04:00

💫 Cantrip

Cantrip is a lightweight, hand-crafted, semantic layer as a library, written in modern Python. Semantics are stored as database views, so you can use native SQL to define metrics, dimensions, relationships and more, without the need for any external services. Cantrip generates the SQL queries needed to compute arbitrarily complex requests for multiple metrics and dimensions, and can even run the query for you.

Currently supported/planned databases:

  • SQLite
  • DuckDB
  • Postgres
  • BigQuery
  • Snowflake
  • MariaDB
  • MySQL
  • Oracle (19c)
  • Databricks
  • SQL Server
  • CockroachDB
  • ClickHouse
  • Redshift
  • Trino

Learn more.