7. Cell reactivity and Count's local db: Getting Started in Count

Supercharge your analytics by leveraging reactive cells and an in-memory DuckDB database to cut query times and lighten the load on your production warehouse. We walk through how every change to a parent cell automatically updates everything downstream, then show you how to inspect the compiled SQL DAG for each cell right in Count. By switching downstream cells from BigQuery to a local DuckDB (counts-in-memory) data source—spotlighted by matching colors—you’ll run one big query, cache the results, and perform all your analysis locally. This simple tweak not only speeds up your workflow and reduces database load, it fits into a winning data strategy that boosts business impact, enhances collaboration and stakeholder alignment, and elevates your data storytelling.