Zum Hauptinhalt springen

Commit to a grain check

Create a concrete commitment to state and verify query grain.

sql-fundamentals5 min read

A GROUP BY, revenue, conversion, or retention query that will be shared with another person this week. When I write or review this query, I will add a grain comment in the form: -- grain: one row per ___ per ___. Then I will run one check that compares the expected number of groups to the actual number of result rows. In 3 days, check whether you used the drafted SQL action and whether it changed the query result, review comment, or metric confidence. A dashboard query using COUNT, SUM, or GROUP BY that others rely on this week. A…

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Kontakt aufnehmen