I Tried MotherDuck, DuckDB in the Cloud, and It’s a Game-Changer
If you’ve used DuckDB, you know how fast and convenient it is for local analytical work. But what if you could take that same performance, extend it to the cloud, and make it collaborative without introducing complexity?
Evaluating Stripe Ingestion Frameworks: Our Process, Benchmarks, and Findings
We evaluated six tools (Fivetran, Airbyte, Meltano, Estuary Flow, dlt, and Stripe Sigma) to determine the most effective way to ingest Stripe data. From real-time capabilities to developer flexibility, our hands-on testing revealed key trade-offs that every data team should consider.
Getting Started with dlt: A Simple, Scalable Way to Handle Data Ingestion
Ingestion used to feel like the unglamorous part of the data pipeline- until we tried dltHub.
Snowflake Is Deprecating Password-Only Sign-ins: Here’s What You Need to Know
Snowflake is phasing out password-only logins by November 2025—impacting both human and service users. If you’re not ready with proper MFA, OAuth, or key-pair setups, your data access could break. Here’s what’s changing, who’s affected, and how to migrate securely.
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.