Hacker GitHub

← All repos

totalhack/zillion

View on GitHub ↗ ★ 207 Python

Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/

25 mentions on Hacker News by 2 people: 0 stories, 25 comments · first 2022-12-30 · latest 2025-03-18

Mentions per year 25 mentions · busiest year 2023 (15)
20082026
AllStoriesComments NewestTopOldest
  1. …in I-hope-to-put-more-time-into-this-someday mode. Been busy with an acquisition this year. https://github.com/totalhack/zillion
    comment by totalhack · 2025-03-18 · in Building AI agents to query your databases
  2. …take a deeper look at Trilogy soon, always interested to see the variety of approaches to this. https://github.com/totalhack/zillion
    comment by totalhack · 2024-11-25 · in Show HN: Trilogy – A Reusable, Composable SQL Experiment
  3. If I'm understanding your intent correctly, I think you could do that with Zillion. https://github.com/totalhack/zillion Disclaimer: been sidetracked by an acquisition at my day job this year, intend to put more time into this project…
    comment by totalhack · 2024-11-25 · in Show HN: Trilogy – A Reusable, Composable SQL Experiment
  4. …I use it to power my company's BI but haven't put as much time into the polish as you guys. https://github.com/totalhack/zillion
    comment by totalhack · 2024-04-23 · in Show HN: Hashquery, a Python library for defining reusable analysis
  5. …I use this in production in my company but obviously use at your own risk as it's a one-man show. https://github.com/totalhack/zillion
    comment by totalhack · 2024-02-27 · in Apache Superset
  6. …technique, and can also join data across different data sources in a secondary execution layer. https://github.com/totalhack/zillion Disclaimer: this project is currently a one man show, though I use it in production at my own company.
    comment by totalhack · 2024-01-20 · in Let's talk about joins
  7. …for, we use this approach for ~all day to day querying and a chunk of backend SQL replacement. https://github.com/totalhack/zillion
    comment by totalhack · 2024-01-15 · in Vanna.ai: Chat with your SQL database
  8. …of a semantic layer I made below, but there are others out there with more support behind them. https://github.com/totalhack/zillion
    comment by totalhack · 2024-01-15 · in Vanna.ai: Chat with your SQL database
  9. …Though TBH a good UI over a semantic layer is so easy it makes the natural language approach moot. https://github.com/totalhack/zillion
    comment by totalhack · 2024-01-15 · in Vanna.ai: Chat with your SQL database
  10. …semantic layer. I built (and open-sourced) one for use in my own business but Cube looks well done. https://github.com/totalhack/zillion
    comment by totalhack · 2023-12-14 · in The new local data stack: Integrating Dagster, dbt and DuckDB
  11. https://github.com/totalhack/zillion Semantic data warehousing and analytics tool written in python. It has experimental/half-baked NLP features to query your warehouse by interacting with the semantic layer with AI, instead of the normal…
    comment by totalhack · 2023-10-12 · in Ask HN: Show me your half baked project
  12. …being formed? My preferred approach is implemented in Zillion, which I use for BI at my company: https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-26 · in Yandex open sourced it's BI tool DataLens
  13. …use cases. If I wasn't rolling my own I'd probably start with Metabase or Superset. What I use: https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-26 · in Yandex open sourced it's BI tool DataLens
  14. …approaches just seem kinda silly unless you have interface constraints (like on a mobile device). https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-21 · in SQL Join Flavors
  15. …and fall back to SQL when needed. This balance will be different for each business of course. * https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-16 · in Relational is more than SQL
  16. …it. Entity-attribute-value tables, views, JSON columns (as a last resort), or a semantic layer like https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-16 · in Relational is more than SQL
  17. …yield some notable improvement in abilities, as I view it as more of a toy feature at the moment. * https://github.com/totalhack/zillion
    comment by totalhack · 2023-09-01 · in Fine-tuning GPT-3.5-turbo for natural language to SQL
  18. …of the semantic layer solving >95% of use cases and custom SQL as needed in backend processing. https://github.com/totalhack/zillion
    comment by totalhack · 2023-07-08 · in LlamaIndex: Unleash the power of LLMs over your data
  19. …don't know of any easy way to diff the license file against what I presume is a GPLv3 base layer(?) https://github.com/totalhack/zillion/blob/v0.9.14/LICENSE
    comment by mdaniel · 2023-05-01 · in Cube.js: Headless Semantic Layer
  20. …for that). There is some up front cost to getting configured but it pays off in my case at least. https://github.com/totalhack/zillion
    comment by totalhack · 2023-05-01 · in Cube.js: Headless Semantic Layer
  21. …you to specify joins ahead of time outside of optionally defining a tree-like table lineage: https://github.com/totalhack/zillion
    comment by totalhack · 2023-05-01 · in Cube.js: Headless Semantic Layer
  22. Built it for me, but available to all -- Zillion: a python data modeling and analytics library. https://github.com/totalhack/zillion
    comment by totalhack · 2023-04-29 · in Ask HN: Most interesting tech you built for just yourself?
  23. Zillion: https://github.com/totalhack/zillion A python data warehousing / modeling / analytics library that can unify multiple datasources and writes SQL for you. It's alpha level at the moment and I just slowly chip away when time allows,…
    comment by totalhack · 2023-01-27 · in Ask HN: Those making $0/month or less on side projects – Show and tell
  24. …of those questions could be answered in seconds using a warehouse tool like Looker or Metabase or https://github.com/totalhack/zillion (disclaimer: I'm the author and this is alpha-level stuff, though I use it regularly).
    comment by totalhack · 2023-01-25 · in Replacing a SQL analyst with 26 recursive GPT prompts
  25. …agnostic" part, but I already achieve that through SQLAlchemy Core and/or a warehouse layer like https://github.com/totalhack/zillion (disclaimer: I'm the author and this is alpha-level stuff, though I use it regularly). It seems like many…
    comment by totalhack · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement