The 'Sprint Zero': Why the Beginning Determines Success
Before we write code, we must lay the foundation. Learn how we create the technical basis for scalable data products in the first two weeks.
Many data warehouse projects fail not because of data complexity, but due to a missing, stable foundation. That’s why we at the Alligator Company have developed the “Sprint Zero” – an initial phase dedicated entirely to creating the ideal working environment.
What Exactly is Sprint Zero?
Sprint Zero is not a planning phase in the classical sense, where only PowerPoint slides are created. It is a phase of active infrastructure implementation. Our goal is that on the first day of “Sprint 1”, every developer can immediately start working productively.
Without this approach, we often experience the so-called “setup chaos”: developers waiting for access rights, databases not being configured, and CI/CD pipelines existing only on paper.
“The biggest mistake in data engineering is trying to deliver results immediately without having built the machine that produces those results.” – Torsten Glunde
The 3 Pillars of Our Infrastructure
We focus on three essential areas, which we set up together with your IT department:
- Automated Deployments (CI/CD): We use dbt Cloud or GitHub Actions to ensure that changes to the data model are automatically tested.
- Environment Separation: A strict separation between Development, Staging, and Production is non-negotiable for us.
- Data Governance Foundation: Defining naming conventions and access concepts (RBAC) in Snowflake or Exasol.
Technical Implementation with dbt
In practice, this means we initialize a dbt project that already contains our best-practice macros. We connect this project to your repository and ensure that a “dbt run” completes without errors – even if no business logic has been implemented yet.
Checklist for Completion
When is Sprint Zero over? When we can tick off the following points:
- Git Repository created & protected
- Database Users & Roles created
- First end-to-end slice (Source to Mart) successful
With this setup, we guarantee that we can maintain the speed we promise over the following 12 weeks.
