The Stripe Modeling Guide We Wish We Had
From time zone confusion to tricky MRR logic and FX conversion delays, building reliable Stripe models takes more than a plug-and-play mindset. We break down what to watch for—and how to fix it using dbt.
What We Delivered for Our Serverless Data Stack
We built a serverless data stack from the ground up using DuckDB, SQLMesh, and S3 for a global nonprofit. Our open-source-first approach eliminated SaaS dependencies while empowering developers with reproducible environments, Python-powered transformations, and collaborative workflows.
How to Set Up dbt on Windows (Step-by-Step)
Get dbt up and running on your Windows with this step-by-step guide. Learn how to set up Python, Git, virtual environments, and profiles.yml for a smooth dbt development experience.
AWS Cross-Account Authentication in a Data Pipeline
Forget hardcoded credentials. We built a bulletproof AWS pipeline that scales across accounts (with zero vendor lock-in).
How to Set Up dbt on Mac (Step-by-Step)
Get dbt up and running on your Mac with this step-by-step guide. Learn how to set up Python, Git, virtual environments, and profiles.yml for a smooth dbt development experience.
Lightdash: The Open-Source BI Tool That Puts Your Data to Work
Explore how Lightdash integrates seamlessly with dbt to deliver powerful BI dashboards, metric definitions in YAML, and self-serve analytics. Learn its strengths, limitations, pricing, and how it compares to other data visualization tools.
DuckDB Meets SQLMesh: Building a Lean Data Architecture For One of the World’s Leading Intergovernmental Organizations
Learn how Database Tycoon built a cost-effective, open-source data lakehouse using DuckDB, SQLMesh, S3, and GitHub Actions for a global humanitarian organization. Discover the pros and cons of modern data tools, including Iceberg, in real-world, serverless environments.
DataKitchen Review: Automating DataOps with Smart Testing & Observability
Data teams are under constant pressure to ensure high-quality, reliable pipelines while juggling increasing complexity. Automation can be a game-changer, but not all tools deliver on their promises. That’s where DataKitchen comes in—offering a DataOps platform designed to streamline testing, orchestration, and observability.
Debating the Data Stack: Why We Chose SQLMesh Over dbt (and DuckDB in the Mix)
In early 2024, Database Tycoon partnered with a major intergovernmental organization to build something bold: a fully open-source, serverless data lake powered by CSV uploads to AWS S3- with no paid software and no complex infrastructure.
What Are SDF Labs and Quary? A Dive Into Last Week’s Big Data Acquisitions
It’s big news when one company gets acquired, but in the data industry, we just saw it happen twice in the same week.