Kira Furuichi

Kira Furuichi 27 Mar 2023 March 27, 2023 Kira Furuichi

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

Kira Furuichi 27 Mar 2023 March 27, 2023 Kira Furuichi

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

Erin Vaughan | Kira Furuichi 24 Mar 2023 March 24, 2023 Erin Vaughan, Kira Furuichi

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

Kira Furuichi 23 Mar 2023 March 23, 2023 Kira Furuichi

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

Kira Furuichi 15 Mar 2023 March 15, 2023 Kira Furuichi

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!

David Krevitt | Jason Ganz | Kira Furuichi 30 Jan 2023 January 30, 2023 David Krevitt, Jason Ganz, Kira Furuichi

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

Amada Echeverría | David Krevitt | Ian Fahey | Julia Schottenstein | Kira Furuichi | Sung Won Chung 15 Nov 2022 November 15, 2022 Amada Echeverría, David Krevitt, Ian Fahey, Julia Schottenstein, Kira Furuichi, Sung Won Chung

Ask anyone at dbt Labs, the most special week of the year for dbt is Coalesce. There’s so much work, anticipation, and anxiety that goes into Coalesce: Will talks resonate with the Community? How can we ensure speakers feel confident? Will folks be excited about new product launches? How can we make the online and...

Kira Furuichi 23 Aug 2022 August 23, 2022 Kira Furuichi

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 going to want to miss. Find out what’s new and what to expect from the third year of the Analytics Engineering Conference.

Andrew Escay | Kira Furuichi 1 Aug 2022 August 1, 2022 Andrew Escay, Kira Furuichi

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.

Ian Fahey | Kira Furuichi 13 Jul 2022 July 13, 2022 Ian Fahey, Kira Furuichi

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

Kira Furuichi 13 Jul 2022 July 13, 2022 Kira Furuichi

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

Kira Furuichi 5 Jul 2022 July 5, 2022 Kira Furuichi

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

Kira Furuichi 5 Jul 2022 July 5, 2022 Kira Furuichi

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.

Erica Louie | Kira Furuichi 5 Jul 2022 July 5, 2022 Erica Louie, Kira Furuichi

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.

Kira Furuichi 29 Jun 2022 June 29, 2022 Kira Furuichi

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.

Kira Furuichi 28 Jun 2022 June 28, 2022 Kira Furuichi

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.

Kira Furuichi 28 Jun 2022 June 28, 2022 Kira Furuichi

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.

Erica Louie | Kira Furuichi 28 Jun 2022 June 28, 2022 Erica Louie, Kira Furuichi

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

Brandon Thomson | Kira Furuichi 28 Jun 2022 June 28, 2022 Brandon Thomson, Kira Furuichi

This playbook dives into how dbt Labs thinks and implements reverse ETL workflows for our internal analytics work.