Kira Furuichi

We're talking about the benefits of cloud migration—all the nitty-gritty on cost savings, security concerns, governance abilities, & scaling your data work.

Migrating to the cloud comes with *real* challenges. We're unpacking what those cloud migration challenges are and offering pragmatic solutions.

Explore the data modeling techniques (relational, ER, dimensional, and data vault) that data teams use to model their data and create actionable insights.

A data quality framework develops trust between your team and the business and establishes a system of governance and accountability for your data quality.

The data transformation process can be broken down into six steps: extraction and loading, exploration, transformation, testing, documentation, and deployment.

Foundational data quality checks you should be running on your data cover the concepts of uniqueness, non-nullness, acceptance, referential integrity, and freshness.

Data quality testing is the practice of using code-based and automated data quality tests to know whether these assertions you make about your data are...

Data quality dimensions create a general profile of your data's quality. How you define what "good" data quality is depends on how that data is...

The main differences between ETL and ELT lie in when and where data transformation occurs—changes that might seem small but come with big implications!

A technical writing mentorship program for the dbt Community, sponsored by dbt Labs.

Read this blog post to learn about the five important perspectives gained from Coalesce 2022.

October 17-21, 2022: Coalesce is back and in-person! With 100+ speakers and sessions, 3 global locations and a virtual option, it’s a week you’re not...

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...

This post is part of our “Orchestrating my day” series where data folks walk us through their daily experiences.

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...

The DATE_TRUNC function will truncate a date or time to the first instance for a given date part maintaining a date format.

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...

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...

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....

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...

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...

Erica Louie, Head of Data at dbt Labs, walks us through her typical daily routine, challenges, and workflows.