Skip to main content
Kira Furuichi

Kira Furuichi

Technical Writer @ dbt Labs

Author Posts

From the Slack Archives: When Backend Devs Spark Joy for Data Folks

An overview of an interesting community slack thread about the relationship between data folks and backend developers

COALESCE SQL function: Why we love it

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.

EXTRACT SQL function: Why we love it

In this post, we’re going to give a 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.

LOWER SQL function: Why we love it

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.

DATE_TRUNC SQL function: Why we love it

The DATE_TRUNC function will truncate a date or time to the first instance for a given date part maintaining a date format. Wordy, wordy, wordy! What does this really mean?

DATEDIFF SQL function: Why we love it

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.

A star (generator) is born

One of the macros dbt utils offers is the `star` generator. This dbt macro is one of our favorites because it lets you select all the fields you want without writing the columns you don't.