Errata

Analytics Engineering with SQL and dbt

Errata for Analytics Engineering with SQL and dbt

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Page Figure 2-4. Snowflake schema model
2. Data Modelling for Analytics

duplicate DimCity icon, should be DimCountry

Note from the Author or Editor:
Corrected for publication

 albert_yeah  Aug 18, 2023  Dec 08, 2023
Page many pages
everywhere

"dbt" should always be lowercase

Note from the Author or Editor:
Thank you for your feedback. It’s now corrected across the book

Jeremy Cohen  Aug 25, 2023  Dec 08, 2023
Page 60
first

The NPS calculation (in SQL) looks incorrect. It's just subtracting detractors from promotors.

Note from the Author or Editor:
Hello Marc, thank you very much for pointing it out. Indeed, the NPS formula has a typo. The comments within Example 2-22 are correct, but the actual SQL code missed the percentage subtraction between Promoters and Detractors. Instead, it used the total number of Promoters and subtracted with the total number of Detractors.

 Marc  Jan 24, 2024 
Page 212
Multiple selections

It is: “It will run the dbt model named fct_orders only if it has the tag marketing.”
It should be: “It will run the dbt model named fct_orders and any other model that has the tag marketing.”.
The whitespace character indicates union. Intersection is indicated by the coma character.
See the docs under /reference/node-selection/set-operators#unions

Note from the Author or Editor:
Hello Mike. Thank you for noticing this typo. Indeed, what it written “It will run the dbt model named fct_orders only if it has the tag marketing.” should be “It will run the dbt model named fct_orders and any other model that has the tag marketing.”

 Mike  Mar 31, 2024 
Page 238
1st line

The sentence “Looking at what you did, the macro in Example 5-11 doesn’t seems to be very powerful or static.” needs some improvements both when it comes to the grammar as well as the facts (the macro in Example 5-11 is static).

Note from the Author or Editor:
Hello Mike. Thank you for spot this issue. Correct, it has a typo in the text. What we read: “Looking at what you did, the macro in Example 5-11 doesn’t seems to be very powerful or static.”, should be read “Looking at what you did, the macro in Example 5-11 doesn’t seems to be much scalable. It has static payment types which will also require recurrent manual interventions. How could we optime...”

 Mike  Apr 04, 2024