Why Civic Data Matters: 5 Lessons From BetaNYC’s CityCamp
CityCamp highlighted the biggest challenges in NYC civic data-from discoverability and data quality to accountability and collaboration. Our Data Matchmaking workshop showed how communities can bridge silos and push for more accessible, reliable, and impactful civic data.
SQLMesh Guide: 5 Key Patterns & Best Practices for Data Teams
Master 5 SQLMesh best practices- faster environments, safer testing, and zero-downtime deployments for a modern data workflow.
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).