This piece is about how direct collaboration with engineers for event tracking is the best axe to wield in product analytics, and how our data team went about benchmarking IDE performance.
Read article
This post is part of our “Orchestrating my day” series where data folks walk us through their daily experiences.
Read article
The STAR dbt macro generates a a comma-separated list of all fields that exist in the `from` relation and excludes any fields listed in an `except` argument
Read article
The DATE_TRUNC function will truncate a date or time to the first instance for a given date part maintaining a date format.
Read article
The DATEDIFF function will return the difference in specified units (ex. days, weeks, years) between a start date/time and an end date/time. It’s a simple and widely used function that you’ll find yourself using more often than you expect.
Read article
dbt Labs recent underwent a massive overhauling of our OKR framework. Erica Louie, Head of Data, shares how we think about OKRs and a solution to measuring them that works for us.
Read article
The COALESCE SQL function is an incredibly useful function that allows you to fill in unhelpful blank values that may show up in your data.
Read article
Deep dive into the EXTRACT function, how it works, and why we use it. The EXTRACT function allows you to extract a specified date part from a date/time.
Read article
The LOWER SQL Function allows you to return a string value as an all lowercase string. It’s an effective way to create consistent capitalization for string values across your data.
Read article
Erica Louie, Head of Data at dbt Labs, walks us through her typical daily routine, challenges, and workflows.
Read article
This playbook dives into how dbt Labs thinks and implements reverse ETL workflows for our internal analytics work.
Read article
The 2022 Coalesce agenda is now LIVE! Check it out here.